The ORDER BY clause could use some subsections which would allow for more dialect specific renderings of certain clauses, including:

• ORDER BY <index>
• ORDER BY .. NULLS FIRST

See:
https://www.jooq.org/doc/latest/manual/sql-building/sql-statements/select-statement/order-by-clause/