Available in versions: Dev (3.18) | Latest (3.17) | 3.16 | 3.15 | 3.14 | 3.13 | 3.12 | 3.11 | 3.10 | 3.9 | 3.8

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.

QueryParts

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

A org.jooq.Query and all its contained objects is a org.jooq.QueryPart. QueryParts essentially provide this functionality:

Both of these methods are contained in jOOQ's internal API's org.jooq.QueryPartInternal, which is internally implemented by every QueryPart.

The following sections explain some more details about SQL rendering and variable binding, as well as other implementation details about QueryParts in general.

Table of contents

4.22.1.
SQL rendering
4.22.2.
Declaration vs reference
4.22.3.
Pretty printing SQL
4.22.4.
Variable binding
4.22.5.
Custom data type bindings
4.22.6.
Custom syntax elements
4.22.7.
Plain SQL QueryParts
4.22.8.
Serializability
4.22.9.
SQL transformation
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
4.22.10.
Custom SQL transformation
4.22.10.1.
Logging abbreviated bind values

The jOOQ User Manual : SQL building : QueryPartsprevious : next

Feedback

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

The jOOQ Logo