jOOQ 3.19 supports explicit path joins, to-many path joins, and implicit join path correlation to greatly simplify your SQL queries| Java, SQL and jOOQ.
A really cool, recent question on Stack Overflow was about how to map a nested collection into a Java Map with jOOQ. In the past, I’ve blogged about the powerful MULTISET operator many times,…| Java, SQL and jOOQ.
When using jOOQ Converters with UNION queries, remember that jOOQ will only consider the first UNION subquery's Converters, since jOOQ doesn't know which subquery contributed which rows.| Java, SQL and jOOQ.
Many applications migrating to jOOQ tend to keep "the old stuff" around by continuing executing queries with JPA, JDBC, JdbcTemplate, etc. and using jOOQ only as a query builder. This article shows numerous benefits of executing jOOQ that users are missing this way.| Java, SQL and jOOQ.
The second best way to fetch a Spring Data JPA DTO Projection is to use jOOQ.| Java, SQL and jOOQ.
