MySQL 9.7 Compatibility

This issue is to track what is required to move from MySQL 8.0/8.4 to MySQL 9.7 compatibility.

Note that 8.0, 8.4 and 9.7 are all LTS releases.

Resources:
- [MySQL Worklogs](https://dev.mysql.com/worklog/) for Server-9.x
- [MySQL 9.x Release notes](https://dev.mysql.com/doc/relnotes/mysql/9.6/en/news-9-6-0.html)

## Before 9.7

See #7968

## 9.7.0 and before

- [ ] Inline Foreign Key Constraints
- [ ] https://github.com/pingcap/tiflow/issues/12129
- [ ] https://github.com/pingcap/tiflow/issues/12470
- [ ] https://github.com/pingcap/tidb/issues/45474
- [ ] JSON Duality Views, including DML (previously only available in MySQL Enterprise Edition, https://dev.mysql.com/doc/refman/9.6/en/json-duality-views-updatable.html )
- [ ] Updated DATE handling ( https://dev.mysql.com/worklog/task/?id=16895 )
- [ ] MySQL VECTOR data type and functions
- [ ] Moving away from `mysql_native_password`
- [ ] #68087
- [ ] #68088