Support for USE INDEX for query hints

[utkarshgpta]

Is your feature request related to a problem? Please describe.
I'm trying to form a query which involves support for USE INDEX clause in SQL - for providing hints to the db engine during query execution. More literature on this can be found here.

Describe the solution you'd like
Similar to the chaining of different kinds of operations that is supported by the library, we can also have functionality for USE INDEX / IGNORE INDEX, etc.

Describe alternatives you've considered
Apart from re-writing the entire query as a string, couldn't find any other solution for the problem.

Dialect

• postgres
• mysql
• sqlite3

Additional context
N/A