I also use jooq and it's pretty fantastic. The only problem I've encountered with it so far is some compatibility issues across dialects. I generate code from psql and it's impossible to re-use it in an sqlite database. Perhaps that's a rare use case though