Different To-Many Nesting Algorithms’ Efficiency Compared – Java, SQL and jOOQ.
It has been a while since jOOQ 3.15 was released, introducing its revolutionary standard SQL MULTISET emulation feature. In this …
It has been a while since jOOQ 3.15 was released, introducing its revolutionary standard SQL MULTISET emulation feature. In this …
I came across an interesting question on Stack Overflow about using jOOQ’s MULTISET operator to nest a collection and then …
This release continues the work from previous releases around more sophisticated SQL transformation capabilities, including: Client side computed columns for …
One of jOOQ 3.17‘s coolest new features are client side computed columns. jOOQ 3.16 already added support for server side …
jOOQ is mainly known for its powerful type safe, embedded, dynamic SQL capabilities that are made available through code generation. …
The H2 database is an immensely popular in-memory database product mostly used by Java developers for testing. If you check …
When you write stored procedures and functions in your database, you want to ensure their correctness, just like with your …
Probably the most challenging aspect of standardizing SQL is retrieving data from DML statements. In this article, we explore different …
Starting with jOOQ 3.17, the Condition type extends the Field<Boolean> type. Because, that’s what the SQL standard thinks it is, …
Since jOOQ 3.11, implicit joins have been supported. An implicit join is a JOIN (mostly a LEFT JOIN) that is …