This API is EXPERIMENTAL. Use at your own risk.
This class provides a single namespace for jOOQ's query object model API.
Every QueryPart from the DSL API has a matching QueryPart
representation in this query object model API, and a shared internal
implementation in the org.jooq.impl package, that covers both
the DSL and model API functionality.
The goal of this model API is to allow for expression tree transformations
via QueryPart#$replace(Function1) as well as via per-querypart
methods, such as for example Substring#$startingPosition(Field), and
traversals via QueryPart#$traverse(Traverser) that are independent of
the DSL API that would otherwise be too noisy for this task.
In order to avoid conflicts between the model API and the DSL API, all model API in this class follows these naming conventions:
QOM class, whereas
DSL API types are top level types in the org.jooq package.$property(), e.g. Substring#$startingPosition() and
Substring#$startingPosition(Field).UXyz, e.g.
UEmpty
The API offers public access to jOOQ's internal representation, and as such, is prone to incompatible changes between minor releases, in addition to the incompatible changes that may arise due to this API being experimental. In this experimental stage, the following limitations are accepted:
QueryPart implementations have a corresponding public
QueryPart type yet, but may just implement the API via a
UEmpty or UNotYetImplemented subtype, and may not provide
access to contents via accessor methods.QueryPart may not yet be represented in
the model API, such as for example the SELECT … FOR UPDATE
clause, as substantial changes to the internal model are still required
before being able to offer public access to it.
While some elements of this API are historically mutable (either mutable
objects are returned from QueryPart subtypes, or argument objects
when constructing an QueryPart remains mutable, rather than copied),
users must not rely on this mutable behaviour. Once this API stabilises, all
mutability will be gone, accidental remaining mutability will be considered a
bug.
A future Java 17 distribution of jOOQ might make use of sealed types to improve the usability of the model API in pattern matching expressions etc. Other Java language features that benefit pattern matching expression trees might be adopted in the future in this area of the jOOQ API.
| Modifier and Type | Class and Description |
|---|---|
| public static interface | |
| public static interface | |
| public static interface | |
| public static interface | |
| public static interface | |
| public static interface | QOM.Aliasable<Q extends QueryPart>
A |
| public static interface | QOM.AlterDatabase
The |
| public static interface | |
| public static interface | QOM.AlterIndex
The |
| public static interface | QOM.AlterSchema
The |
| public static interface | |
| public static interface | QOM.AlterType
The |
| public static interface | QOM.AlterView
The |
| public static interface | |
| public static interface | QOM.AnyValue<T>
Deprecated
as a consequence of The AggregateFunction being deprecated.
ANY VALUE function.
|
| public static interface | |
| public static interface | |
| public static interface | QOM.ArrayAppend<T>
Deprecated
as a consequence of The Field being deprecated.
ARRAY APPEND function.
|
| public static interface | QOM.ArrayConcat<T>
Deprecated
as a consequence of The Field being deprecated.
ARRAY CONCAT function.
|
| public static interface | |
| public static interface | QOM.ArrayOverlap<T>
Deprecated
as a consequence of The Condition being deprecated.
ARRAY OVERLAP function.
|
| public static interface | QOM.ArrayPrepend<T>
Deprecated
as a consequence of The Field being deprecated.
ARRAY PREPEND function.
|
| public static interface | |
| public static interface | QOM.ArrayRemove<T>
Deprecated
as a consequence of The Field being deprecated.
ARRAY REMOVE function.
|
| public static interface | QOM.ArrayReplace<T>
Deprecated
as a consequence of The Field being deprecated.
ARRAY REPLACE function.
|
| public static interface | |
| public static interface | |
| public static interface | |
| public static interface | |
| public static interface | |
| public static interface | |
| public static interface | |
| public static interface | |
| public static interface | QOM.BitAnd<T extends Number>
Deprecated
as a consequence of The Field being deprecated.
BIT AND operator.
|
| public static interface | QOM.BitAndAgg<T extends Number>
Deprecated
as a consequence of The AggregateFunction being deprecated.
BIT AND AGG function.
|
| public static interface | |
| public static interface | QOM.BitGet<T extends Number>
Deprecated
as a consequence of The Field being deprecated.
BIT GET function.
|
| public static interface | |
| public static interface | QOM.BitNand<T extends Number>
Deprecated
as a consequence of The Field being deprecated.
BIT NAND operator.
|
| public static interface | QOM.BitNandAgg<T extends Number>
Deprecated
as a consequence of The AggregateFunction being deprecated.
BIT NAND AGG function.
|
| public static interface | QOM.BitNor<T extends Number>
Deprecated
as a consequence of The Field being deprecated.
BIT NOR operator.
|
| public static interface | QOM.BitNorAgg<T extends Number>
Deprecated
as a consequence of The AggregateFunction being deprecated.
BIT NOR AGG function.
|
| public static interface | QOM.BitNot<T extends Number>
Deprecated
as a consequence of The Field being deprecated.
BIT NOT operator.
|
| public static interface | |
| public static interface | QOM.BitOrAgg<T extends Number>
Deprecated
as a consequence of The AggregateFunction being deprecated.
BIT OR AGG function.
|
| public static interface | QOM.BitSet<T extends Number>
Deprecated
as a consequence of The Field being deprecated.
BIT SET function.
|
| public static interface | QOM.BitXNor<T extends Number>
Deprecated
as a consequence of The Field being deprecated.
BIT X NOR operator.
|
| public static interface | QOM.BitXNorAgg<T extends Number>
Deprecated
as a consequence of The AggregateFunction being deprecated.
BIT X NOR AGG function.
|
| public static interface | QOM.BitXor<T extends Number>
Deprecated
as a consequence of The Field being deprecated.
BIT XOR operator.
|
| public static interface | QOM.BitXorAgg<T extends Number>
Deprecated
as a consequence of The AggregateFunction being deprecated.
BIT XOR AGG function.
|
| public static interface | QOM.BoolAnd
Deprecated
as a consequence of The AggregateFunction being deprecated.
BOOL AND function.
|
| public static interface | |
| public static interface | |
| public static enum | QOM.Cascade
The |
| public static interface | |
| public static interface | |
| public static interface | |
| public static interface | |
| public static interface | |
| public static interface | QOM.Check
Deprecated
as a consequence of
Constraint being deprecated.
|
| public static interface | |
| public static interface | |
| public static interface | |
| public static interface | |
| public static interface | QOM.Collated
Deprecated
as a consequence of
Field being deprecated.
|
| public static interface | QOM.CombinedCondition<R extends QOM.
Deprecated
as a consequence of A Condition being deprecated.
Condition consisting of two Condition operands and a
binary logic Operator.
|
| public static interface | QOM.CommentOn
The |
| public static interface | QOM.Commit
The |
| public static interface | QOM.CompareCondition<T, R extends QOM.
Deprecated
as a consequence of A Condition being deprecated.
Condition consisting of two Field operands and a
Comparator operator.
|
| public static interface | QOM.Concat
Deprecated
as a consequence of
Field being deprecated.
|
| public static interface | |
| public static interface | QOM.Contains<T>
Deprecated
as a consequence of The QOM.CompareCondition being deprecated.
CONTAINS operator.
|
| public static interface | QOM.ContainsIgnoreCase<T>
Deprecated
as a consequence of The QOM.CompareCondition being deprecated.
CONTAINS IGNORE CASE operator.
|
| public static interface | |
| public static interface | |
| public static interface | |
| public static interface | |
| public static interface | |
| public static interface | |
| public static interface | |
| public static interface | QOM.CountTable
Deprecated
as a consequence of
AggregateFunction being deprecated.
|
| public static interface | QOM.CovarPop
Deprecated
as a consequence of The AggregateFunction being deprecated.
COVAR POP function.
|
| public static interface | QOM.CovarSamp
Deprecated
as a consequence of The AggregateFunction being deprecated.
COVAR SAMP function.
|
| public static interface | QOM.CreateDatabase
The |
| public static interface | |
| public static interface | QOM.CreateIndex
The |
| public static interface | QOM.CreateSchema
The |
| public static interface | QOM.CreateSequence
The |
| public static interface | QOM.CreateTable
The |
| public static interface | QOM.CreateType
The |
| public static interface | |
| public static interface | |
| public static interface | |
| public static interface | |
| public static interface | QOM.CumeDist
Deprecated
as a consequence of
QOM.WindowFunction being deprecated.
|
| public static interface | QOM.CurrentCatalog
Deprecated
as a consequence of The Field being deprecated.
CURRENT CATALOG function.
|
| public static interface | |
| public static interface | QOM.CurrentSchema
Deprecated
as a consequence of The Field being deprecated.
CURRENT SCHEMA function.
|
| public static interface | |
| public static interface | |
| public static interface | |
| public static enum | QOM.CycleOption
The |
| public static interface | |
| public static interface | |
| public static interface | |
| public static interface | |
| public static interface | |
| public static interface | |
| public static interface | |
| public static interface | QOM.DenseRank
Deprecated
as a consequence of
QOM.WindowFunction being deprecated.
|
| public static interface | |
| public static interface | |
| public static interface | |
| public static enum | QOM.DocumentOrContent
The |
| public static interface | QOM.DropDatabase
The |
| public static interface | QOM.DropDomain
The |
| public static interface | QOM.DropIndex
The |
| public static interface | QOM.DropSchema
The |
| public static interface | QOM.DropSequence
The |
| public static interface | QOM.DropTable
The |
| public static interface | QOM.DropType
The |
| public static interface | QOM.DropView
The |
| public static interface | |
| public static interface | |
| public static interface | QOM.EndsWith<T>
Deprecated
as a consequence of The QOM.CompareCondition being deprecated.
ENDS WITH operator.
|
| public static interface | QOM.EndsWithIgnoreCase<T>
Deprecated
as a consequence of The QOM.CompareCondition being deprecated.
ENDS WITH IGNORE CASE operator.
|
| public static interface | |
| public static interface | |
| public static interface | |
| public static interface | |
| public static interface | |
| public static interface | |
| public static interface | QOM.Extract
Deprecated
as a consequence of
Field being deprecated.
|
| public static interface | |
| public static interface | |
| public static interface | QOM.FieldCondition
Deprecated
as a consequence of The Condition being deprecated.
CONDITION function.
|
| public static interface | |
| public static interface | |
| public static interface | |
| public static interface | QOM.ForeignKey
Deprecated
as a consequence of
Constraint being deprecated.
|
| public static enum | QOM.FrameExclude
The |
| public static enum | QOM.FrameUnits
The |
| public static enum | QOM.FromFirstOrLast
The |
| public static interface | |
| public static interface | |
| public static interface | |
| public static interface | |
| public static enum | QOM.GenerationLocation
The |
| public static enum | QOM.GenerationOption
The |
| public static interface | |
| public static interface | QOM.Grant
The |
| public static interface | |
| public static interface | |
| public static interface | |
| public static interface | |
| public static interface | |
| public static enum | QOM.IdentityRestartOption
The |
| public static interface | |
| public static interface | |
| public static interface | QOM.InList<T>
Deprecated
as a consequence of The Condition being deprecated.
IN predicate accepting a list of values.
|
| public static interface | |
| public static interface | |
| public static interface | QOM.IsDistinctFrom<T>
Deprecated
as a consequence of The QOM.CompareCondition being deprecated.
IS DISTINCT FROM operator.
|
| public static interface | |
| public static interface | |
| public static interface | QOM.IsNotDistinctFrom<T>
Deprecated
as a consequence of The QOM.CompareCondition being deprecated.
IS NOT DISTINCT FROM operator.
|
| public static interface | QOM.IsNotDocument
Deprecated
as a consequence of The Condition being deprecated.
IS NOT DOCUMENT operator.
|
| public static interface | |
| public static interface | |
| public static interface | |
| public static interface | |
| public static interface | |
| public static interface | |
| public static interface | |
| public static interface | QOM.JSONBGetAttribute
Deprecated
as a consequence of The Field being deprecated.
JSONB GET ATTRIBUTE function.
|
| public static interface | QOM.JSONBGetAttributeAsText
Deprecated
as a consequence of The Field being deprecated.
JSONB GET ATTRIBUTE AS TEXT function.
|
| public static interface | QOM.JSONBGetElement
Deprecated
as a consequence of The Field being deprecated.
JSONB GET ELEMENT function.
|
| public static interface | QOM.JSONBGetElementAsText
Deprecated
as a consequence of The Field being deprecated.
JSONB GET ELEMENT AS TEXT function.
|
| public static interface | |
| public static interface | |
| public static interface | |
| public static interface | |
| public static interface | |
| public static interface | QOM.JSONGetAttribute
Deprecated
as a consequence of The Field being deprecated.
JSON GET ATTRIBUTE function.
|
| public static interface | QOM.JSONGetAttributeAsText
Deprecated
as a consequence of The Field being deprecated.
JSON GET ATTRIBUTE AS TEXT function.
|
| public static interface | QOM.JSONGetElement
Deprecated
as a consequence of The Field being deprecated.
JSON GET ELEMENT function.
|
| public static interface | QOM.JSONGetElementAsText
Deprecated
as a consequence of The Field being deprecated.
JSON GET ELEMENT AS TEXT function.
|
| public static interface | |
| public static interface | |
| public static interface | |
| public static interface | |
| public static enum | QOM.JSONOnNull
The |
| public static interface | |
| public static interface | |
| public static interface | |
| public static interface | |
| public static interface | |
| public static interface | |
| public static interface | |
| public static interface | |
| public static interface | |
| public static interface | |
| public static interface | |
| public static interface | |
| public static interface | |
| public static interface | |
| public static interface | |
| public static interface | QOM.LikeIgnoreCase
Deprecated
as a consequence of The Condition being deprecated.
LIKE IGNORE CASE operator.
|
| public static interface | |
| public static interface | |
| public static interface | |
| public static interface | |
| public static interface | |
| public static interface | |
| public static interface | |
| public static interface | |
| public static interface | |
| public static enum | QOM.Materialized
The |
| public static interface | |
| public static interface | |
| public static interface | |
| public static interface | |
| public static interface | |
| public static interface | |
| public static interface | |
| public static interface | |
| public static interface | QOM.MultisetAgg<R extends Record>
Deprecated
as a consequence of
AggregateFunction being deprecated.
|
| public static interface | |
| public static interface | |
| public static interface | |
| public static interface | |
| public static interface | |
| public static interface | |
| public static interface | |
| public static interface | |
| public static interface | |
| public static interface | |
| public static interface | QOM.NotInList<T>
Deprecated
as a consequence of The Condition being deprecated.
NOT IN predicate accepting a list of values.
|
| public static interface | |
| public static interface | QOM.NotLikeIgnoreCase
Deprecated
as a consequence of The Condition being deprecated.
NOT LIKE IGNORE CASE operator.
|
| public static interface | QOM.NotLikeQuantified
Deprecated
as a consequence of The Condition being deprecated.
NOT LIKE operator.
|
| public static interface | QOM.NotSimilarTo
Deprecated
as a consequence of The Condition being deprecated.
NOT SIMILAR TO operator.
|
| public static interface | QOM.NotSimilarToQuantified
Deprecated
as a consequence of The Condition being deprecated.
NOT SIMILAR TO operator.
|
| public static class | QOM.NotYetImplementedException
Deprecated
for removal. - [#12425] - 3.16.0 - Missing implementations should be added
as soon as possible!
A marker interface for QueryPart methods that have not yet been
implemented.
|
| public static interface | |
| public static interface | QOM.Ntile
Deprecated
as a consequence of
QOM.WindowFunction being deprecated.
|
| public static interface | |
| public static interface | |
| public static enum | QOM.NullOrdering
The |
| public static interface | |
| public static enum | QOM.NullTreatment
The |
| public static interface | |
| public static interface | |
| public static interface | |
| public static interface | |
| public static interface | |
| public static interface | |
| public static interface | QOM.PercentRank
Deprecated
as a consequence of
QOM.WindowFunction being deprecated.
|
| public static interface | |
| public static interface | |
| public static interface | |
| public static interface | QOM.PrimaryKey
Deprecated
as a consequence of
Constraint being deprecated.
|
| public static interface | QOM.Product
Deprecated
as a consequence of The AggregateFunction being deprecated.
PRODUCT function.
|
| public static interface | |
| public static interface | |
| public static interface | |
| public static interface | |
| public static interface | |
| public static enum | QOM.Quantifier
The |
| public static interface | |
| public static interface | |
| public static interface | QOM.Rank
Deprecated
as a consequence of
QOM.WindowFunction being deprecated.
|
| public static interface | QOM.RatioToReport
Deprecated
as a consequence of
AggregateFunction being deprecated.
|
| public static interface | QOM.RegexpLike
Deprecated
as a consequence of
Condition being deprecated.
|
| public static interface | QOM.RegrAvgX
Deprecated
as a consequence of The AggregateFunction being deprecated.
REGR AVGX function.
|
| public static interface | QOM.RegrAvgY
Deprecated
as a consequence of The AggregateFunction being deprecated.
REGR AVGY function.
|
| public static interface | QOM.RegrCount
Deprecated
as a consequence of The AggregateFunction being deprecated.
REGR COUNT function.
|
| public static interface | QOM.RegrIntercept
Deprecated
as a consequence of The AggregateFunction being deprecated.
REGR INTERCEPT function.
|
| public static interface | |
| public static interface | QOM.RegrSlope
Deprecated
as a consequence of The AggregateFunction being deprecated.
REGR SLOPE function.
|
| public static interface | QOM.RegrSxx
Deprecated
as a consequence of The AggregateFunction being deprecated.
REGR SXX function.
|
| public static interface | QOM.RegrSxy
Deprecated
as a consequence of The AggregateFunction being deprecated.
REGR SXY function.
|
| public static interface | QOM.RegrSyy
Deprecated
as a consequence of The AggregateFunction being deprecated.
REGR SYY function.
|
| public static interface | QOM.ReleaseSavepoint
The |
| public static interface | |
| public static interface | |
| public static enum | QOM.ResultOption
The |
| public static interface | |
| public static interface | QOM.Revoke
The |
| public static interface | |
| public static interface | |
| public static interface | QOM.Rollback
The |
| public static interface | |
| public static interface | |
| public static interface | |
| public static interface | |
| public static interface | |
| public static interface | |
| public static interface | QOM.RowIsNotNull
Deprecated
as a consequence of
Condition being deprecated.
|
| public static interface | QOM.RowIsNull
Deprecated
as a consequence of
Condition being deprecated.
|
| public static interface | |
| public static interface | |
| public static interface | |
| public static interface | QOM.RowNumber
Deprecated
as a consequence of
QOM.WindowFunction being deprecated.
|
| public static interface | QOM.RowOverlaps
Deprecated
as a consequence of
Condition being deprecated.
|
| public static interface | |
| public static interface | |
| public static interface | |
| public static interface | |
| public static interface | QOM.Savepoint
The |
| public static interface | |
| public static interface | QOM.SelectIsNotNull
Deprecated
as a consequence of
Condition being deprecated.
|
| public static interface | QOM.SelectIsNull
Deprecated
as a consequence of
Condition being deprecated.
|
| public static interface | QOM.SetCatalog
The |
| public static interface | QOM.SetCommand
The |
| public static interface | QOM.SetSchema
The |
| public static interface | |
| public static interface | |
| public static interface | |
| public static interface | |
| public static interface | QOM.SimilarToQuantified
Deprecated
as a consequence of The Condition being deprecated.
SIMILAR TO operator.
|
| public static interface | |
| public static interface | |
| public static interface | |
| public static interface | |
| public static interface | |
| public static interface | QOM.Square<T extends Number>
Deprecated
as a consequence of The Field being deprecated.
SQUARE function.
|
| public static interface | QOM.StartsWith<T>
Deprecated
as a consequence of The QOM.CompareCondition being deprecated.
STARTS WITH operator.
|
| public static interface | QOM.StartsWithIgnoreCase<T>
Deprecated
as a consequence of The QOM.CompareCondition being deprecated.
STARTS WITH IGNORE CASE operator.
|
| public static interface | QOM.StartTransaction
The |
| public static interface | QOM.StddevPop
Deprecated
as a consequence of The AggregateFunction being deprecated.
STDDEV POP function.
|
| public static interface | QOM.StddevSamp
Deprecated
as a consequence of The AggregateFunction being deprecated.
STDDEV SAMP function.
|
| public static interface | |
| public static interface | |
| public static interface | |
| public static interface | QOM.SubstringIndex
Deprecated
as a consequence of The Field being deprecated.
SUBSTRING INDEX function.
|
| public static interface | |
| public static interface | |
| public static interface | |
| public static enum | QOM.TableCommitAction
The |
| public static interface | QOM.TableEq<R extends Record>
Deprecated
as a consequence of The Condition being deprecated.
EQ operator.
|
| public static interface | QOM.TableNe<R extends Record>
Deprecated
as a consequence of The Condition being deprecated.
NE operator.
|
| public static interface | |
| public static interface | |
| public static interface | |
| public static interface | |
| public static interface | |
| public static interface | |
| public static interface | |
| public static interface | |
| public static interface | |
| public static interface | |
| public static interface | |
| public static interface | |
| public static interface | |
| public static interface | QOM.Tuple2<Q1 extends QueryPart, Q2 extends QueryPart>
A generic tuple of degree 2 for use in |
| pack-priv static interface | QOM.UCommutativeOperator<Q, R extends QOM.
A binary |
| pack-priv static interface | QOM.UConvertibleOperator<Q, R extends QOM.
A binary |
| pack-priv static interface | |
| pack-priv static interface | QOM.UEmptyCondition
Deprecated
as a consequence of
Condition being deprecated.
|
| pack-priv static interface | |
| pack-priv static interface | |
| pack-priv static interface | |
| pack-priv static interface | |
| public static interface | |
| public static interface | QOM.UniqueKey
Deprecated
as a consequence of
Constraint being deprecated.
|
| public static interface | |
| public static interface | |
| public static interface | QOM.UnmodifiableMap<K extends QueryPart, V extends QueryPart>
|
| pack-priv static interface | QOM.UNotYetImplemented
Deprecated
for removal. - [#12425] - 3.16.0 - Missing implementations should be added
as soon as possible!
A marker interface for QueryPart implementations whose
QueryPart semantics has not yet been implemented.
|
| pack-priv static interface | QOM.UOpaque
A marker interface for |
| pack-priv static interface | |
| pack-priv static interface | |
| pack-priv static interface | |
| pack-priv static interface | |
| pack-priv static interface | |
| pack-priv static interface | |
| public static interface | |
| public static interface | |
| public static interface | |
| pack-priv static interface | |
| pack-priv static interface | QOM.UReturnsNullOnNullInput
A marker interface for |
| pack-priv static interface | QOM.UTransient
A marker interface for |
| public static interface | |
| public static interface | |
| public static interface | |
| public static interface | QOM.VarSamp
Deprecated
as a consequence of The AggregateFunction being deprecated.
VAR SAMP function.
|
| public static interface | QOM.WidthBucket<T extends Number>
Deprecated
as a consequence of The Field being deprecated.
WIDTH BUCKET function.
|
| public static interface | |
| public static interface | |
| public static interface | QOM.WithOrdinalityTable<R extends Record>
A collection derived table or table valued function with a
|
| public static enum | QOM.WithOrWithoutData
The |
| public static interface | QOM.XMLAgg
Deprecated
as a consequence of
AggregateFunction being deprecated.
|
| public static interface | |
| public static interface | |
| public static interface | QOM.XMLElement
Deprecated
as a consequence of
Field being deprecated.
|
| public static interface | QOM.XMLExists
Deprecated
as a consequence of
Condition being deprecated.
|
| public static interface | |
| public static interface | QOM.XMLParse
Deprecated
as a consequence of
Field being deprecated.
|
| public static enum | QOM.XMLPassingMechanism
The |
| public static interface | |
| public static interface | QOM.XMLQuery
Deprecated
as a consequence of
Field being deprecated.
|
| public static interface | QOM.XMLSerialize<T>
Deprecated
as a consequence of The Field being deprecated.
XMLSERIALIZE function.
|
| public static interface |
| Access | Constructor and Description |
|---|---|
| public |
| Modifier and Type | Method and Description |
|---|---|
| pack-priv static final <Q extends QueryPart> boolean | |
| pack-priv static final <Q extends QueryPart> boolean | |
| public static final <Q1 extends QueryPart, Q2 extends QueryPart> QOM. | |
| public static final <Q extends QueryPart> QOM. | |
| public static final <Q extends QueryPart> QOM. | |
| public static final <Q extends QueryPart> QOM. | |
| public static final <K extends QueryPart, V extends QueryPart> QOM. |