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.
- Unnecessary arithmetic expressions
- 4.22.9.5.
- Pattern based transformation (new)
- 4.22.9.5.1.
- AND to NOT IN (new)
- 4.22.9.5.2.
- Arithmetic expressions (new)
- 4.22.9.5.3.
- COUNT(*) scalar subquery comparison (new)
- 4.22.9.5.4.
- Empty scalar subquery (new)
- 4.22.9.5.5.
- Hyperbolic functions (new)
- 4.22.9.5.6.
- Idempotent function repetition (new)
- 4.22.9.5.7.
- Inverse hyperbolic functions (new)
- 4.22.9.5.8.
- Logarithmic functions (new)
- 4.22.9.5.9.
- Merge AND predicates (new)
- 4.22.9.5.10.
- Merge BIT_NOT with BIT_NAND (new)
- 4.22.9.5.11.
- Merge BIT_NOT with BIT_NOR (new)
- 4.22.9.5.12.
- Merge BIT_NOT with BIT_XNOR (new)
- 4.22.9.5.13.
- Merge IN predicates (new)
- 4.22.9.5.14.
- Merge NOT with comparison predicates (new)
- 4.22.9.5.15.
- Merge NOT with DISTINCT predicate (new)
- 4.22.9.5.16.
- Merge OR predicates (new)
- 4.22.9.5.17.
- Merge range predicates (new)
- 4.22.9.5.18.
- Normalise associative operations (new)
- 4.22.9.5.19.
- Normalise fields compared to values (new)
- 4.22.9.5.20.
- Normalise IN list with single element to comparison (new)
- 4.22.9.5.21.
- OR to IN (new)
- 4.22.9.5.22.
- Repeated negation (new)
- 4.22.9.5.23.
- Repeated negation (new)
- 4.22.9.5.24.
- Repeated NOT (new)
- 4.22.9.5.25.
- Trigonometric functions (new)
- 4.22.9.5.26.
- Trim (new)
- 4.22.9.5.27.
- Trivial case abbreviations (new)
- 4.22.9.5.28.
- Trivial predicates (new)
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!