> Jooq isn't bad, but it's not SQL, it's Java trying to be SQL.

Can you elaborate on this? I have been using JOOQ for years (with Kotlin), and I have never had any issues with it "trying to be SQL".