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.
- Unnecessary arithmetic expressions
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!