This documentation is for the unreleased development version of jOOQ. Click on the above version links to get this documentation for a supported version of jOOQ.
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
- 4.22.9.1.
- ANSI JOIN to table lists
- 4.22.9.2.
- Table lists to ANSI JOIN
- 4.22.9.3.
- ROWNUM to LIMIT
- 4.22.9.4.
- GROUP BY <column index> (new)
- 4.22.9.5.
- Unnecessary arithmetic expressions
- 4.22.9.6.
- Pattern based transformation
- 4.22.9.6.1.
- AND to NOT IN
- 4.22.9.6.2.
- Arithmetic expressions
- 4.22.9.6.3.
- COUNT(*) scalar subquery comparison
- 4.22.9.6.4.
- Empty scalar subquery
- 4.22.9.6.5.
- Hyperbolic functions
- 4.22.9.6.6.
- Idempotent function repetition
- 4.22.9.6.7.
- Inverse hyperbolic functions
- 4.22.9.6.8.
- Logarithmic functions
- 4.22.9.6.9.
- Merge AND predicates
- 4.22.9.6.10.
- Merge BIT_NOT with BIT_NAND
- 4.22.9.6.11.
- Merge BIT_NOT with BIT_NOR
- 4.22.9.6.12.
- Merge BIT_NOT with BIT_XNOR
- 4.22.9.6.13.
- Merge IN predicates
- 4.22.9.6.14.
- Merge NOT with comparison predicates
- 4.22.9.6.15.
- Merge NOT with DISTINCT predicate
- 4.22.9.6.16.
- Merge OR predicates
- 4.22.9.6.17.
- Merge range predicates
- 4.22.9.6.18.
- Normalise associative operations
- 4.22.9.6.19.
- Normalise fields compared to values
- 4.22.9.6.20.
- Normalise IN list with single element to comparison
- 4.22.9.6.21.
- OR to IN
- 4.22.9.6.22.
- Repeated negation
- 4.22.9.6.23.
- Repeated negation
- 4.22.9.6.24.
- Repeated NOT
- 4.22.9.6.25.
- Trigonometric functions
- 4.22.9.6.26.
- Trim
- 4.22.9.6.27.
- Trivial case abbreviations
- 4.22.9.6.28.
- Trivial predicates
The jOOQ User Manual : SQL building : QueryParts : SQL transformation | previous : next |
Feedback
Do you have any feedback about this page? We'd love to hear it!