jOOQ effectively combines complex SQL, type safety, source code generation, active records, stored procedures, advanced data types, and Java in a fluent, intuitive DSL.
This is a maintenance release for jOOQ 2.0. The whole jOOQ API is now annotated with a new org.jooq.Supports annotation to help you assess whether a certain SQL clause is available in your database or not (e.g. MySQL, PostgreSQL, or Oracle). Support for the Oracle PIVOT clause. The DATE data type can be mapped to TIMESTAMP. Several convenience methods have been added for more fluent syntax.
URL: jOOQ - jOOQ : A peace treaty between SQL and Java