QueryDSL is the way to go currently.
JOOQ is great, but AFAIK it doesnt’t support all databases we need to support in open source edition (like oracle), unless you’re willing to spend a hefty sum for commercial edition. I’ve mentioned this in similar community post