Uses of Interface
org.jooq.QueryPart
Package
Description
This package contains jOOQ's public API.
This package contains jOOQ's implementation classes.
-
Uses of QueryPart in org.jooq
Modifier and TypeInterfaceDescriptioninterface
The step in the specification of aggregate functions where the SQL:2003 standardFILTER clause
can be added.interface
An aggregate function.interface
Deprecated, for removal: This API element is subject to removal in a future version.- [#11329] - 3.15.0 - This type will be removed in the future.interface
A step in the construction of theALTER DOMAIN
statement.interface
Deprecated, for removal: This API element is subject to removal in a future version.- [#11329] - 3.15.0 - This type will be removed in the future.interface
Deprecated, for removal: This API element is subject to removal in a future version.- [#11329] - 3.15.0 - This type will be removed in the future.interface
Deprecated, for removal: This API element is subject to removal in a future version.- [#11329] - 3.15.0 - This type will be removed in the future.interface
Deprecated, for removal: This API element is subject to removal in a future version.- [#11329] - 3.15.0 - This type will be removed in the future.interface
AlterSequenceFlagsStep<T extends Number>
A step in the construction of theALTER SEQUENCE
statement.interface
AlterSequenceStep<T extends Number>
A step in the construction of theALTER SEQUENCE
statement.interface
The step in theALTER TABLE
DSL used toADD
columns.interface
The step in theALTER TABLE
DSL used toDROP
columns or constraints.interface
Deprecated, for removal: This API element is subject to removal in a future version.- [#11329] - 3.15.0 - This type will be removed in the future.interface
The step in theALTER TABLE … ADD CONSTRAINT
statement where an optional index can be specified to enforce the constraint.interface
Deprecated, for removal: This API element is subject to removal in a future version.- [#11329] - 3.15.0 - This type will be removed in the future.interface
Deprecated, for removal: This API element is subject to removal in a future version.- [#11329] - 3.15.0 - This type will be removed in the future.interface
The SQL standardARRAY_AGG()
function.interface
An unqualified asterisk.interface
A type that is bothAttachable
and aQueryPart
.interface
A procedural block.interface
A step in the construction of theCALL
statement.interface
The final step in creating a case statement of the typeinterface
CaseWhenStep<V,
T> The final step in creating a case statement of the typeinterface
A catalog.interface
A character set.interface
A check constraint.interface
AQuery
that holds a reference to the underlyingPreparedStatement
without closing it, for reuse.interface
CloseableResultQuery<R extends Record>
AResultQuery
that holds a reference to the underlyingPreparedStatement
without closing it, for reuse.interface
A collation.interface
A common base type forComment
and other, potential future types where DSL API accepts all types alike.interface
A comment.interface
Deprecated, for removal: This API element is subject to removal in a future version.- [#11329] - 3.15.0 - This type will be removed in the future.interface
CommonTableExpression<R extends Record>
A common table expression.interface
A condition or predicate.interface
A DDL constraint.interface
The step in theConstraint
construction DSL API that allows for addingENFORCED
andNOT ENFORCED
clauses.interface
Deprecated, for removal: This API element is subject to removal in a future version.- [#11329] - 3.15.0 - This type will be removed in the future.interface
The step in theConstraint
construction DSL API that allows for addingON DELETE
andON UPDATE
clauses.interface
The step in theConstraint
construction DSL API that allows for specifying the constraint type.interface
A step in the construction of anCONTINUE
statement where aWHEN
clause can be added.interface
Deprecated, for removal: This API element is subject to removal in a future version.- [#11329] - 3.15.0 - This type will be removed in the future.interface
A step in the construction of theCREATE DOMAIN
statement.interface
A step in the construction of theCREATE DOMAIN
statement.interface
Deprecated, for removal: This API element is subject to removal in a future version.- [#11329] - 3.15.0 - This type will be removed in the future.interface
Deprecated, for removal: This API element is subject to removal in a future version.- [#11329] - 3.15.0 - This type will be removed in the future.interface
A step in the construction of theCREATE INDEX
statement.interface
A step in the construction of theCREATE INDEX
statement.interface
Deprecated, for removal: This API element is subject to removal in a future version.- [#11329] - 3.15.0 - This type will be removed in the future.interface
Deprecated, for removal: This API element is subject to removal in a future version.- [#11329] - 3.15.0 - This type will be removed in the future.interface
A step in the construction of theCREATE SEQUENCE
statement.interface
A step in the construction of theCREATE TABLE
statement.interface
A step in the construction of theCREATE TABLE
statement.interface
A step in the construction of theCREATE TABLE
statement.interface
Deprecated, for removal: This API element is subject to removal in a future version.- [#11329] - 3.15.0 - This type will be removed in the future.interface
A step in the construction of theCREATE TABLE
statement.interface
A step in the construction of theCREATE TABLE
statement.interface
A step in the construction of theCREATE TABLE
statement.interface
Deprecated, for removal: This API element is subject to removal in a future version.- [#11329] - 3.15.0 - This type will be removed in the future.interface
Deprecated, for removal: This API element is subject to removal in a future version.- [#11329] - 3.15.0 - This type will be removed in the future.interface
DataType<T>
A common interface to all dialect-specific data types.interface
A marker interface for all DDL queries.interface
Declaration<T>
A local variable declaration.interface
ADELETE
statement.interface
DeleteConditionStep<R extends Record>
This type is used for theDelete
's DSL API.interface
DeleteFinalStep<R extends Record>
Deprecated, for removal: This API element is subject to removal in a future version.- [#11329] - 3.15.0 - This type will be removed in the future.interface
DeleteLimitStep<R extends Record>
This type is used for theDelete
's DSL API.interface
DeleteOrderByStep<R extends Record>
This type is used for theDelete
's DSL API.interface
DeleteQuery<R extends Record>
ADELETE
statement (model API).interface
DeleteResultStep<R extends Record>
This type is used for theDelete
's DSL API.interface
DeleteReturningStep<R extends Record>
This type is used for theDelete
's DSL API.interface
DeleteUsingStep<R extends Record>
This type is used for theDelete
's DSL API.interface
DeleteWhereStep<R extends Record>
This type is used for theDelete
's DSL API.interface
A derived column list.interface
A derived column list.interface
A derived column list.interface
A derived column list.interface
A derived column list.interface
A derived column list.interface
A derived column list.interface
A derived column list.interface
A derived column list.interface
A derived column list.interface
A derived column list.interface
A derived column list.interface
A derived column list.interface
A derived column list.interface
A derived column list.interface
A derived column list.interface
A derived column list.interface
A derived column list.interface
A derived column list.interface
A derived column list.interface
A derived column list.interface
A derived column list.interface
A derived column list.interface
interface
Domain<T>
The meta model of a SQLDOMAIN
interface
Deprecated, for removal: This API element is subject to removal in a future version.- [#11329] - 3.15.0 - This type will be removed in the future.interface
A step in the construction of theDROP DOMAIN
statement.interface
Deprecated, for removal: This API element is subject to removal in a future version.- [#11329] - 3.15.0 - This type will be removed in the future.interface
A step in the construction of theDROP INDEX
statement.interface
Deprecated, for removal: This API element is subject to removal in a future version.- [#11329] - 3.15.0 - This type will be removed in the future.interface
A step in the construction of theDROP INDEX
statement.interface
Deprecated, for removal: This API element is subject to removal in a future version.- [#11329] - 3.15.0 - This type will be removed in the future.interface
A step in the construction of theDROP SCHEMA
statement.interface
Deprecated, for removal: This API element is subject to removal in a future version.- [#11329] - 3.15.0 - This type will be removed in the future.interface
Deprecated, for removal: This API element is subject to removal in a future version.- [#11329] - 3.15.0 - This type will be removed in the future.interface
A step in the construction of theDROP TABLE
statement.interface
A step in the construction of theDROP TRIGGER
statement.interface
Deprecated, for removal: This API element is subject to removal in a future version.- [#11329] - 3.15.0 - This type will be removed in the future.interface
A step in the construction of theDROP TYPE
statement.interface
Deprecated, for removal: This API element is subject to removal in a future version.- [#11329] - 3.15.0 - This type will be removed in the future.interface
A step in the construction of anEXIT
statement where aWHEN
clause can be added.interface
ACondition
that always yieldsfalse
.interface
Field<T>
A column expression.interface
Deprecated.- 3.17.0 - [#13005] - UseTableElement
instead.interface
interface
interface
ForeignKey<CHILD extends Record,
PARENT extends Record> AForeignKey
is an object referencing aUniqueKey
.interface
Deprecated, for removal: This API element is subject to removal in a future version.- [#11329] - 3.15.0 - This type will be removed in the future.interface
A step in the construction of theGRANT
statement.interface
MySQL'sGROUP_CONCAT
function.interface
MySQL'sGROUP_CONCAT
function.interface
An expression to be used exclusively inGROUP BY
clauses.interface
An intermediate step in building a proceduralIF
statement.interface
A DDL index definition.interface
AnINSERT
statement.interface
InsertFinalStep<R extends Record>
Deprecated, for removal: This API element is subject to removal in a future version.- [#11329] - 3.15.0 - This type will be removed in the future.interface
InsertOnConflictConditionStep<R extends Record>
This type is used for theInsert
's DSL API.interface
InsertOnConflictWhereStep<R extends Record>
This type is used for theInsert
's DSL API.interface
InsertOnDuplicateSetMoreStep<R extends Record>
This type is used for theInsert
's DSL API.interface
InsertOnDuplicateStep<R extends Record>
This type is used for theInsert
's DSL API.interface
InsertQuery<R extends Record>
AnINSERT
statement (model API).interface
InsertResultStep<R extends Record>
This type is used for theInsert
's DSL API.interface
InsertReturningStep<R extends Record>
This type is used for theInsert
's DSL API.interface
InsertSetMoreStep<R extends Record>
This type is used for theInsert
's alternative DSL API.interface
InsertValuesStep1<R extends Record,
T1> This type is used for theInsert
's DSL API.interface
InsertValuesStep10<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10> This type is used for theInsert
's DSL API.interface
InsertValuesStep11<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11> This type is used for theInsert
's DSL API.interface
InsertValuesStep12<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12> This type is used for theInsert
's DSL API.interface
InsertValuesStep13<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13> This type is used for theInsert
's DSL API.interface
InsertValuesStep14<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14> This type is used for theInsert
's DSL API.interface
InsertValuesStep15<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15> This type is used for theInsert
's DSL API.interface
InsertValuesStep16<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16> This type is used for theInsert
's DSL API.interface
InsertValuesStep17<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17> This type is used for theInsert
's DSL API.interface
InsertValuesStep18<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18> This type is used for theInsert
's DSL API.interface
InsertValuesStep19<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19> This type is used for theInsert
's DSL API.interface
InsertValuesStep2<R extends Record,
T1, T2> This type is used for theInsert
's DSL API.interface
InsertValuesStep20<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20> This type is used for theInsert
's DSL API.interface
InsertValuesStep21<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21> This type is used for theInsert
's DSL API.interface
InsertValuesStep22<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21, T22> This type is used for theInsert
's DSL API.interface
InsertValuesStep3<R extends Record,
T1, T2, T3> This type is used for theInsert
's DSL API.interface
InsertValuesStep4<R extends Record,
T1, T2, T3, T4> This type is used for theInsert
's DSL API.interface
InsertValuesStep5<R extends Record,
T1, T2, T3, T4, T5> This type is used for theInsert
's DSL API.interface
InsertValuesStep6<R extends Record,
T1, T2, T3, T4, T5, T6> This type is used for theInsert
's DSL API.interface
InsertValuesStep7<R extends Record,
T1, T2, T3, T4, T5, T6, T7> This type is used for theInsert
's DSL API.interface
InsertValuesStep8<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8> This type is used for theInsert
's DSL API.interface
InsertValuesStep9<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9> This type is used for theInsert
's DSL API.interface
InsertValuesStepN<R extends Record>
This type is used for theInsert
's DSL API.interface
InverseForeignKey<PARENT extends Record,
CHILD extends Record> AnInverseForeignKey
is an inverseForeignKey
.interface
A step in the construction ofDSL.jsonArrayAgg(Field)
orDSL.jsonbArrayAgg(Field)
functions where theNULL
clause can be defined.interface
A step in the construction ofDSL.jsonArrayAgg(Field)
orDSL.jsonbArrayAgg(Field)
functions where theORDER BY
clause can be defined.interface
A step in the construction ofDSL.jsonArrayAgg(Field)
orDSL.jsonbArrayAgg(Field)
functions where theRETURNING
clause can be defined.interface
A step in the construction of theJSON ARRAY
function.interface
A step in the construction of theJSON ARRAY
function.interface
JSONEntry<T>
A JSON entry for JSON objects.interface
A step in the construction ofDSL.jsonExists(Field, Field)
orDSL.jsonbExists(Field, Field)
functions where theON ERROR
clause can be defined.interface
A step in the construction ofDSL.jsonObjectAgg(JSONEntry)
orDSL.jsonbObjectAgg(JSONEntry)
functions where theNULL
clause can be defined.interface
A step in the construction ofDSL.jsonObjectAgg(JSONEntry)
orDSL.jsonbObjectAgg(JSONEntry)
functions where theRETURNING
clause can be defined.interface
A step in the construction of theJSON OBJECT
function.interface
A step in the construction of theJSON OBJECT
function.interface
A step in the construction of anJSON_TABLE
expression.interface
A step in the construction of anJSON_TABLE
expression.interface
A step in the construction ofDSL.jsonValue(Field, Field)
orDSL.jsonbValue(Field, Field)
functions where theON EMPTY
andON ERROR
clauses can be defined.interface
A step in the construction of theJSON VALUE
function.interface
AKey
is an object representing aUNIQUE KEY
, aPRIMARY KEY
, or aFOREIGN KEY
.interface
A SQL keyword.interface
A label for use in procedural code.interface
A step in the construction of theLIKE
function.interface
A database link reference.interface
AMERGE
statement.interface
MergeFinalStep<R extends Record>
Deprecated, for removal: This API element is subject to removal in a future version.- [#11329] - 3.15.0 - This type will be removed in the future.interface
MergeMatchedDeleteStep<R extends Record>
This type is used for theMerge
's DSL API.interface
MergeMatchedSetMoreStep<R extends Record>
This type is used for theMerge
's DSL API.interface
MergeMatchedStep<R extends Record>
This type is used for theMerge
's DSL API.interface
MergeMatchedWhereStep<R extends Record>
This type is used for theMerge
's DSL API.interface
MergeNotMatchedSetMoreStep<R extends Record>
This type is used for theMerge
's DSL API.interface
MergeNotMatchedStep<R extends Record>
This type is used for theMerge
's DSL API.interface
MergeNotMatchedWhereStep<R extends Record>
This type is used for theMerge
's DSL API.interface
MergeOnConditionStep<R extends Record>
This type is used for theMerge
's DSL API.interface
An identifier.interface
A common base type for all qualifiable, named objects.interface
ACondition
that always yieldsnull
.interface
OrderField<T>
AQueryPart
to be used exclusively inORDER BY
clauses.interface
A container for stored procedures and functionsinterface
Param<T>
A named parameter and/or bind value.interface
Parameter<T>
A parameter to a stored procedure or function.interface
interface
A relationship path.interface
Period<T>
A period specification for usage in temporal tables.interface
interface
A privilege for use inGRANT
andREVOKE
statements.interface
interface
A qualified asterisk.interface
QuantifiedSelect<R extends Record>
A quantified select for use in quantified comparison predicates.interface
A wrapper for a collection of queries.interface
Any query.interface
Base functionality declaration for all query objectsinterface
RecordQualifier<R extends Record>
interface
ResultQuery<R extends Record>
A query that can return results.interface
Deprecated, for removal: This API element is subject to removal in a future version.- [#11329] - 3.15.0 - This type will be removed in the future.interface
A privilege for use inGRANT
andREVOKE
statements.interface
A step in the construction of theROLLBACK
statement.interface
Routine<T>
A routine is a callable object in your RDBMS.interface
A row value expression.interface
Row1<T1>
A row value expression.interface
Row10<T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10> A row value expression.interface
Row11<T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11> A row value expression.interface
Row12<T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12> A row value expression.interface
Row13<T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13> A row value expression.interface
Row14<T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14> A row value expression.interface
Row15<T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15> A row value expression.interface
Row16<T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16> A row value expression.interface
Row17<T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17> A row value expression.interface
Row18<T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18> A row value expression.interface
Row19<T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19> A row value expression.interface
Row2<T1,
T2> A row value expression.interface
Row20<T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20> A row value expression.interface
Row21<T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21> A row value expression.interface
Row22<T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21, T22> A row value expression.interface
Row3<T1,
T2, T3> A row value expression.interface
Row4<T1,
T2, T3, T4> A row value expression.interface
Row5<T1,
T2, T3, T4, T5> A row value expression.interface
Row6<T1,
T2, T3, T4, T5, T6> A row value expression.interface
Row7<T1,
T2, T3, T4, T5, T6, T7> A row value expression.interface
Row8<T1,
T2, T3, T4, T5, T6, T7, T8> A row value expression.interface
Row9<T1,
T2, T3, T4, T5, T6, T7, T8, T9> A row value expression.interface
Any query that is not aResultQuery
, and thus possibly produces a row count as a result, instead of aResult
.interface
A row value expression.interface
A schema.interface
ASELECT
statement.interface
SelectConditionStep<R extends Record>
interface
SelectConnectByAfterStartWithConditionStep<R extends Record>
interface
SelectConnectByConditionStep<R extends Record>
interface
SelectConnectByStep<R extends Record>
interface
SelectCorrelatedSubqueryStep<R extends Record>
interface
SelectDistinctOnStep<R extends Record>
interface
SelectField<T>
AQueryPart
to be used exclusively inSELECT
clauses.interface
AQueryPart
to be used exclusively inSELECT
clauses.interface
SelectFinalStep<R extends Record>
interface
SelectForJSONCommonDirectivesStep<R extends Record>
interface
SelectForStep<R extends Record>
interface
SelectForUpdateOfStep<R extends Record>
interface
SelectForUpdateStep<R extends Record>
interface
SelectForUpdateWaitStep<R extends Record>
interface
SelectForXMLCommonDirectivesStep<R extends Record>
interface
SelectForXMLPathDirectivesStep<R extends Record>
interface
SelectForXMLRawDirectivesStep<R extends Record>
interface
SelectFromStep<R extends Record>
interface
SelectGroupByStep<R extends Record>
interface
SelectHavingConditionStep<R extends Record>
interface
SelectHavingStep<R extends Record>
interface
SelectIntoStep<R extends Record>
interface
SelectJoinStep<R extends Record>
interface
SelectLimitAfterOffsetStep<R extends Record>
interface
SelectLimitPercentAfterOffsetStep<R extends Record>
interface
SelectLimitPercentStep<R extends Record>
interface
SelectLimitStep<R extends Record>
interface
SelectOffsetStep<R extends Record>
interface
SelectOnConditionStep<R extends Record>
interface
SelectOptionalOnStep<R extends Record>
interface
SelectOptionStep<R extends Record>
interface
SelectOrderByStep<R extends Record>
interface
SelectQualifyConditionStep<R extends Record>
interface
SelectQualifyStep<R extends Record>
interface
SelectQuery<R extends Record>
ASELECT
statement (model API).interface
SelectSeekLimitStep<R extends Record>
interface
SelectSeekStep1<R extends Record,
T1> interface
SelectSeekStep10<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10> interface
SelectSeekStep11<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11> interface
SelectSeekStep12<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12> interface
SelectSeekStep13<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13> interface
SelectSeekStep14<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14> interface
SelectSeekStep15<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15> interface
SelectSeekStep16<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16> interface
SelectSeekStep17<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17> interface
SelectSeekStep18<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18> interface
SelectSeekStep19<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19> interface
SelectSeekStep2<R extends Record,
T1, T2> interface
SelectSeekStep20<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20> interface
SelectSeekStep21<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21> interface
SelectSeekStep22<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21, T22> interface
SelectSeekStep3<R extends Record,
T1, T2, T3> interface
SelectSeekStep4<R extends Record,
T1, T2, T3, T4> interface
SelectSeekStep5<R extends Record,
T1, T2, T3, T4, T5> interface
SelectSeekStep6<R extends Record,
T1, T2, T3, T4, T5, T6> interface
SelectSeekStep7<R extends Record,
T1, T2, T3, T4, T5, T6, T7> interface
SelectSeekStep8<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8> interface
SelectSeekStep9<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9> interface
SelectSeekStepN<R extends Record>
interface
SelectSelectStep<R extends Record>
interface
SelectStartWithStep<R extends Record>
interface
SelectUnionStep<R extends Record>
interface
SelectWhereStep<R extends Record>
interface
SelectWindowStep<R extends Record>
interface
SelectWithTiesAfterOffsetStep<R extends Record>
interface
SelectWithTiesStep<R extends Record>
interface
A sequence.interface
A step in the construction of theSIGNAL SQL STATE
function.interface
SortField<T>
A sort specification.interface
A plain SQLQueryPart
.interface
A statement that can be placed inside of aBlock
, but not executed on its own.interface
StoreQuery<R extends Record>
A query storing objects to the database.interface
A table.interface
interface
TableField<R extends Record,
T> A field contained in a table.interface
An object that can behave like a table (a table-like object).interface
TableOnConditionStep<R extends Record>
An intermediate (optional) type for the construction of aJOIN
clause, where the join criteria is added using anON
clause (with aCondition
.interface
TableOptionalOnStep<R extends Record>
interface
A meta model of SQLTRIGGER
objects.interface
ACondition
that always yieldstrue
.interface
A step in the construction of theTRUNCATE
statement.interface
TruncateCascadeStep<R extends Record>
A step in the construction of theTRUNCATE
statement.interface
TruncateFinalStep<R extends Record>
Deprecated, for removal: This API element is subject to removal in a future version.- [#11329] - 3.15.0 - This type will be removed in the future.interface
TruncateIdentityStep<R extends Record>
A step in the construction of theTRUNCATE
statement.interface
Type<T>
An object representing a user defined type.interface
Typed<T>
A marker interface for all query parts that have aDataType
.interface
UDT definition.interface
A field contained in a UDT.interface
UDTPathField<R extends Record,
U extends UDTRecord<U>, T> A field dereferenced from a UDT path.interface
UDTPathTableField<R extends Record,
U extends UDTRecord<U>, T> A field dereferenced from a UDT path.interface
AUniqueKey
is an object representing aUNIQUE KEY
or aPRIMARY KEY
.interface
AnUPDATE
statement.interface
UpdateConditionStep<R extends Record>
This type is used for theUpdate
's DSL API.interface
UpdateFinalStep<R extends Record>
Deprecated, for removal: This API element is subject to removal in a future version.- [#11329] - 3.15.0 - This type will be removed in the future.interface
UpdateFromStep<R extends Record>
This type is used for theUpdate
's DSL API.interface
UpdateLimitStep<R extends Record>
This type is used for theUpdate
's DSL API.interface
UpdateOrderByStep<R extends Record>
This type is used for theUpdate
's DSL API.interface
UpdateQuery<R extends Record>
AnUPDATE
statement (model API).interface
UpdateResultStep<R extends Record>
This type is used for theUpdate
's DSL API.interface
UpdateReturningStep<R extends Record>
This type is used for theUpdate
's DSL API.interface
UpdateSetMoreStep<R extends Record>
This type is used for theUpdate
's DSL API.interface
UpdateWhereStep<R extends Record>
This type is used for theUpdate
's DSL API.interface
A privilege for use inGRANT
andREVOKE
statements.interface
Variable<T>
A local variable reference.interface
This type is used for the window function DSL API.interface
A window definition.interface
This type is used for the window function DSL API.interface
Deprecated, for removal: This API element is subject to removal in a future version.- [#11329] - 3.15.0 - This type will be removed in the future.interface
This type is used for the window function DSL API.interface
This type is used for the window function DSL API.interface
This type is used for the window function DSL API.interface
A window specification.interface
An intermediate step in the construction of aWindowSpecification
.interface
Deprecated, for removal: This API element is subject to removal in a future version.- [#11329] - 3.15.0 - This type will be removed in the future.interface
An intermediate step in the construction of aWindowSpecification
.interface
An intermediate step in the construction of aWindowSpecification
.interface
An intermediate step in the construction of aWindowSpecification
.interface
interface
The SQL standardARRAY_AGG()
function.interface
A type modelling XML attributes for use inDSL.xmlelement(Name, XMLAttributes, Field...)
.interface
A step in the construction of anXMLTABLE
expression.interface
A step in the construction of anXMLTABLE
expression.Modifier and TypeMethodDescriptionContext.scopeParts
(Class<? extends Q> type) Get all values of a type that are in the current scope or higher.Modifier and TypeMethodDescriptiondefault @NotNull QueryPart
Traverse aQueryPart
hierarchy and recursively replace its elements by alternatives.@NotNull QueryPart
Traverse aQueryPart
hierarchy and recursively replace its elements by alternatives.@Nullable QueryPart
DiagnosticsContext.part()
The object that was diagnosed if available, ornull
, if there was no specificQueryPart
to attach the diagnostic to.@NotNull QueryPart
VisitContext.queryPart()
The most recentQueryPart
that was encountered throughContext.visit(QueryPart)
.@NotNull QueryPart @NotNull []
VisitContext.queryParts()
A path ofQueryPart
s going through the visiting tree.@NotNull QueryPart
Context.scopeMapping
(QueryPart part) Retrieve the registered mapping for a query part in the current scope.@Nullable QueryPart
Context.scopePart()
Return theQueryPart
that defines the currentContext.scopeStart(QueryPart)
, if any, ornull
if there is no suchQueryPart
.@Nullable QueryPart
Context.topLevel()
The top levelQueryPart
that is being rendered.@Nullable QueryPart
Context.topLevelForLanguageContext()
The top levelQueryPart
that is being rendered in the currentContext.languageContext()
.@Nullable QueryPart
DiagnosticsContext.transformedPart()
The transformed object fromDiagnosticsContext.part()
if available, ornull
, if there was no specific transformation to attach the diagnostic to.Modifier and TypeMethodDescriptionTraverser.after()
A callback that is invoked after recursing into a subtree.Traverser.before()
A callback that is invoked before recursing into a subtree.Traversers.findingAll
(Predicate<? super QueryPart> predicate) Traversers.findingAny
(Predicate<? super QueryPart> predicate) Replacer.recurse()
An optional recursion condition to prevent entering a specific subtree, e.g.Traverser.recurse()
An optional recursion condition to prevent entering a specificQueryPart
, e.g.Traverser.recurseChildren()
An optional recursion condition to prevent entering a specificQueryPart
's children, e.g.Replacer.replacer()
A callback that is invoked on all elements of theQueryPart
expression tree.Replacer.replacer()
A callback that is invoked on all elements of theQueryPart
expression tree.Modifier and TypeMethodDescription@NotNull Condition
Combine this condition with another one using theOperator.AND
operator.@NotNull DeleteConditionStep
<R> Combine the currently assembled conditions with another one using theOperator.AND
operator@NotNull DivideByOnConditionStep
Combine the currently assembled conditions with another one using theOperator.AND
operator.@NotNull InsertOnConflictConditionStep
<R> Combine the currently assembled conditions with another one using theOperator.AND
operator and proceed to the next step.@NotNull MergeOnConditionStep
<R> Combine the currently assembled conditions with another one using theOperator.AND
operator and proceed to the next step.@NotNull SelectConditionStep
<R> Combine the currently assembled conditions with another one using theOperator.AND
operator and proceed to the next step.@NotNull SelectConnectByAfterStartWithConditionStep
<R> Combine the currently assembled conditions with another one using theOperator.AND
operator and proceed to the next step.@NotNull SelectConnectByConditionStep
<R> Combine the currently assembled conditions with another one using theOperator.AND
operator and proceed to the next step.@NotNull SelectHavingConditionStep
<R> Combine the currently assembled conditions with another one using theOperator.AND
operator and proceed to the next step.@NotNull SelectOnConditionStep
<R> Combine the currently assembled conditions with another one using theOperator.AND
operator and proceed to the next step.@NotNull SelectQualifyConditionStep
<R> Combine the currently assembled conditions with another one using theOperator.AND
operator and proceed to the next step.@NotNull TableOnConditionStep
<R> Combine the currently assembled conditions with another one using theOperator.AND
operator.@NotNull UpdateConditionStep
<R> Combine the currently assembled conditions with another one using theOperator.AND
operator@NotNull CreateViewFinalStep
Add theAS
clause to theCREATE VIEW
statement.@NotNull SelectConnectByAfterStartWithConditionStep
<R> Add an Oracle-specificCONNECT BY
clause to the query@NotNull SelectConnectByConditionStep
<R> Add an Oracle-specificCONNECT BY
clause to the query.@NotNull SelectConnectByAfterStartWithConditionStep
<R> SelectConnectByAfterStartWithStep.connectByNoCycle
(String sql, QueryPart... parts) Add an Oracle-specificCONNECT BY NOCYCLE
clause to the query@NotNull SelectConnectByConditionStep
<R> SelectConnectByStep.connectByNoCycle
(String sql, QueryPart... parts) Add an Oracle-specificCONNECT BY NOCYCLE
clause to the queryTraversers.containing
(QueryPart part) @NotNull SelectJoinStep
<R> SelectJoinStep.crossApply
(String sql, QueryPart... parts) CROSS APPLY
a table to this table.Table.crossApply
(String sql, QueryPart... parts) CROSS APPLY
a table to this table.@NotNull SelectJoinStep
<R> Convenience method toCROSS JOIN
a table to the last table added to theFROM
clause usingTable.crossJoin(String, QueryPart...)
CROSS JOIN
a table to this table.int
Execute a new query holding plain SQL.DSLContext.extractBindValues
(QueryPart part) Retrieve the bind values that will be bound by a givenQueryPart
.@Nullable Param
<?> DSLContext.extractParam
(QueryPart part, String name) Get a named parameter from aQueryPart
, provided its name.DSLContext.extractParams
(QueryPart part) Get aMap
of named parameters.Execute a new query holding plain SQL.@NotNull CompletionStage
<Result<Record>> DSLContext.fetchAsync
(String sql, QueryPart... parts) Fetch results in a newCompletionStage
.@NotNull CompletionStage
<Result<Record>> DSLContext.fetchAsync
(Executor executor, String sql, QueryPart... parts) Fetch results in a newCompletionStage
that is asynchronously completed by a task running in the given executor.Execute a new query holding plain SQL and "lazily" return the generated result.@NotNull Results
Execute a new query holding plain SQL, possibly returning several result sets.@Nullable Record
Execute a new query holding plain SQL.DSLContext.fetchOptional
(String sql, QueryPart... parts) Execute a new query holding plain SQL.@NotNull Optional
<?> DSLContext.fetchOptionalValue
(String sql, QueryPart... parts) Execute a new query holding plain SQL.@NotNull Record
DSLContext.fetchSingle
(String sql, QueryPart... parts) Execute a new query holding plain SQL.DSLContext.fetchStream
(String sql, QueryPart... parts) Execute a new query holding plain SQL and "lazily" return the generated result.@Nullable Object
DSLContext.fetchValue
(String sql, QueryPart... parts) Execute a new query holding plain SQL.@NotNull List
<?> DSLContext.fetchValues
(String sql, QueryPart... parts) Execute a new query holding plain SQL.@NotNull WindowBeforeOverStep
<T> AggregateFilterStep.filterWhere
(String sql, QueryPart... parts) Add aFILTER clause
to the aggregate function.@NotNull SelectJoinStep
<R> Add aFROM
clause to the query.@NotNull UpdateWhereStep
<R> Add aFROM
clause to the query.@NotNull SelectOnStep
<R> Convenience method toFULL OUTER JOIN
a tableto the last table added to theFROM
clause usingTable.fullOuterJoin(String, QueryPart...)
.@NotNull TablePartitionByStep
<Record> FULL OUTER JOIN
a table to this table.@NotNull TablePartitionByStep
<Record> FULL OUTER JOIN
a table to this table.@NotNull SelectOnStep
<R> SelectJoinStep.fullOuterJoin
(String sql, QueryPart... parts) Convenience method toFULL OUTER JOIN
a tableto the last table added to theFROM
clause usingTable.fullOuterJoin(String, QueryPart...)
@NotNull TablePartitionByStep
<Record> Table.fullOuterJoin
(String sql, QueryPart... parts) FULL OUTER JOIN
a table to this table.@NotNull TablePartitionByStep
<Record> TableOuterJoinStep.fullOuterJoin
(String sql, QueryPart... parts) FULL OUTER JOIN
a table to this table.@NotNull SelectHavingConditionStep
<R> Add aHAVING
clause to the query.boolean
Context.inCurrentScope
(QueryPart part) Check whether a query part is registered in the current scope.@NotNull SelectOnStep
<R> Convenience method toINNER JOIN
a table to the last table added to theFROM
clause usingTable.join(String, QueryPart...)
.@NotNull TableOnStep
<Record> INNER JOIN
a table to this table.boolean
Check whether a query part is registered in the current scope or higher.@NotNull SelectOnStep
<R> Convenience method toINNER JOIN
a table to the last table added to theFROM
clause usingTable.join(String, QueryPart...)
.@NotNull TableOnStep
<Record> INNER JOIN
a table to this table.Context.languageContext
(LanguageContext languageContext, QueryPart topLevelForLanguageContext, Consumer<? super C> consumer) Set the new language context forContext.languageContext()
for the scope of aConsumer
.@NotNull SelectJoinPartitionByStep
<R> Convenience method toLEFT OUTER JOIN
a table to the last table added to theFROM
clause usingTable.leftOuterJoin(String, QueryPart...)
.@NotNull TablePartitionByStep
<Record> LEFT OUTER JOIN
a table to this table.@NotNull TablePartitionByStep
<Record> LEFT OUTER JOIN
a table to this table.@NotNull SelectJoinPartitionByStep
<R> SelectJoinStep.leftOuterJoin
(String sql, QueryPart... parts) Convenience method toLEFT OUTER JOIN
a table to the last table added to theFROM
clause usingTable.leftOuterJoin(String, QueryPart...)
@NotNull TablePartitionByStep
<Record> Table.leftOuterJoin
(String sql, QueryPart... parts) LEFT OUTER JOIN
a table to this table.@NotNull TablePartitionByStep
<Record> TableOuterJoinStep.leftOuterJoin
(String sql, QueryPart... parts) LEFT OUTER JOIN
a table to this table.@NotNull SelectJoinStep
<R> SelectJoinStep.naturalFullOuterJoin
(String sql, QueryPart... parts) Convenience method toNATURAL FULL OUTER JOIN
a table to the last table added to theFROM
clause usingTable.naturalFullOuterJoin(String, QueryPart...)
Table.naturalFullOuterJoin
(String sql, QueryPart... parts) NATURAL FULL OUTER JOIN
a table to this table.@NotNull SelectJoinStep
<R> SelectJoinStep.naturalJoin
(String sql, QueryPart... parts) Convenience method toNATURAL JOIN
a table to the last table added to theFROM
clause usingTable.naturalJoin(String, QueryPart...)
Table.naturalJoin
(String sql, QueryPart... parts) NATURAL JOIN
a table to this table.@NotNull SelectJoinStep
<R> SelectJoinStep.naturalLeftOuterJoin
(String sql, QueryPart... parts) Convenience method toNATURAL LEFT OUTER JOIN
a table to the last table added to theFROM
clause usingTable.naturalLeftOuterJoin(String, QueryPart...)
Table.naturalLeftOuterJoin
(String sql, QueryPart... parts) NATURAL LEFT OUTER JOIN
a table to this table.@NotNull SelectJoinStep
<R> SelectJoinStep.naturalRightOuterJoin
(String sql, QueryPart... parts) Convenience method toNATURAL RIGHT OUTER JOIN
a table to the last table added to theFROM
clause usingTable.naturalRightOuterJoin(String, QueryPart...)
Table.naturalRightOuterJoin
(String sql, QueryPart... parts) NATURAL RIGHT OUTER JOIN
a table to this table.@NotNull DivideByOnConditionStep
Add a division condition to theDIVIDE BY
clause@NotNull MergeOnConditionStep
<R> Provide join conditions and proceed to the next step@NotNull SelectOnConditionStep
<R> Add anON
clause to the previousJOIN
.@NotNull TableOnConditionStep
<R> Add anON
clause to theJOIN
.@NotNull Condition
Combine this condition with another one using theOperator.OR
operator.@NotNull DeleteConditionStep
<R> Combine the currently assembled conditions with another one using theOperator.OR
operator@NotNull DivideByOnConditionStep
Combine the currently assembled conditions with another one using theOperator.OR
operator.@NotNull InsertOnConflictConditionStep
<R> Combine the currently assembled conditions with another one using theOperator.OR
operator and proceed to the next step.@NotNull MergeOnConditionStep
<R> Combine the currently assembled conditions with another one using theOperator.OR
operator and proceed to the next step.@NotNull SelectConditionStep
<R> Combine the currently assembled conditions with another one using theOperator.OR
operator and proceed to the next step.@NotNull SelectHavingConditionStep
<R> Combine the currently assembled conditions with another one using theOperator.OR
operator and proceed to the next step.@NotNull SelectOnConditionStep
<R> Combine the currently assembled conditions with another one using theOperator.OR
operator and proceed to the next step.@NotNull SelectQualifyConditionStep
<R> Combine the currently assembled conditions with another one using theOperator.OR
operator and proceed to the next step.@NotNull TableOnConditionStep
<R> Combine the currently assembled conditions with another one using theOperator.OR
operator.@NotNull UpdateConditionStep
<R> Combine the currently assembled conditions with another one using theOperator.OR
operator@NotNull SelectJoinStep
<R> SelectJoinStep.outerApply
(String sql, QueryPart... parts) OUTER APPLY
a table to this table.Table.outerApply
(String sql, QueryPart... parts) OUTER APPLY
a table to this table.@NotNull SelectQualifyConditionStep
<R> Add aQUALIFY
clause to the query.@NotNull RowCountQuery
Create a new query holding plain SQL.void
Replace the most recentQueryPart
that was encountered throughContext.visit(QueryPart)
.@NotNull String
Render a query part in a new context derived from this one.@NotNull String
Render a QueryPart in the context of thisDSLContext
.@NotNull String
DSLContext.renderInlined
(QueryPart part) Render a QueryPart in the context of thisDSLContext
, inlining all bind variables.@NotNull String
DSLContext.renderNamedOrInlinedParams
(QueryPart part) Render a QueryPart in the context of thisDSLContext
, rendering bind variables as named parameters, or inlined parameters if they have no name.@NotNull String
DSLContext.renderNamedParams
(QueryPart part) Render a QueryPart in the context of thisDSLContext
, rendering bind variables as named parameters.@NotNull ResultQuery
<Record> DSLContext.resultQuery
(String sql, QueryPart... parts) Create a new query holding plain SQL.@NotNull SelectJoinPartitionByStep
<R> Convenience method toRIGHT OUTER JOIN
a table to the last table added to theFROM
clause usingTable.rightOuterJoin(String, QueryPart...)
.@NotNull TablePartitionByStep
<Record> RIGHT OUTER JOIN
a table to this table.@NotNull TablePartitionByStep
<Record> RIGHT OUTER JOIN
a table to this table.@NotNull SelectJoinPartitionByStep
<R> SelectJoinStep.rightOuterJoin
(String sql, QueryPart... parts) Convenience method toRIGHT OUTER JOIN
a table to the last table added to theFROM
clause usingTable.rightOuterJoin(String, QueryPart...)
@NotNull TablePartitionByStep
<Record> Table.rightOuterJoin
(String sql, QueryPart... parts) RIGHT OUTER JOIN
a table to this table.@NotNull TablePartitionByStep
<Record> TableOuterJoinStep.rightOuterJoin
(String sql, QueryPart... parts) RIGHT OUTER JOIN
a table to this table.@NotNull QueryPart
Context.scopeMapping
(QueryPart part) Retrieve the registered mapping for a query part in the current scope.Context.scopeMarkEnd
(QueryPart part) Mark the end of a scoped query part.Context.scopeMarkStart
(QueryPart part) Mark the beginning of a scoped query part.Context.scopeRegister
(QueryPart part) Register a "special" query part in the scope, reusing the object from a higher scope, if available.Context.scopeRegister
(QueryPart part, boolean forceNew) Register a "special" query part in the scope, allowing to force registering the object in the new scope, if a higher scope already has the object.Context.scopeRegister
(QueryPart part, boolean forceNew, QueryPart mapped) Register a "special" query part in the scope, allowing to force registering the object in the new scope, if a higher scope already has the object, as well as providing a mapped part to map the original part to.Context.scopeRegisterAndMark
(QueryPart part, boolean forceNew) Context.scopeStart
(QueryPart part) Start a new scope, passing the currentQueryPart
as theContext.scopePart()
.@NotNull SelectWhereStep
<Record> DSLContext.selectFrom
(String sql, QueryPart... parts) Create a new DSL select statement, projecting*
.@NotNull SelectWhereStep
<Record> WithStep.selectFrom
(String sql, QueryPart... parts) Create a new DSL select statement, projecting*
.@NotNull SelectConnectByAfterStartWithStep
<R> Add an Oracle-specificSTART WITH
clause to the query'sCONNECT BY
clause.@NotNull SelectGroupByStep
<R> Add an Oracle-specificSTART WITH
clause to the query'sCONNECT BY
clause.@NotNull CreateTableFinalStep
Add theSTORAGE
clause to theCREATE TABLE
statement.@NotNull SelectOnStep
<R> SelectJoinStep.straightJoin
(String sql, QueryPart... parts) STRAIGHT_JOIN
a table to this table.@NotNull TableOnStep
<Record> Table.straightJoin
(String sql, QueryPart... parts) STRAIGHT_JOIN
a table to this table.Set the new context value forContext.subquery()
as well asContext.scopePart()
aSet the top levelQueryPart
that is being rendered.Context.topLevelForLanguageContext
(QueryPart topLevelForLanguageContext) Set the top levelQueryPart
that is being rendered in the currentContext.languageContext()
.@NotNull DeleteWhereStep
<R> Add aUSING
clause to the query.Visit aQueryPart
in the currentContext
.Visit a query part with a given value forContext.paramType()
.Context.visitSubquery
(QueryPart part) Visit aQueryPart
as a subquery in the currentContext
.@NotNull CreateTriggerActionStep
Add theWHEN
clause to theCREATE TRIGGER
statement.@NotNull MergeMatchedThenStep
<R> MergeMatchedStep.whenMatchedAnd
(String sql, QueryPart... parts) Add theWHEN MATCHED AND
clause to theMERGE
statement.@NotNull CreateIndexFinalStep
Add theWHERE
clause to theCREATE INDEX
statement.@NotNull DeleteConditionStep
<R> Add conditions to the query.@NotNull InsertOnConflictDoUpdateStep
<R> Add aWHERE
clause to supply an index predicate to theINSERT
statement'sON CONFLICT …
clause.@NotNull InsertOnConflictConditionStep
<R> Add aWHERE
clause to theINSERT
statement'sON DUPLICATE KEY UPDATE
orON CONFLICT … DO UPDATE
clause.@NotNull SelectConditionStep
<R> Add aWHERE
clause to the query.Add aWHERE
clause to the table.@NotNull UpdateConditionStep
<R> Add conditions to the querySpecify a SQL Server style table hint for query optimisation.@NotNull Condition
Combine this condition with another one using theOperator.XOR
operator.Modifier and TypeMethodDescriptiondefault @NotNull QueryPart
Traverse aQueryPart
hierarchy and recursively replace its elements by alternatives.default @NotNull QueryPart
Traverse aQueryPart
hierarchy and recursively replace its elements by alternatives.default <R> R
QueryPart.$traverse
(Supplier<R> supplier, BiFunction<? super R, ? super QueryPart, ? extends R> before) Traverser thisQueryPart
expression tree using a composablestatic <T,
R> Traverser <?, R> Traversers.collecting
(Collector<QueryPart, T, R> collector) A traverser constructed from aCollector
.static @NotNull Traverser
<?, ?> A traverser that traverses theQueryPart
tree without producing any results.Traversers.containing
(Predicate<? super QueryPart> predicate) Traversers.findingAll
(Predicate<? super QueryPart> predicate) Traversers.findingAny
(Predicate<? super QueryPart> predicate) static final @NotNull Replacer
Replacers.listening
(Replacer replacer, BiConsumer<? super QueryPart, ? super QueryPart> replacement) Wraps anotherReplacer
, listening to all of the replacement events that it produces.static final @NotNull Replacer
Replacers.listening
(Replacer replacer, BiConsumer<? super QueryPart, ? super QueryPart> replacement) Wraps anotherReplacer
, listening to all of the replacement events that it produces.static Replacer
Convenience method to create aReplacer
with aReplacer.replacer()
.static Replacer
Convenience method to create aReplacer
with aReplacer.replacer()
.static Replacer
Replacer.of
(Predicate<? super QueryPart> recurse, Function<? super QueryPart, ? extends QueryPart> replacer) static Replacer
Replacer.of
(Predicate<? super QueryPart> recurse, Function<? super QueryPart, ? extends QueryPart> replacer) static Replacer
Replacer.of
(Predicate<? super QueryPart> recurse, Function<? super QueryPart, ? extends QueryPart> replacer) static <A,
R> Traverser <A, R> Traverser.of
(Supplier<A> supplier, Predicate<? super A> abort, Predicate<? super QueryPart> recurse, BiFunction<? super A, ? super QueryPart, ? extends A> before, BiFunction<? super A, ? super QueryPart, ? extends A> after, Function<? super A, ? extends R> finisher) Convenience method to create aTraverser
with aTraverser.supplier()
,Traverser.abort()
,Traverser.recurse()
,Traverser.before()
,Traverser.after()
, andTraverser.finisher()
.static <A,
R> Traverser <A, R> Traverser.of
(Supplier<A> supplier, Predicate<? super A> abort, Predicate<? super QueryPart> recurse, Predicate<? super QueryPart> recurseChildren, BiFunction<? super A, ? super QueryPart, ? extends A> before, BiFunction<? super A, ? super QueryPart, ? extends A> after, Function<? super A, ? extends R> finisher) Convenience method to create aTraverser
with aTraverser.supplier()
,Traverser.abort()
,Traverser.recurse()
,Traverser.recurseChildren()
,Traverser.before()
,Traverser.after()
, andTraverser.finisher()
.static <R> Traverser
<R, R> Traverser.of
(Supplier<R> supplier, BiFunction<? super R, ? super QueryPart, ? extends R> before) static <R> Traverser
<R, R> Traverser.of
(Supplier<R> supplier, BiFunction<? super R, ? super QueryPart, ? extends R> before, BiFunction<? super R, ? super QueryPart, ? extends R> after) Convenience method to create aTraverser
with aTraverser.supplier()
,Traverser.before()
, andTraverser.after()
.static <R> Traverser
<R, R> Traverser.of
(Supplier<R> supplier, Predicate<? super R> abort, Predicate<? super QueryPart> recurse, BiFunction<? super R, ? super QueryPart, ? extends R> before) Convenience method to create aTraverser
with aTraverser.supplier()
,Traverser.abort()
,Traverser.recurse()
, andTraverser.before()
.static <R> Traverser
<R, R> Traverser.of
(Supplier<R> supplier, Predicate<? super R> abort, Predicate<? super QueryPart> recurse, BiFunction<? super R, ? super QueryPart, ? extends R> before, BiFunction<? super R, ? super QueryPart, ? extends R> after) Convenience method to create aTraverser
with aTraverser.supplier()
,Traverser.abort()
,Traverser.recurse()
,Traverser.before()
, andTraverser.after()
static <A,
R> Traverser <?, R> Combine a recursion test predicate with an existingTraverser
.static <A,
R> Traverser <?, R> Traversers.recursingChildren
(Predicate<? super QueryPart> recurseChildren, Traverser<A, R> downstream) Combine a recursion test predicate with an existingTraverser
. -
Uses of QueryPart in org.jooq.impl
Modifier and TypeInterfaceDescriptionstatic interface
QOM.Aliasable<Q extends QueryPart>
static interface
QOM.Tuple2<Q1 extends QueryPart,
Q2 extends QueryPart> A generic tuple of degree 2 for use inQOM
types.static interface
QOM.Tuple2<Q1 extends QueryPart,
Q2 extends QueryPart> A generic tuple of degree 2 for use inQOM
types.static interface
QOM.UnmodifiableCollection<Q extends QueryPart>
An unmodifiableCollection
ofQueryPart
elements.static interface
QOM.UnmodifiableList<Q extends QueryPart>
static interface
QOM.UnmodifiableMap<K extends QueryPart,
V extends QueryPart> static interface
QOM.UnmodifiableMap<K extends QueryPart,
V extends QueryPart> Modifier and TypeInterfaceDescriptionstatic interface
TheABS
function.static interface
TheACOS
function.static interface
TheACOSH
function.static interface
TheACOTH
function.static interface
QOM.Add<T>
TheADD
operator.static interface
QOM.Aliasable<Q extends QueryPart>
static interface
TheALTER DATABASE
statement.static interface
TheALTER DOMAIN
statement.static interface
TheALTER INDEX
statement.static interface
TheALTER SCHEMA
statement.static interface
QOM.AlterSequence<T extends Number>
TheALTER SEQUENCE
statement.static interface
TheALTER TYPE
statement.static interface
TheALTER VIEW
statement.static interface
TheAND
operator.static interface
QOM.AnyValue<T>
TheANY VALUE
function.static interface
QOM.Array<T>
static interface
QOM.ArrayAgg<T>
static interface
TheARRAY APPEND
function.static interface
TheARRAY CONCAT
function.static interface
QOM.ArrayGet<T>
TheARRAY GET
function.static interface
TheARRAY OVERLAP
function.static interface
TheARRAY PREPEND
function.static interface
static interface
TheARRAY REMOVE
function.static interface
TheARRAY REPLACE
function.static interface
TheASCII
function.static interface
TheASIN
function.static interface
TheASINH
function.static interface
static interface
TheATAN
function.static interface
TheATAN2
function.static interface
TheATANH
function.static interface
TheAVG
function.static interface
QOM.Between<T>
TheBETWEEN
predicate.static interface
QOM.BitAnd<T extends Number>
TheBIT AND
operator.static interface
QOM.BitAndAgg<T extends Number>
TheBIT AND AGG
function.static interface
TheBIT COUNT
function.static interface
QOM.BitGet<T extends Number>
TheBIT GET
function.static interface
TheBIT LENGTH
function.static interface
QOM.BitNand<T extends Number>
TheBIT NAND
operator.static interface
QOM.BitNandAgg<T extends Number>
TheBIT NAND AGG
function.static interface
QOM.BitNor<T extends Number>
TheBIT NOR
operator.static interface
QOM.BitNorAgg<T extends Number>
TheBIT NOR AGG
function.static interface
QOM.BitNot<T extends Number>
TheBIT NOT
operator.static interface
TheBIT OR
operator.static interface
QOM.BitOrAgg<T extends Number>
TheBIT OR AGG
function.static interface
QOM.BitSet<T extends Number>
TheBIT SET
function.static interface
QOM.BitXNor<T extends Number>
TheBIT X NOR
operator.static interface
QOM.BitXNorAgg<T extends Number>
TheBIT X NOR AGG
function.static interface
QOM.BitXor<T extends Number>
TheBIT XOR
operator.static interface
QOM.BitXorAgg<T extends Number>
TheBIT XOR AGG
function.static interface
TheBOOL AND
function.static interface
TheBOOL OR
function.static interface
TheCALL
statement.static interface
TheCARDINALITY
function.static interface
static interface
QOM.CaseSimple<V,
T> static interface
QOM.Cast<T>
static interface
TheCEIL
function.static interface
TheCHAR LENGTH
function.static interface
static interface
QOM.Choose<T>
static interface
TheCHR
function.static interface
QOM.Coalesce<T>
static interface
QOM.Coerce<T>
static interface
static interface
QOM.Collect<T,
A extends ArrayRecord<T>> static interface
QOM.CombinedCondition<R extends QOM.CombinedCondition<R>>
static interface
TheCOMMENT ON TABLE
statement.static interface
TheCOMMIT
statement.static interface
QOM.CompareCondition<T,
R extends QOM.CompareCondition<T, R>> static interface
static interface
TheFIELD
function.static interface
TheCONNECT BY ISCYCLE
function.static interface
TheCONNECT BY ISLEAF
function.static interface
TheCONNECT BY ROOT
function.static interface
QOM.Contains<T>
TheCONTAINS
operator.static interface
TheCONTAINS IGNORE CASE
operator.static interface
static interface
QOM.Convert<T>
static interface
TheCORR
function.static interface
TheCOS
function.static interface
TheCOSH
function.static interface
TheCOT
function.static interface
TheCOTH
function.static interface
TheCOUNT
function.static interface
static interface
TheCOVAR POP
function.static interface
TheCOVAR SAMP
function.static interface
TheCREATE DATABASE
statement.static interface
TheCREATE DOMAIN
statement.static interface
TheCREATE FUNCTION
statement.static interface
TheCREATE INDEX
statement.static interface
TheCREATE PROCEDURE
statement.static interface
TheCREATE SCHEMA
statement.static interface
TheCREATE SEQUENCE
statement.static interface
TheCREATE TABLE
statement.static interface
TheCREATE TRIGGER
statement.static interface
TheCREATE TYPE
statement.static interface
QOM.CreateView<R extends Record>
TheCREATE VIEW
statement.static interface
QOM.CrossApply<R extends Record>
static interface
QOM.CrossJoin<R extends Record>
static interface
static interface
static interface
TheCURRENT CATALOG
function.static interface
static interface
TheCURRENT SCHEMA
function.static interface
static interface
static interface
TheCURRENT USER
function.static interface
QOM.DataChangeDeltaTable<R extends Record>
static interface
QOM.DateAdd<T>
TheDATE ADD
function.static interface
static interface
QOM.Decode<V,
T> static interface
QOM.Default<T>
static interface
TheDEGREES
function.static interface
QOM.Delete<R extends Record>
TheDELETE
statement.static interface
QOM.DeleteReturning<R extends Record>
AnDELETE
statement with aRETURNING
clause.static interface
TheDELETING
function.static interface
static interface
QOM.DerivedTable<R extends Record>
static interface
TheDIGITS
function.static interface
QOM.Div<T>
TheDIV
operator.static interface
TheDROP DATABASE
statement.static interface
TheDROP DOMAIN
statement.static interface
TheDROP FUNCTION
statement.static interface
TheDROP INDEX
statement.static interface
TheDROP PROCEDURE
statement.static interface
TheDROP SCHEMA
statement.static interface
TheDROP SEQUENCE
statement.static interface
TheDROP TABLE
statement.static interface
TheDROP TRIGGER
statement.static interface
TheDROP TYPE
statement.static interface
TheDROP VIEW
statement.static interface
static interface
static interface
QOM.EndsWith<T>
TheENDS WITH
operator.static interface
TheENDS WITH IGNORE CASE
operator.static interface
QOM.Eq<T>
TheEQ
operator.static interface
TheEQ
operator.static interface
TheE
function.static interface
QOM.Excluded<T>
TheEXCLUDED
function.static interface
TheEXECUTE
function.static interface
TheEXISTS
function.static interface
static interface
TheEXP
function.static interface
static interface
ACondition
that is alwaysFALSE
.static interface
static interface
TheCONDITION
function.static interface
static interface
static interface
TheFLOOR
function.static interface
static interface
QOM.FullJoin<R extends Record>
static interface
QOM.Function<T>
static interface
QOM.Ge<T>
TheGE
operator.static interface
static interface
TheGE
operator.static interface
TheGOTO
function.static interface
TheGRANT
statement.static interface
QOM.Greatest<T>
static interface
static interface
QOM.Gt<T>
TheGT
operator.static interface
TheGT
operator.static interface
QOM.HintedTable<R extends Record>
A table with a MySQL style index access hint.static interface
static interface
QOM.Iif<T>
static interface
QOM.In<T>
TheIN
operator.static interface
QOM.InList<T>
TheIN
predicate accepting a list of values.static interface
QOM.Insert<R extends Record>
TheINSERT
statement.static interface
TheINSERTING
function.static interface
QOM.InsertReturning<R extends Record>
AnINSERT
statement with aRETURNING
clause.static interface
TheIS DISTINCT FROM
operator.static interface
TheIS DOCUMENT
operator.static interface
TheIS JSON
operator.static interface
TheIS NOT DISTINCT FROM
operator.static interface
TheIS NOT DOCUMENT
operator.static interface
TheIS NOT JSON
operator.static interface
TheIS NOT NULL
operator.static interface
TheIS NULL
operator.static interface
static interface
QOM.JoinTable<R extends Record,
J extends QOM.JoinTable<R, J>> static interface
TheJSON ARRAY
function.static interface
static interface
TheJSONB GET ATTRIBUTE
function.static interface
TheJSONB GET ATTRIBUTE AS TEXT
function.static interface
TheJSONB GET ELEMENT
function.static interface
TheJSONB GET ELEMENT AS TEXT
function.static interface
TheJSONB INSERT
function.static interface
TheJSONB KEYS
function.static interface
TheJSONB REMOVE
function.static interface
TheJSONB REPLACE
function.static interface
TheJSONB SET
function.static interface
TheJSON GET ATTRIBUTE
function.static interface
TheJSON GET ATTRIBUTE AS TEXT
function.static interface
TheJSON GET ELEMENT
function.static interface
TheJSON GET ELEMENT AS TEXT
function.static interface
TheJSON INSERT
function.static interface
TheJSON KEYS
function.static interface
TheJSON OBJECT
function.static interface
static interface
TheJSON REMOVE
function.static interface
TheJSON REPLACE
function.static interface
TheJSON SET
function.static interface
static interface
static interface
QOM.Lag<T>
static interface
static interface
QOM.Lateral<R extends Record>
static interface
QOM.Le<T>
TheLE
operator.static interface
QOM.Lead<T>
static interface
QOM.Least<T>
static interface
TheLEFT
function.static interface
QOM.LeftAntiJoin<R extends Record>
static interface
QOM.LeftJoin<R extends Record>
static interface
QOM.LeftSemiJoin<R extends Record>
static interface
TheLE
operator.static interface
TheLEVEL
function.static interface
TheLIKE
operator.static interface
TheLIKE IGNORE CASE
operator.static interface
TheLIKE
operator.static interface
QOM.LinkedTable<R extends Record>
A table with a database link.static interface
TheLN
function.static interface
TheLOG
function.static interface
TheLOG10
function.static interface
static interface
TheLOWER
function.static interface
TheLPAD
function.static interface
QOM.Lt<T>
TheLT
operator.static interface
TheLT
operator.static interface
TheLTRIM
function.static interface
QOM.Max<T>
TheMAX
function.static interface
TheMD5
function.static interface
TheMEDIAN
function.static interface
QOM.Min<T>
TheMIN
function.static interface
TheMOD
operator.static interface
QOM.Mode<T>
static interface
QOM.Mul<T>
TheMUL
operator.static interface
QOM.Multiset<R extends Record>
static interface
QOM.MultisetAgg<R extends Record>
static interface
QOM.NaturalFullJoin<R extends Record>
static interface
QOM.NaturalJoin<R extends Record>
static interface
QOM.NaturalLeftJoin<R extends Record>
static interface
QOM.NaturalRightJoin<R extends Record>
static interface
QOM.Ne<T>
TheNE
operator.static interface
QOM.Neg<T>
static interface
TheNE
operator.static interface
TheNOT
operator.static interface
TheNOT
operator.static interface
QOM.NotIn<T>
TheNOT IN
operator.static interface
TheNOT IN
predicate accepting a list of values.static interface
TheNOT LIKE
operator.static interface
TheNOT LIKE IGNORE CASE
operator.static interface
TheNOT LIKE
operator.static interface
TheNOT SIMILAR TO
operator.static interface
TheNOT SIMILAR TO
operator.static interface
QOM.NthValue<T>
static interface
static interface
ACondition
that is alwaysNULL
.static interface
QOM.Nullif<T>
TheNULLIF
function.static interface
static interface
QOM.Nvl<T>
TheNVL
function.static interface
QOM.Nvl2<T>
static interface
TheOCTET LENGTH
function.static interface
TheOR
operator.static interface
QOM.OuterApply<R extends Record>
static interface
TheOVERLAY
function.static interface
static interface
ThePI
function.static interface
QOM.PlusJoin<T>
ThePLUS
operator.static interface
ThePOSITION
function.static interface
ThePOWER
operator.static interface
static interface
QOM.Prior<T>
ThePRIOR
function.static interface
ThePRODUCT
function.static interface
QOM.QualifiedJoin<R extends Record,
J extends QOM.QualifiedJoin<R, J>> static interface
TheROWID
operator.static interface
static interface
static interface
QOM.QuantifiedSelect<R extends Record>
static interface
TheRADIANS
function.static interface
TheRAND
function.static interface
static interface
static interface
static interface
TheREGR AVGX
function.static interface
TheREGR AVGY
function.static interface
TheREGR COUNT
function.static interface
TheREGR INTERCEPT
function.static interface
TheREGR R2
function.static interface
TheREGR SLOPE
function.static interface
TheREGR SXX
function.static interface
TheREGR SXY
function.static interface
TheREGR SYY
function.static interface
TheRELEASE SAVEPOINT
statement.static interface
TheREPEAT
function.static interface
TheREPLACE
function.static interface
TheRETURN_
function.static interface
TheREVERSE
function.static interface
TheREVOKE
statement.static interface
TheRIGHT
function.static interface
QOM.RightJoin<R extends Record>
static interface
TheROLLBACK
statement.static interface
static interface
TheROUND
function.static interface
QOM.RowAsField<R extends Record>
static interface
static interface
TheROW EQ
operator.static interface
TheROW GE
operator.static interface
TheROW GT
operator.static interface
static interface
static interface
TheROW LE
operator.static interface
TheROW LT
operator.static interface
TheROW NE
operator.static interface
TheROWNUM
function.static interface
static interface
static interface
static interface
static interface
TheRPAD
function.static interface
TheRTRIM
function.static interface
TheSAVEPOINT
statement.static interface
static interface
static interface
static interface
TheSET CATALOG
statement.static interface
TheSET
statement.static interface
TheSET SCHEMA
statement.static interface
TheSHL
operator.static interface
TheSHR
operator.static interface
TheSIGN
function.static interface
TheSIGNAL SQL STATE
function.static interface
TheSIMILAR TO
operator.static interface
TheSIMILAR TO
operator.static interface
TheSIN
function.static interface
TheSINH
function.static interface
TheSPACE
function.static interface
TheSPLIT PART
function.static interface
TheSQRT
function.static interface
QOM.Square<T extends Number>
TheSQUARE
function.static interface
TheST AREA
function.static interface
TheSTARTS WITH
operator.static interface
TheSTARTS WITH IGNORE CASE
operator.static interface
TheSTART TRANSACTION
statement.static interface
TheST ASBINARY
function.static interface
TheST ASTEXT
function.static interface
TheST CENTROID
function.static interface
QOM.StContains<T extends Spatial>
TheST CONTAINS
function.static interface
TheST CROSSES
function.static interface
TheSTDDEV POP
function.static interface
TheSTDDEV SAMP
function.static interface
QOM.StDifference<T extends Spatial>
TheST DIFFERENCE
function.static interface
QOM.StDisjoint<T extends Spatial>
TheST DISJOINT
function.static interface
QOM.StDistance<T extends Spatial>
TheST DISTANCE
function.static interface
QOM.StEndPoint<T extends Spatial>
TheST ENDPOINT
function.static interface
QOM.StEquals<T extends Spatial>
TheST EQUALS
function.static interface
TheST EXTERIORRING
function.static interface
QOM.StGeometryN<T extends Spatial>
TheST GEOMETRYN
function.static interface
TheST GEOMETRYTYPE
function.static interface
TheST GEOMFROMTEXT
function.static interface
TheST GEOMFROMWKB
function.static interface
TheST INTERIORRINGN
function.static interface
QOM.StIntersection<T extends Spatial>
TheST INTERSECTION
function.static interface
QOM.StIntersects<T extends Spatial>
TheST INTERSECTS
function.static interface
TheST ISCLOSED
function.static interface
TheST ISEMPTY
function.static interface
TheST LENGTH
function.static interface
TheST NUMGEOMETRIES
function.static interface
TheST NUMINTERIORRING
function.static interface
TheST NUMPOINTS
function.static interface
QOM.StOverlaps<T extends Spatial>
TheST OVERLAPS
function.static interface
QOM.StPointN<T extends Spatial>
TheST POINTN
function.static interface
QOM.StraightJoin<R extends Record>
static interface
TheST SRID
function.static interface
QOM.StStartPoint<T extends Spatial>
TheST STARTPOINT
function.static interface
QOM.StTouches<T extends Spatial>
TheST TOUCHES
function.static interface
QOM.StUnion<T extends Spatial>
TheST UNION
function.static interface
QOM.StWithin<T extends Spatial>
TheST WITHIN
function.static interface
TheST X
function.static interface
TheST Y
function.static interface
TheST Z
function.static interface
QOM.Sub<T>
TheSUB
operator.static interface
TheSUBSTRING
function.static interface
TheSUBSTRING INDEX
function.static interface
TheSUM
function.static interface
TheSYS CONNECT BY PATH
function.static interface
QOM.TableAlias<R extends Record>
static interface
QOM.TableAsField<R extends Record>
static interface
QOM.TableEq<R extends Record>
TheEQ
operator.static interface
QOM.TableNe<R extends Record>
TheNE
operator.static interface
TheTAN
function.static interface
TheTANH
function.static interface
TheTAU
function.static interface
static interface
TheTO CHAR
function.static interface
TheTO DATE
function.static interface
TheTO HEX
function.static interface
TheTO TIMESTAMP
function.static interface
TheTRANSLATE
function.static interface
TheTRIM
function.static interface
ACondition
that is alwaysTRUE
.static interface
TheTRUNC
function.static interface
QOM.Truncate<R extends Record>
TheTRUNCATE
statement.static interface
QOM.TryCast<T>
TheTRY CAST
function.static interface
QOM.Tuple2<Q1 extends QueryPart,
Q2 extends QueryPart> A generic tuple of degree 2 for use inQOM
types.(package private) static interface
org.jooq.impl.QOM.UCommutativeOperator<Q,
R extends org.jooq.impl.QOM.UCommutativeOperator<Q, R>> A binaryQOM.UOperator2
whose operands can be swapped usingQOM.UCommutativeOperator.$swap()
without changing the operator's semantics.(package private) static interface
org.jooq.impl.QOM.UConvertibleOperator<Q,
R extends org.jooq.impl.QOM.UConvertibleOperator<Q, R, C>, C extends org.jooq.impl.QOM.UConvertibleOperator<Q, C, R>> A binaryQOM.UOperator2
whose operands can be swapped usingQOM.UConvertibleOperator.$converse()
producing the converse relation.(package private) static interface
org.jooq.impl.QOM.UEmpty
static interface
TheUNIQUE
function.static interface
static interface
QOM.UnmodifiableCollection<Q extends QueryPart>
An unmodifiableCollection
ofQueryPart
elements.static interface
QOM.UnmodifiableList<Q extends QueryPart>
static interface
QOM.UnmodifiableMap<K extends QueryPart,
V extends QueryPart> (package private) static interface
org.jooq.impl.QOM.UOperator<R extends QueryPart>
(package private) static interface
org.jooq.impl.QOM.UOperator0<R extends org.jooq.impl.QOM.UOperator0<R>>
(package private) static interface
org.jooq.impl.QOM.UOperator1<Q1,
R extends org.jooq.impl.QOM.UOperator1<Q1, R>> (package private) static interface
org.jooq.impl.QOM.UOperator2<Q1,
Q2, R extends org.jooq.impl.QOM.UOperator2<Q1, Q2, R>> (package private) static interface
org.jooq.impl.QOM.UOperator3<Q1,
Q2, Q3, R extends org.jooq.impl.QOM.UOperator3<Q1, Q2, Q3, R>> (package private) static interface
org.jooq.impl.QOM.UOperator4<Q1,
Q2, Q3, Q4, R extends org.jooq.impl.QOM.UOperator4<Q1, Q2, Q3, Q4, R>> static interface
QOM.Update<R extends Record>
TheUPDATE
statement.static interface
QOM.UpdateReturning<R extends Record>
AnUPDATE
statement with aRETURNING
clause.static interface
TheUPDATING
function.static interface
TheUPPER
function.(package private) static interface
org.jooq.impl.QOM.UReturnsNullOnNullInput
A marker interface forQueryPart
implementations that represent functions or operators who evaluate toNULL
as soon as at least one argument isNULL
.static interface
TheUUID
function.static interface
QOM.Values<R extends Record>
static interface
TheVAR POP
function.static interface
TheVAR SAMP
function.static interface
QOM.WidthBucket<T extends Number>
TheWIDTH BUCKET
function.static interface
static interface
static interface
QOM.WithOrdinalityTable<R extends Record>
A collection derived table or table valued function with aWITH ORDINALITY
clause.static interface
QOM.WithTable<R extends Record>
A table with a T-SQL styleWITH
hint.static interface
static interface
TheXMLCOMMENT
function.static interface
TheXMLCONCAT
function.static interface
TheXMLDOCUMENT
function.static interface
static interface
static interface
TheXMLFOREST
function.static interface
static interface
TheXMLPI
function.static interface
static interface
TheXMLSERIALIZE
function.static interface
TheXOR
operator.Modifier and TypeClassDescriptionclass
A common base class for stored proceduresclass
An internal marker subtype ofDefaultDataType
, to be used only by built-in data types inSQLDataType
and dialect specific data type classes, such as e.g.class
A common base class for database catalogsclass
A base class for customCondition
implementations in client code.class
CustomField<T>
A base class for customField
implementations in client code.class
A base class for customQueryPart
implementations in client code.class
A base class for customStatement
implementations in client code.class
CustomTable<R extends TableRecord<R>>
A base class for customTable
implementations in client code.class
A common base class for data types.final class
A schema that references a lazy initialisableCatalog
singleton, for use in generated code.final class
A schema that references a lazy initialisableSchema
singleton, for use in generated code.class
A default implementation for packages (containers of stored procedures and functions)class
A common base class for database schemataclass
SequenceImpl<T extends Number>
A common base class for sequencesclass
A common base type for tablesclass
A common base type for UDT'sclass
UDTPathFieldImpl<R extends Record,
U extends UDTRecord<U>, T> A common base type for UDT path fields.class
UDTPathTableFieldImpl<R extends Record,
U extends UDTRecord<U>, T> A common base type for table fields that are alsoUDTPathField
.Modifier and TypeMethodDescriptionstatic final <Q1 extends QueryPart,
Q2 extends QueryPart>
QOM.Tuple2<Q1, Q2> QOM.tuple
(Q1 q1, Q2 q2) static final <Q1 extends QueryPart,
Q2 extends QueryPart>
QOM.Tuple2<Q1, Q2> QOM.tuple
(Q1 q1, Q2 q2) static final <Q extends QueryPart>
QOM.UnmodifiableList<Q> QOM.unmodifiable
(Collection<Q> collection) Turn aCollection
into an unmodifiableQOM.UnmodifiableList
.static final <Q extends QueryPart>
QOM.UnmodifiableList<Q> QOM.unmodifiable
(List<Q> list) Turn aList
into an unmodifiableQOM.UnmodifiableList
.static final <K extends QueryPart,
V extends QueryPart>
QOM.UnmodifiableMap<K, V> QOM.unmodifiable
(Map<K, V> map) Turn aMap
into an unmodifiableQOM.UnmodifiableMap
.static final <K extends QueryPart,
V extends QueryPart>
QOM.UnmodifiableMap<K, V> QOM.unmodifiable
(Map<K, V> map) Turn aMap
into an unmodifiableQOM.UnmodifiableMap
.static final <Q extends QueryPart>
QOM.UnmodifiableList<Q> QOM.unmodifiable
(Q[] array) Turn an array into an unmodifiableQOM.UnmodifiableList
.Modifier and TypeMethodDescriptionfinal QueryPart
final QueryPart
final QueryPart
static @NotNull QueryPart
Inline all bind variables produced by the argumentQueryPart
.static @NotNull QueryPart
DSL.list
(Collection<? extends QueryPart> parts) Compose a list ofQueryParts
into a newQueryPart
, with individual parts being comma-separated.static @NotNull QueryPart
Compose a list ofQueryParts
into a newQueryPart
, with individual parts being comma-separated.Modifier and TypeMethodDescriptionstatic @NotNull Condition
A custom SQL clause that can render arbitrary SQL elements.int
DefaultDSLContext.extractBindValues
(QueryPart part) Param
<?> DefaultDSLContext.extractParam
(QueryPart part, String name) DefaultDSLContext.extractParams
(QueryPart part) DefaultDSLContext.fetchAsync
(String sql, QueryPart... parts) DefaultDSLContext.fetchAsync
(Executor executor, String sql, QueryPart... parts) DefaultDSLContext.fetchOptional
(String sql, QueryPart... parts) Optional
<?> DefaultDSLContext.fetchOptionalValue
(String sql, QueryPart... parts) DefaultDSLContext.fetchSingle
(String sql, QueryPart... parts) DefaultDSLContext.fetchStream
(String sql, QueryPart... parts) DefaultDSLContext.fetchValue
(String sql, QueryPart... parts) List
<?> DefaultDSLContext.fetchValues
(String sql, QueryPart... parts) static <T> @NotNull Field
<T> A custom SQL clause that can render arbitrary SQL elements.static <T> @NotNull Field
<T> Create a "plain SQL" field.A custom SQL clause that can render arbitrary SQL elements.static final int
Return a non-negative hash code for aQueryPart
, taking into account FindBugs'RV_ABSOLUTE_VALUE_OF_HASHCODE
patternstatic @NotNull QueryPart
Inline all bind variables produced by the argumentQueryPart
.static @NotNull QueryPart
Compose a list ofQueryParts
into a newQueryPart
, with individual parts being comma-separated.static @NotNull RowCountQuery
Create a new query holding plain SQL.DefaultDSLContext.renderInlined
(QueryPart part) DefaultDSLContext.renderNamedOrInlinedParams
(QueryPart part) DefaultDSLContext.renderNamedParams
(QueryPart part) DefaultDSLContext.resultQuery
(String sql, QueryPart... parts) static @NotNull ResultQuery
<Record> DSL.resultQuery
(String sql, QueryPart... parts) Create a new query holding plain SQL.DefaultDSLContext.selectFrom
(String sql, QueryPart... parts) static @NotNull SelectWhereStep
<Record> DSL.selectFrom
(String sql, QueryPart... parts) Create a new DSL select statement, projecting*
.static @NotNull SQL
A custom SQL clause that can render arbitrary expressions.static @NotNull Statement
A custom procedural fragment that can render arbitrary statements.A custom SQL clause that can render arbitrary table expressions.static final <Q extends QueryPart>
QOM.UnmodifiableList<Q> QOM.unmodifiable
(Q[] array) Turn an array into an unmodifiableQOM.UnmodifiableList
.Modifier and TypeMethodDescriptionstatic @NotNull QueryPart
DSL.list
(Collection<? extends QueryPart> parts) Compose a list ofQueryParts
into a newQueryPart
, with individual parts being comma-separated.