Support index hints

[norraxx]

It would be cool to define index hints use index (primary) or ignore index (primary) on tables during select or join.
For example in sqlalchemy it's with_hint clause. https://docs.sqlalchemy.org/en/14/orm/query.html#sqlalchemy.orm.Query.with_hint