Thank you very much for this suggestion. This is currently not supported in jOOQ, out-of-the-box. But it should be. I've created a feature request for this:
In the meantime, you can resort to "plain SQL":
Or to patching the SQL statement using an ExecuteListener.