Available in versions: Dev (3.20) | Latest (3.19) | 3.18 | 3.17 | 3.16 | 3.15 | 3.14 | 3.13

SQL transformation

Applies to ✅ Open Source Edition   ✅ Express Edition   ✅ Professional Edition   ✅ Enterprise Edition

jOOQ supports a few built in SQL transformations, which can be enabled through a variety of settings. These transformations will produce transformed SQL output regardless if the input was created using the DSL API, or the parser.

Table of contents
ANSI JOIN to table lists
Table lists to ANSI JOIN
QUALIFY to derived table
IN condition subquery with LIMIT to derived table
Unnecessary arithmetic expressions
Pattern based transformation (new)
AND to NOT IN (new)
Arithmetic expressions (new)
COUNT(*) scalar subquery comparison (new)
COUNT(expr) scalar subquery comparison (new)
Empty scalar subquery (new)
Hyperbolic functions (new)
Idempotent function repetition (new)
Inverse hyperbolic functions (new)
Logarithmic functions (new)
Merge AND predicates (new)
Merge BIT_NOT with BIT_NAND (new)
Merge BIT_NOT with BIT_NOR (new)
Merge BIT_NOT with BIT_XNOR (new)
Merge IN predicates (new)
Merge NOT with comparison predicates (new)
Merge NOT with DISTINCT predicate (new)
Merge OR predicates (new)
Merge range predicates (new)
Normalise associative operations (new)
Normalise fields compared to values (new)
Normalise IN list with single element to comparison (new)
OR to IN (new)
Repeated bitwise negation (new)
Repeated logical negation (new)
Repeated NOT (new)
Trigonometric functions (new)
Trim (new)
Trivial case abbreviations (new)
Trivial predicates (new)

previous : next

References to this page


Do you have any feedback about this page? We'd love to hear it!

The jOOQ Logo