This release focuses on increased compatibility between various SQL
dialect integrations as far as ARRAY and JOIN support is concerned:
ARRAY types are only available in H2, HSQLDB, Oracle, Postgres.
Nevertheless, they can be somewhat simulated in other dialects using
nested selects with UNION ALL. Increased compatibility leads to a
nicer API, where ARRAYs are used along with ALL/ANY quantifiers, for
instance.
JOIN syntaxes can be quite powerful in SQL. Apart from simulating
NATURAL JOIN, JOIN USING clauses, as well as a synthetic "KEY JOIN"
syntax, jOOQ now also supports nesting JOIN expressions to create more
complex table sources. See a recent blog post on the subject here:
http://lukaseder.wordpress.com/2012/01/15/lets-revise-the-sql-from-clause/
See the full release notes here:
www.jooq.org/notes.php
