Available in versions: Dev (3.20) | Latest (3.19) | 3.18 | 3.17 | 3.16 | 3.15 | 3.14 | 3.13 | 3.12 | 3.11 | 3.10
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:
- they can render SQL using the
accept(Context)
method - they can bind variables using the
accept(Context)
method
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
- 3.22.1.
- SQL rendering
- 3.22.2.
- Declaration vs reference
- 3.22.3.
- Pretty printing SQL
- 3.22.4.
- Variable binding
- 3.22.5.
- Custom data type bindings
- 3.22.6.
- Custom syntax elements
- 3.22.7.
- Plain SQL QueryParts
- 3.22.8.
- Serializability
- 3.22.9.
- SQL transformation
- 3.22.9.1.
- ANSI JOIN to table lists
- 3.22.9.2.
- Table lists to ANSI JOIN
- 3.22.9.3.
- ROWNUM to LIMIT
- 3.22.9.4.
- QUALIFY to derived table (new)
- 3.22.9.5.
- IN condition subquery with LIMIT to derived table (new)
- 3.22.9.6.
- Unnecessary arithmetic expressions
- 3.22.10.
- Custom SQL transformation with VisitListener
- 3.22.10.1.
- Example: Logging abbreviated bind values
previous : next |
References to this page
Feedback
Do you have any feedback about this page? We'd love to hear it!