Feature: Support Optimizer Hints in generated queries

[replu]

What do you want to change?

Add support for MySQL Optimizer Hints.

When a query contains Optimizer Hints, the generated code should preserve them as-is. For example, the following query:

SELECT /*+ MAX_EXECUTION_TIME(1000) */ * FROM t1 INNER JOIN t2 WHERE ...

should produce generated code that retains the /*+ ... */ hint comment in the query string, rather than stripping it out.

What database engines need to be changed?

MySQL

What programming language backends need to be changed?

No response