Improved compatibility with Hibernate

# Goal

Improve MySQL compatibility of TiDB to close the gap between the TiDBDialect and MySQLDialect in Hibernate.

This makes it easier for existing Java/Hibernate applications to be migrated to TiDB.

Side effects: Overall better MySQL compatibility.

## Issues

### Important

- [ ] #51650
- [x] #63035

### Moderate

- [ ] `JSON_TABLE()` #14486
- [ ] #65151
- [ ] #18207

### Low

- [x] #65152
- [ ] ON condition with subquery #11414
- [ ] #34626
- [ ] `LOCK IN SHARE MODE`
- [ ] #66392
- [ ] #59233
- [ ] #67943

### Performance

These don't cause the testsuite to fail, but cause the testsuite to take longer.

- [ ] #65753

### Excluded for now

- Stored Procedures
- Triggers
- Language specific collations