mysql: support for optimizer hints

[mickeyreiss]

Is your feature request related to a problem? Please describe.

I would like to generate the following SQL query:

SELECT /*+ MAX_EXECUTION_TIME(1000) */ * FROM orders;

This syntax is defined in the MySQL documentation here.

Describe the solution you'd like

SELECT(Orders.AllColumns).OptimizerHint("MAX_EXECUTION_TIME(100)").FROM(Orders)

[go-jet]

Yeah, it makes sense.

[go-jet]

MySQL optimizer hints included in v2.9.0 release.