jOOQ is far and away the best library in this class for any ecosystem.

It's so good you would need to think long and hard not to choose the JVM for a SQL heavy application because it's just that damn good and most other library requirements are relatively interchangeable.