Top Description Inners Constructors Methods
org.jooq.impl

public final Class QOM

extends Object
Class Inheritance
Annotations
@Experimental
Static Imports
java.util.Arrays.asList, .Collections.unmodifiableCollection, .Collections.unmodifiableList, .Collections.unmodifiableMap, org.jooq.impl.DSL.keyword

A draft of the new query object model API.

This API is EXPERIMENTAL. Use at your own risk.

Purpose

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.

Design

In order to avoid conflicts between the model API and the DSL API, all model API in this class follows these naming conventions:

Limitations

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:

Mutability

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.

Notes

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.

Author
Lukas Eder

Nested and Inner Type Summary

Modifier and TypeClass and Description
public static interface
QOM.Abs<T extends Number>

Deprecated as a consequence of Field being deprecated.
The ABS function.
public static interface
QOM.Acos

Deprecated as a consequence of Field being deprecated.
The ACOS function.
public static interface
QOM.Acosh

Deprecated as a consequence of Field being deprecated.
The ACOSH function.
public static interface
QOM.Acoth

Deprecated as a consequence of Field being deprecated.
The ACOTH function.
public static interface
QOM.Add<T>

Deprecated as a consequence of Field being deprecated.
The ADD operator.
public static interface
QOM.Aliasable<Q extends QueryPart>

A QueryPart that may associate an $alias() with the $aliased() part.

public static interface
QOM.AlterDatabase

The ALTER DATABASE statement.

public static interface
QOM.AlterDomain<T>

The ALTER DOMAIN statement.

public static interface
QOM.AlterIndex

The ALTER INDEX statement.

public static interface
QOM.AlterSchema

The ALTER SCHEMA statement.

public static interface
QOM.AlterSequence<T extends Number>

The ALTER SEQUENCE statement.

public static interface
QOM.AlterType

The ALTER TYPE statement.

public static interface
QOM.AlterView

The ALTER VIEW statement.

public static interface
QOM.And

Deprecated as a consequence of QOM.CombinedCondition being deprecated.
The AND operator.
public static interface
QOM.AnyValue<T>

Deprecated as a consequence of AggregateFunction being deprecated.
The ANY VALUE function.
public static interface
QOM.Array<T>

Deprecated as a consequence of Field being deprecated.
public static interface
QOM.ArrayAgg<T>

Deprecated as a consequence of AggregateFunction being deprecated.
public static interface
QOM.ArrayAppend<T>

Deprecated as a consequence of Field being deprecated.
The ARRAY APPEND function.
public static interface
QOM.ArrayConcat<T>

Deprecated as a consequence of Field being deprecated.
The ARRAY CONCAT function.
public static interface
QOM.ArrayGet<T>

Deprecated as a consequence of Field being deprecated.
The ARRAY GET function.
public static interface
QOM.ArrayOverlap<T>

Deprecated as a consequence of Condition being deprecated.
The ARRAY OVERLAP function.
public static interface
QOM.ArrayPrepend<T>

Deprecated as a consequence of Field being deprecated.
The ARRAY PREPEND function.
public static interface
QOM.ArrayQuery<T>

Deprecated as a consequence of Field being deprecated.
public static interface
QOM.ArrayRemove<T>

Deprecated as a consequence of Field being deprecated.
The ARRAY REMOVE function.
public static interface
QOM.ArrayReplace<T>

Deprecated as a consequence of Field being deprecated.
The ARRAY REPLACE function.
public static interface
QOM.Ascii

Deprecated as a consequence of Field being deprecated.
The ASCII function.
public static interface
QOM.Asin

Deprecated as a consequence of Field being deprecated.
The ASIN function.
public static interface
QOM.Asinh

Deprecated as a consequence of Field being deprecated.
The ASINH function.
public static interface
QOM.Atan

Deprecated as a consequence of Field being deprecated.
The ATAN function.
public static interface
QOM.Atan2

Deprecated as a consequence of Field being deprecated.
The ATAN2 function.
public static interface
QOM.Atanh

Deprecated as a consequence of Field being deprecated.
The ATANH function.
public static interface
QOM.Avg

Deprecated as a consequence of AggregateFunction being deprecated.
The AVG function.
public static interface
QOM.Between<T>

Deprecated as a consequence of Condition being deprecated.
The BETWEEN predicate.
public static interface
QOM.BitAnd<T extends Number>

Deprecated as a consequence of Field being deprecated.
The BIT AND operator.
public static interface
QOM.BitAndAgg<T extends Number>

Deprecated as a consequence of AggregateFunction being deprecated.
The BIT AND AGG function.
public static interface
QOM.BitCount

Deprecated as a consequence of Field being deprecated.
The BIT COUNT function.
public static interface
QOM.BitGet<T extends Number>

Deprecated as a consequence of Field being deprecated.
The BIT GET function.
public static interface
QOM.BitLength

Deprecated as a consequence of Field being deprecated.
The BIT LENGTH function.
public static interface
QOM.BitNand<T extends Number>

Deprecated as a consequence of Field being deprecated.
The BIT NAND operator.
public static interface
QOM.BitNandAgg<T extends Number>

Deprecated as a consequence of AggregateFunction being deprecated.
The BIT NAND AGG function.
public static interface
QOM.BitNor<T extends Number>

Deprecated as a consequence of Field being deprecated.
The BIT NOR operator.
public static interface
QOM.BitNorAgg<T extends Number>

Deprecated as a consequence of AggregateFunction being deprecated.
The BIT NOR AGG function.
public static interface
QOM.BitNot<T extends Number>

Deprecated as a consequence of Field being deprecated.
The BIT NOT operator.
public static interface
QOM.BitOr<T extends Number>

Deprecated as a consequence of Field being deprecated.
The BIT OR operator.
public static interface
QOM.BitOrAgg<T extends Number>

Deprecated as a consequence of AggregateFunction being deprecated.
The BIT OR AGG function.
public static interface
QOM.BitSet<T extends Number>

Deprecated as a consequence of Field being deprecated.
The BIT SET function.
public static interface
QOM.BitXNor<T extends Number>

Deprecated as a consequence of Field being deprecated.
The BIT X NOR operator.
public static interface
QOM.BitXNorAgg<T extends Number>

Deprecated as a consequence of AggregateFunction being deprecated.
The BIT X NOR AGG function.
public static interface
QOM.BitXor<T extends Number>

Deprecated as a consequence of Field being deprecated.
The BIT XOR operator.
public static interface
QOM.BitXorAgg<T extends Number>

Deprecated as a consequence of AggregateFunction being deprecated.
The BIT XOR AGG function.
public static interface
QOM.BoolAnd

Deprecated as a consequence of AggregateFunction being deprecated.
The BOOL AND function.
public static interface
QOM.BoolOr

Deprecated as a consequence of AggregateFunction being deprecated.
The BOOL OR function.
public static interface
QOM.Cardinality

Deprecated as a consequence of Field being deprecated.
The CARDINALITY function.
public static enum
QOM.Cascade

The Cascade type.

public static interface
QOM.CaseSearched<T>

Deprecated as a consequence of Field being deprecated.
public static interface
QOM.CaseSimple<V, T>

Deprecated as a consequence of Field being deprecated.
public static interface
QOM.Cast<T>

Deprecated as a consequence of Field being deprecated.
public static interface
QOM.Ceil<T extends Number>

Deprecated as a consequence of Field being deprecated.
The CEIL function.
public static interface
QOM.CharLength

Deprecated as a consequence of Field being deprecated.
The CHAR LENGTH function.
public static interface
QOM.Check

Deprecated as a consequence of Constraint being deprecated.
public static interface
QOM.Choose<T>

Deprecated as a consequence of Field being deprecated.
public static interface
QOM.Chr

Deprecated as a consequence of Field being deprecated.
The CHR function.
public static interface
QOM.Coalesce<T>

Deprecated as a consequence of Field being deprecated.
public static interface
QOM.Coerce<T>

Deprecated as a consequence of Field being deprecated.
public static interface
QOM.Collated

Deprecated as a consequence of Field being deprecated.
public static interface
QOM.CombinedCondition<R extends QOM.CombinedCondition<R>>

Deprecated as a consequence of Condition being deprecated.
A Condition consisting of two Condition operands and a binary logic Operator.
public static interface
QOM.CommentOn

The COMMENT ON TABLE statement.

public static interface
QOM.Commit

The COMMIT statement.

public static interface
QOM.CompareCondition<T, R extends QOM.CompareCondition<T, R>>

Deprecated as a consequence of Condition being deprecated.
A 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
QOM.ConditionAsField

Deprecated as a consequence of Field being deprecated.
The FIELD function.
public static interface
QOM.Contains<T>

Deprecated as a consequence of QOM.CompareCondition being deprecated.
The CONTAINS operator.
public static interface
QOM.ContainsIgnoreCase<T>

Deprecated as a consequence of QOM.CompareCondition being deprecated.
The CONTAINS IGNORE CASE operator.
public static interface
QOM.Convert<T>

Deprecated as a consequence of Field being deprecated.
public static interface
QOM.Corr

Deprecated as a consequence of AggregateFunction being deprecated.
The CORR function.
public static interface
QOM.Cos

Deprecated as a consequence of Field being deprecated.
The COS function.
public static interface
QOM.Cosh

Deprecated as a consequence of Field being deprecated.
The COSH function.
public static interface
QOM.Cot

Deprecated as a consequence of Field being deprecated.
The COT function.
public static interface
QOM.Coth

Deprecated as a consequence of Field being deprecated.
The COTH function.
public static interface
QOM.Count

Deprecated as a consequence of AggregateFunction being deprecated.
The COUNT function.
public static interface
QOM.CountTable

Deprecated as a consequence of AggregateFunction being deprecated.
public static interface
QOM.CovarPop

Deprecated as a consequence of AggregateFunction being deprecated.
The COVAR POP function.
public static interface
QOM.CovarSamp

Deprecated as a consequence of AggregateFunction being deprecated.
The COVAR SAMP function.
public static interface
QOM.CreateDatabase

The CREATE DATABASE statement.

public static interface
QOM.CreateDomain<T>

The CREATE DOMAIN statement.

public static interface
QOM.CreateIndex

The CREATE INDEX statement.

public static interface
QOM.CreateSchema

The CREATE SCHEMA statement.

public static interface
QOM.CreateSequence

The CREATE SEQUENCE statement.

public static interface
QOM.CreateTable

The CREATE TABLE statement.

public static interface
QOM.CreateType

The CREATE TYPE statement.

public static interface
QOM.CreateView<R extends Record>

The CREATE VIEW statement.

public static interface
public static interface
QOM.CrossJoin<R extends Record>

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 Field being deprecated.
The CURRENT CATALOG function.
public static interface
QOM.CurrentDate<T>

Deprecated as a consequence of Field being deprecated.
public static interface
QOM.CurrentSchema

Deprecated as a consequence of Field being deprecated.
The CURRENT SCHEMA function.
public static interface
QOM.CurrentTime<T>

Deprecated as a consequence of Field being deprecated.
public static interface
QOM.CurrentTimestamp<T>

Deprecated as a consequence of Field being deprecated.
public static interface
QOM.CurrentUser

Deprecated as a consequence of Field being deprecated.
The CURRENT USER function.
public static enum
QOM.CycleOption

The CycleOption type.

public static interface
public static interface
QOM.DateAdd<T>

Deprecated as a consequence of Field being deprecated.
The DATE ADD function.
public static interface
QOM.Decode<V, T>

Deprecated as a consequence of Field being deprecated.
public static interface
QOM.Default<T>

Deprecated as a consequence of Field being deprecated.
public static interface
QOM.Degrees

Deprecated as a consequence of Field being deprecated.
The DEGREES function.
public static interface
QOM.Delete<R extends Record>

The DELETE statement.

public static interface
QOM.DeleteReturning<R extends Record>

An DELETE statement with a RETURNING clause.

public static interface
QOM.DenseRank

Deprecated as a consequence of QOM.WindowFunction being deprecated.
public static interface
public static interface
QOM.Digits

Deprecated as a consequence of Field being deprecated.
The DIGITS function.
public static interface
QOM.Div<T>

Deprecated as a consequence of Field being deprecated.
The DIV operator.
public static enum
QOM.DocumentOrContent

The DocumentOrContent type.

public static interface
QOM.DropDatabase

The DROP DATABASE statement.

public static interface
QOM.DropDomain

The DROP DOMAIN statement.

public static interface
QOM.DropIndex

The DROP INDEX statement.

public static interface
QOM.DropSchema

The DROP SCHEMA statement.

public static interface
QOM.DropSequence

The DROP SEQUENCE statement.

public static interface
QOM.DropTable

The DROP TABLE statement.

public static interface
QOM.DropType

The DROP TYPE statement.

public static interface
QOM.DropView

The DROP VIEW statement.

public static interface
public static interface
public static interface
QOM.EndsWith<T>

Deprecated as a consequence of QOM.CompareCondition being deprecated.
The ENDS WITH operator.
public static interface
QOM.EndsWithIgnoreCase<T>

Deprecated as a consequence of QOM.CompareCondition being deprecated.
The ENDS WITH IGNORE CASE operator.
public static interface
QOM.Eq<T>

Deprecated as a consequence of QOM.CompareCondition being deprecated.
The EQ operator.
public static interface
QOM.EqQuantified<T>

Deprecated as a consequence of Condition being deprecated.
The EQ operator.
public static interface
QOM.Euler

Deprecated as a consequence of Field being deprecated.
The E function.
public static interface
QOM.Excluded<T>

Deprecated as a consequence of Field being deprecated.
The EXCLUDED function.
public static interface
QOM.Exists

Deprecated as a consequence of Condition being deprecated.
The EXISTS function.
public static interface
QOM.Exp

Deprecated as a consequence of Field being deprecated.
The EXP function.
public static interface
QOM.Extract

Deprecated as a consequence of Field being deprecated.
public static interface
QOM.False

Deprecated as a consequence of Condition being deprecated.
A Condition that is always FALSE.
public static interface
QOM.FieldAlias<T>

Deprecated as a consequence of Field being deprecated.
public static interface
QOM.FieldCondition

Deprecated as a consequence of Condition being deprecated.
The CONDITION function.
public static interface
QOM.FieldFunction<T>

Deprecated as a consequence of Field being deprecated.
public static interface
QOM.FirstValue<T>

Deprecated as a consequence of QOM.WindowFunction being deprecated.
public static interface
QOM.Floor<T extends Number>

Deprecated as a consequence of Field being deprecated.
The FLOOR function.
public static interface
QOM.ForeignKey

Deprecated as a consequence of Constraint being deprecated.
public static enum
QOM.FrameExclude

The FrameExclude type.

public static enum
QOM.FrameUnits

The FrameUnits type.

public static enum
QOM.FromFirstOrLast

The FromFirstOrLast type.

public static interface
QOM.FullJoin<R extends Record>

public static interface
QOM.Function<T>

Deprecated as a consequence of Field being deprecated.
public static interface
QOM.Ge<T>

Deprecated as a consequence of QOM.CompareCondition being deprecated.
The GE operator.
public static interface
public static enum
QOM.GenerationLocation

The GenerationLocation type.

public static enum
QOM.GenerationOption

The GenerationOption type.

public static interface
QOM.GeQuantified<T>

Deprecated as a consequence of Condition being deprecated.
The GE operator.
public static interface
QOM.Grant

The GRANT statement.

public static interface
QOM.Greatest<T>

Deprecated as a consequence of Field being deprecated.
public static interface
public static interface
QOM.Gt<T>

Deprecated as a consequence of QOM.CompareCondition being deprecated.
The GT operator.
public static interface
QOM.GtQuantified<T>

Deprecated as a consequence of Condition being deprecated.
The GT operator.
public static interface
QOM.HintedTable<R extends Record>

A table with a MySQL style index access hint.

public static enum
QOM.IdentityRestartOption

The IdentityRestartOption type.

public static interface
QOM.Iif<T>

Deprecated as a consequence of Field being deprecated.
public static interface
QOM.In<T>

Deprecated as a consequence of Condition being deprecated.
The IN operator.
public static interface
QOM.InList<T>

Deprecated as a consequence of Condition being deprecated.
The IN predicate accepting a list of values.
public static interface
QOM.Insert<R extends Record>

The INSERT statement.

public static interface
QOM.InsertReturning<R extends Record>

An INSERT statement with a RETURNING clause.

public static interface
QOM.IsDistinctFrom<T>

Deprecated as a consequence of QOM.CompareCondition being deprecated.
The IS DISTINCT FROM operator.
public static interface
QOM.IsDocument

Deprecated as a consequence of Condition being deprecated.
The IS DOCUMENT operator.
public static interface
QOM.IsJson

Deprecated as a consequence of Condition being deprecated.
The IS JSON operator.
public static interface
QOM.IsNotDistinctFrom<T>

Deprecated as a consequence of QOM.CompareCondition being deprecated.
The IS NOT DISTINCT FROM operator.
public static interface
QOM.IsNotDocument

Deprecated as a consequence of Condition being deprecated.
The IS NOT DOCUMENT operator.
public static interface
QOM.IsNotJson

Deprecated as a consequence of Condition being deprecated.
The IS NOT JSON operator.
public static interface
QOM.IsNotNull

Deprecated as a consequence of Condition being deprecated.
The IS NOT NULL operator.
public static interface
QOM.IsNull

Deprecated as a consequence of Condition being deprecated.
The IS NULL operator.
public static interface
QOM.Join<R extends Record>

public static interface
QOM.JoinTable<R extends Record, J extends QOM.JoinTable<R, J>>

public static interface
QOM.JSONArray<T>

Deprecated as a consequence of Field being deprecated.
The JSON ARRAY function.
public static interface
QOM.JSONArrayAgg<J>

Deprecated as a consequence of AggregateFunction being deprecated.
public static interface
QOM.JSONBGetAttribute

Deprecated as a consequence of Field being deprecated.
The JSONB GET ATTRIBUTE function.
public static interface
QOM.JSONBGetAttributeAsText

Deprecated as a consequence of Field being deprecated.
The JSONB GET ATTRIBUTE AS TEXT function.
public static interface
QOM.JSONBGetElement

Deprecated as a consequence of Field being deprecated.
The JSONB GET ELEMENT function.
public static interface
QOM.JSONBGetElementAsText

Deprecated as a consequence of Field being deprecated.
The JSONB GET ELEMENT AS TEXT function.
public static interface
QOM.JSONBInsert

Deprecated as a consequence of Field being deprecated.
The JSONB INSERT function.
public static interface
QOM.JSONBKeys

Deprecated as a consequence of Field being deprecated.
The JSONB KEYS function.
public static interface
QOM.JSONBRemove

Deprecated as a consequence of Field being deprecated.
The JSONB REMOVE function.
public static interface
QOM.JSONBReplace

Deprecated as a consequence of Field being deprecated.
The JSONB REPLACE function.
public static interface
QOM.JSONBSet

Deprecated as a consequence of Field being deprecated.
The JSONB SET function.
public static interface
QOM.JSONGetAttribute

Deprecated as a consequence of Field being deprecated.
The JSON GET ATTRIBUTE function.
public static interface
QOM.JSONGetAttributeAsText

Deprecated as a consequence of Field being deprecated.
The JSON GET ATTRIBUTE AS TEXT function.
public static interface
QOM.JSONGetElement

Deprecated as a consequence of Field being deprecated.
The JSON GET ELEMENT function.
public static interface
QOM.JSONGetElementAsText

Deprecated as a consequence of Field being deprecated.
The JSON GET ELEMENT AS TEXT function.
public static interface
QOM.JSONInsert

Deprecated as a consequence of Field being deprecated.
The JSON INSERT function.
public static interface
QOM.JSONKeys

Deprecated as a consequence of Field being deprecated.
The JSON KEYS function.
public static interface
QOM.JSONObject<T>

Deprecated as a consequence of Field being deprecated.
The JSON OBJECT function.
public static interface
QOM.JSONObjectAgg<J>

Deprecated as a consequence of AggregateFunction being deprecated.
public static enum
QOM.JSONOnNull

The JSONOnNull type.

public static interface
QOM.JSONRemove

Deprecated as a consequence of Field being deprecated.
The JSON REMOVE function.
public static interface
QOM.JSONReplace

Deprecated as a consequence of Field being deprecated.
The JSON REPLACE function.
public static interface
QOM.JSONSet

Deprecated as a consequence of Field being deprecated.
The JSON SET function.
public static interface
QOM.Lag<T>

Deprecated as a consequence of QOM.WindowFunction being deprecated.
public static interface
QOM.LastValue<T>

Deprecated as a consequence of QOM.WindowFunction being deprecated.
public static interface
QOM.Lateral<R extends Record>

public static interface
QOM.Le<T>

Deprecated as a consequence of QOM.CompareCondition being deprecated.
The LE operator.
public static interface
QOM.Lead<T>

Deprecated as a consequence of QOM.WindowFunction being deprecated.
public static interface
QOM.Least<T>

Deprecated as a consequence of Field being deprecated.
public static interface
QOM.Left

Deprecated as a consequence of Field being deprecated.
The LEFT function.
public static interface
public static interface
QOM.LeftJoin<R extends Record>

public static interface
public static interface
QOM.LeQuantified<T>

Deprecated as a consequence of Condition being deprecated.
The LE operator.
public static interface
QOM.Like

Deprecated as a consequence of Condition being deprecated.
The LIKE operator.
public static interface
QOM.LikeIgnoreCase

Deprecated as a consequence of Condition being deprecated.
The LIKE IGNORE CASE operator.
public static interface
QOM.LikeQuantified

Deprecated as a consequence of Condition being deprecated.
The LIKE operator.
public static interface
QOM.Ln

Deprecated as a consequence of Field being deprecated.
The LN function.
public static interface
QOM.Log

Deprecated as a consequence of Field being deprecated.
The LOG function.
public static interface
QOM.Log10

Deprecated as a consequence of Field being deprecated.
The LOG10 function.
public static interface
QOM.Lower

Deprecated as a consequence of Field being deprecated.
The LOWER function.
public static interface
QOM.Lpad

Deprecated as a consequence of Field being deprecated.
The LPAD function.
public static interface
QOM.Lt<T>

Deprecated as a consequence of QOM.CompareCondition being deprecated.
The LT operator.
public static interface
QOM.LtQuantified<T>

Deprecated as a consequence of Condition being deprecated.
The LT operator.
public static interface
QOM.Ltrim

Deprecated as a consequence of Field being deprecated.
The LTRIM function.
public static enum
QOM.Materialized

The Materialized type.

public static interface
QOM.Max<T>

Deprecated as a consequence of AggregateFunction being deprecated.
The MAX function.
public static interface
QOM.Md5

Deprecated as a consequence of Field being deprecated.
The MD5 function.
public static interface
QOM.Median

Deprecated as a consequence of AggregateFunction being deprecated.
The MEDIAN function.
public static interface
QOM.Min<T>

Deprecated as a consequence of AggregateFunction being deprecated.
The MIN function.
public static interface
QOM.Mod<T extends Number>

Deprecated as a consequence of Field being deprecated.
The MOD operator.
public static interface
QOM.Mode<T>

Deprecated as a consequence of AggregateFunction being deprecated.
public static interface
QOM.Mul<T>

Deprecated as a consequence of Field being deprecated.
The MUL operator.
public static interface
QOM.Multiset<R extends Record>

Deprecated as a consequence of Field being deprecated.
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
QOM.Ne<T>

Deprecated as a consequence of QOM.CompareCondition being deprecated.
The NE operator.
public static interface
QOM.Neg<T>

Deprecated as a consequence of Field being deprecated.
public static interface
QOM.NeQuantified<T>

Deprecated as a consequence of Condition being deprecated.
The NE operator.
public static interface
QOM.Not

Deprecated as a consequence of Condition being deprecated.
The NOT operator.
public static interface
QOM.NotField

Deprecated as a consequence of Field being deprecated.
The NOT operator.
public static interface
QOM.NotIn<T>

Deprecated as a consequence of Condition being deprecated.
The NOT IN operator.
public static interface
QOM.NotInList<T>

Deprecated as a consequence of Condition being deprecated.
The NOT IN predicate accepting a list of values.
public static interface
QOM.NotLike

Deprecated as a consequence of Condition being deprecated.
The NOT LIKE operator.
public static interface
QOM.NotLikeIgnoreCase

Deprecated as a consequence of Condition being deprecated.
The NOT LIKE IGNORE CASE operator.
public static interface
QOM.NotLikeQuantified

Deprecated as a consequence of Condition being deprecated.
The NOT LIKE operator.
public static interface
QOM.NotSimilarTo

Deprecated as a consequence of Condition being deprecated.
The NOT SIMILAR TO operator.
public static interface
QOM.NotSimilarToQuantified

Deprecated as a consequence of Condition being deprecated.
The 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
QOM.NthValue<T>

Deprecated as a consequence of QOM.WindowFunction being deprecated.
public static interface
QOM.Ntile

Deprecated as a consequence of QOM.WindowFunction being deprecated.
public static interface
QOM.Null

Deprecated as a consequence of Condition being deprecated.
A Condition that is always NULL.
public static interface
QOM.Nullif<T>

Deprecated as a consequence of Field being deprecated.
The NULLIF function.
public static enum
QOM.NullOrdering

The NullOrdering type.

public static interface
public static enum
QOM.NullTreatment

The NullTreatment type.

public static interface
QOM.Nvl<T>

Deprecated as a consequence of Field being deprecated.
The NVL function.
public static interface
QOM.Nvl2<T>

Deprecated as a consequence of Field being deprecated.
public static interface
QOM.OctetLength

Deprecated as a consequence of Field being deprecated.
The OCTET LENGTH function.
public static interface
QOM.Or

Deprecated as a consequence of QOM.CombinedCondition being deprecated.
The OR operator.
public static interface
public static interface
QOM.Overlay

Deprecated as a consequence of Field being deprecated.
The OVERLAY function.
public static interface
QOM.PercentRank

Deprecated as a consequence of QOM.WindowFunction being deprecated.
public static interface
QOM.Pi

Deprecated as a consequence of Field being deprecated.
The PI function.
public static interface
QOM.Position

Deprecated as a consequence of Field being deprecated.
The POSITION function.
public static interface
QOM.Power

Deprecated as a consequence of Field being deprecated.
The POWER operator.
public static interface
QOM.PrimaryKey

Deprecated as a consequence of Constraint being deprecated.
public static interface
QOM.Product

Deprecated as a consequence of AggregateFunction being deprecated.
The PRODUCT function.
public static interface
QOM.QualifiedJoin<R extends Record, J extends QOM.QualifiedJoin<R, J>>

public static interface
QOM.QualifiedRowid

Deprecated as a consequence of Field being deprecated.
The ROWID operator.
public static interface
public static interface
public static interface
public static enum
QOM.Quantifier

The Quantifier type.

public static interface
QOM.Radians

Deprecated as a consequence of Field being deprecated.
The RADIANS function.
public static interface
QOM.Rand

Deprecated as a consequence of Field being deprecated.
The RAND function.
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 AggregateFunction being deprecated.
The REGR AVGX function.
public static interface
QOM.RegrAvgY

Deprecated as a consequence of AggregateFunction being deprecated.
The REGR AVGY function.
public static interface
QOM.RegrCount

Deprecated as a consequence of AggregateFunction being deprecated.
The REGR COUNT function.
public static interface
QOM.RegrIntercept

Deprecated as a consequence of AggregateFunction being deprecated.
The REGR INTERCEPT function.
public static interface
QOM.RegrR2

Deprecated as a consequence of AggregateFunction being deprecated.
The REGR R2 function.
public static interface
QOM.RegrSlope

Deprecated as a consequence of AggregateFunction being deprecated.
The REGR SLOPE function.
public static interface
QOM.RegrSxx

Deprecated as a consequence of AggregateFunction being deprecated.
The REGR SXX function.
public static interface
QOM.RegrSxy

Deprecated as a consequence of AggregateFunction being deprecated.
The REGR SXY function.
public static interface
QOM.RegrSyy

Deprecated as a consequence of AggregateFunction being deprecated.
The REGR SYY function.
public static interface
QOM.ReleaseSavepoint

The RELEASE SAVEPOINT statement.

public static interface
QOM.Repeat

Deprecated as a consequence of Field being deprecated.
The REPEAT function.
public static interface
QOM.Replace

Deprecated as a consequence of Field being deprecated.
The REPLACE function.
public static enum
QOM.ResultOption

The ResultOption type.

public static interface
QOM.Reverse

Deprecated as a consequence of Field being deprecated.
The REVERSE function.
public static interface
QOM.Revoke

The REVOKE statement.

public static interface
QOM.Right

Deprecated as a consequence of Field being deprecated.
The RIGHT function.
public static interface
QOM.RightJoin<R extends Record>

public static interface
QOM.Rollback

The ROLLBACK statement.

public static interface
public static interface
QOM.Round<T extends Number>

Deprecated as a consequence of Field being deprecated.
The ROUND function.
public static interface
QOM.RowAsField<R extends Record>

Deprecated as a consequence of Field being deprecated.
public static interface
QOM.RowEq<T extends Row>

Deprecated as a consequence of Condition being deprecated.
The ROW EQ operator.
public static interface
QOM.RowGe<T extends Row>

Deprecated as a consequence of Condition being deprecated.
The ROW GE operator.
public static interface
QOM.RowGt<T extends Row>

Deprecated as a consequence of Condition being deprecated.
The ROW GT operator.
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
QOM.RowLe<T extends Row>

Deprecated as a consequence of Condition being deprecated.
The ROW LE operator.
public static interface
QOM.RowLt<T extends Row>

Deprecated as a consequence of Condition being deprecated.
The ROW LT operator.
public static interface
QOM.RowNe<T extends Row>

Deprecated as a consequence of Condition being deprecated.
The ROW NE operator.
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
QOM.Rpad

Deprecated as a consequence of Field being deprecated.
The RPAD function.
public static interface
QOM.Rtrim

Deprecated as a consequence of Field being deprecated.
The RTRIM function.
public static interface
QOM.Savepoint

The SAVEPOINT statement.

public static interface
QOM.ScalarSubquery<T>

Deprecated as a consequence of Field being deprecated.
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 SET CATALOG statement.

public static interface
QOM.SetCommand

The SET statement.

public static interface
QOM.SetSchema

The SET SCHEMA statement.

public static interface
QOM.Shl<T extends Number>

Deprecated as a consequence of Field being deprecated.
The SHL operator.
public static interface
QOM.Shr<T extends Number>

Deprecated as a consequence of Field being deprecated.
The SHR operator.
public static interface
QOM.Sign

Deprecated as a consequence of Field being deprecated.
The SIGN function.
public static interface
QOM.SimilarTo

Deprecated as a consequence of Condition being deprecated.
The SIMILAR TO operator.
public static interface
QOM.SimilarToQuantified

Deprecated as a consequence of Condition being deprecated.
The SIMILAR TO operator.
public static interface
QOM.Sin

Deprecated as a consequence of Field being deprecated.
The SIN function.
public static interface
QOM.Sinh

Deprecated as a consequence of Field being deprecated.
The SINH function.
public static interface
QOM.Space

Deprecated as a consequence of Field being deprecated.
The SPACE function.
public static interface
QOM.SplitPart

Deprecated as a consequence of Field being deprecated.
The SPLIT PART function.
public static interface
QOM.Sqrt

Deprecated as a consequence of Field being deprecated.
The SQRT function.
public static interface
QOM.Square<T extends Number>

Deprecated as a consequence of Field being deprecated.
The SQUARE function.
public static interface
QOM.StartsWith<T>

Deprecated as a consequence of QOM.CompareCondition being deprecated.
The STARTS WITH operator.
public static interface
QOM.StartsWithIgnoreCase<T>

Deprecated as a consequence of QOM.CompareCondition being deprecated.
The STARTS WITH IGNORE CASE operator.
public static interface
QOM.StartTransaction

The START TRANSACTION statement.

public static interface
QOM.StddevPop

Deprecated as a consequence of AggregateFunction being deprecated.
The STDDEV POP function.
public static interface
QOM.StddevSamp

Deprecated as a consequence of AggregateFunction being deprecated.
The STDDEV SAMP function.
public static interface
public static interface
QOM.Sub<T>

Deprecated as a consequence of Field being deprecated.
The SUB operator.
public static interface
QOM.Substring

Deprecated as a consequence of Field being deprecated.
The SUBSTRING function.
public static interface
QOM.SubstringIndex

Deprecated as a consequence of Field being deprecated.
The SUBSTRING INDEX function.
public static interface
QOM.Sum

Deprecated as a consequence of AggregateFunction being deprecated.
The SUM function.
public static interface
public static interface
QOM.TableAsField<R extends Record>

Deprecated as a consequence of Field being deprecated.
public static enum
QOM.TableCommitAction

The TableCommitAction type.

public static interface
QOM.TableEq<R extends Record>

Deprecated as a consequence of Condition being deprecated.
The EQ operator.
public static interface
QOM.TableNe<R extends Record>

Deprecated as a consequence of Condition being deprecated.
The NE operator.
public static interface
QOM.Tan

Deprecated as a consequence of Field being deprecated.
The TAN function.
public static interface
QOM.Tanh

Deprecated as a consequence of Field being deprecated.
The TANH function.
public static interface
QOM.Tau

Deprecated as a consequence of Field being deprecated.
The TAU function.
public static interface
QOM.TimestampDiff<T>

Deprecated as a consequence of Field being deprecated.
public static interface
QOM.ToChar

Deprecated as a consequence of Field being deprecated.
The TO CHAR function.
public static interface
QOM.ToDate

Deprecated as a consequence of Field being deprecated.
The TO DATE function.
public static interface
QOM.ToHex

Deprecated as a consequence of Field being deprecated.
The TO HEX function.
public static interface
QOM.ToTimestamp

Deprecated as a consequence of Field being deprecated.
The TO TIMESTAMP function.
public static interface
QOM.Translate

Deprecated as a consequence of Field being deprecated.
The TRANSLATE function.
public static interface
QOM.Trim

Deprecated as a consequence of Field being deprecated.
The TRIM function.
public static interface
QOM.True

Deprecated as a consequence of Condition being deprecated.
A Condition that is always TRUE.
public static interface
QOM.Trunc<T extends Number>

Deprecated as a consequence of Field being deprecated.
The TRUNC function.
public static interface
QOM.Truncate<R extends Record>

The TRUNCATE statement.

public static interface
QOM.Tuple2<Q1 extends QueryPart, Q2 extends QueryPart>

A generic tuple of degree 2 for use in QOM types.

pack-priv static interface
QOM.UCommutativeOperator<Q, R extends QOM.UCommutativeOperator<Q, R>>

A binary UOperator2 whose operands can be swapped using $swap() without changing the operator's semantics.

pack-priv static interface
QOM.UConvertibleOperator<Q, R extends QOM.UConvertibleOperator<Q, R, C>, C extends QOM.UConvertibleOperator<Q, C, R>>

A binary UOperator2 whose operands can be swapped using $converse() producing the converse relation.

pack-priv static interface
pack-priv static interface
QOM.UEmptyCondition

Deprecated as a consequence of Condition being deprecated.
pack-priv static interface
QOM.UEmptyField<T>

Deprecated as a consequence of Field being deprecated.
pack-priv static interface
pack-priv static interface
pack-priv static interface
public static interface
QOM.Unique

Deprecated as a consequence of Condition being deprecated.
The UNIQUE function.
public static interface
QOM.UniqueKey

Deprecated as a consequence of Constraint being deprecated.
public static interface
QOM.UnmodifiableCollection<Q extends QueryPart>

An unmodifiable Collection of QueryPart elements.

public static interface
QOM.UnmodifiableList<Q extends QueryPart>

An unmodifiable List of QueryPart elements.

public static interface
QOM.UnmodifiableMap<K extends QueryPart, V extends QueryPart>

An unmodifiable Map of QueryPart keys and values.

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 QueryPart implementations that are mainly used to render SQL, but unlike UTransient parts, can also appear in user expression trees.

pack-priv static interface
pack-priv static interface
pack-priv static interface
QOM.UOperator1<Q1, R extends QOM.UOperator1<Q1, R>>

pack-priv static interface
QOM.UOperator2<Q1, Q2, R extends QOM.UOperator2<Q1, Q2, R>>

pack-priv static interface
QOM.UOperator3<Q1, Q2, Q3, R extends QOM.UOperator3<Q1, Q2, Q3, R>>

pack-priv static interface
QOM.UOperator4<Q1, Q2, Q3, Q4, R extends QOM.UOperator4<Q1, Q2, Q3, Q4, R>>

public static interface
QOM.Update<R extends Record>

The UPDATE statement.

public static interface
QOM.UpdateReturning<R extends Record>

An UPDATE statement with a RETURNING clause.

public static interface
QOM.Upper

Deprecated as a consequence of Field being deprecated.
The UPPER function.
pack-priv static interface
QOM.UProxy<Q extends QueryPart>

pack-priv static interface
QOM.UReturnsNullOnNullInput

A marker interface for QueryPart implementations that represent functions or operators who evaluate to NULL as soon as at least one argument is NULL.

pack-priv static interface
QOM.UTransient

A marker interface for QueryPart implementations that are used only to render SQL, i.e. they're transient to the expression tree and don't persist in client code.

public static interface
QOM.Uuid

Deprecated as a consequence of Field being deprecated.
The UUID function.
public static interface
QOM.Values<R extends Record>

public static interface
QOM.VarPop

Deprecated as a consequence of AggregateFunction being deprecated.
The VAR POP function.
public static interface
QOM.VarSamp

Deprecated as a consequence of AggregateFunction being deprecated.
The VAR SAMP function.
public static interface
QOM.WidthBucket<T extends Number>

Deprecated as a consequence of Field being deprecated.
The WIDTH BUCKET function.
public static interface
QOM.WindowFunction<T>

Deprecated as a consequence of Field being deprecated.
public static interface
QOM.With

A WITH clause of a Select, Insert, Update, or Delete statement.

public static interface
QOM.WithOrdinalityTable<R extends Record>

A collection derived table or table valued function with a WITH ORDINALITY clause.

public static enum
QOM.WithOrWithoutData

The WithOrWithoutData type.

public static interface
QOM.XMLAgg

Deprecated as a consequence of AggregateFunction being deprecated.
public static interface
QOM.XMLComment

Deprecated as a consequence of Field being deprecated.
The XMLCOMMENT function.
public static interface
QOM.XMLConcat

Deprecated as a consequence of Field being deprecated.
The XMLCONCAT function.
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
QOM.XMLForest

Deprecated as a consequence of Field being deprecated.
The XMLFOREST function.
public static interface
QOM.XMLParse

Deprecated as a consequence of Field being deprecated.
public static enum
QOM.XMLPassingMechanism

The XMLPassingMechanism type.

public static interface
QOM.XMLPi

Deprecated as a consequence of Field being deprecated.
The XMLPI function.
public static interface
QOM.XMLQuery

Deprecated as a consequence of Field being deprecated.
public static interface
QOM.XMLSerialize<T>

Deprecated as a consequence of Field being deprecated.
The XMLSERIALIZE function.
public static interface
QOM.Xor

Deprecated as a consequence of QOM.CombinedCondition being deprecated.
The XOR operator.

Constructor Summary

AccessConstructor and Description
public
QOM()

Method Summary

Modifier and TypeMethod and Description
pack-priv static final <Q extends QueryPart> boolean
pack-priv static final <Q extends QueryPart> boolean
commutativeCheck(QOM.UCommutativeOperator<Q, ?> op, BiPredicate<? super Q, ? super Q> f)

public static final <Q1 extends QueryPart, Q2 extends QueryPart> QOM.Tuple2<Q1, Q2>
tuple(Q1 q1, Q2 q2)

public static final <Q extends QueryPart> QOM.UnmodifiableList<Q>
unmodifiable(Q[] array)

Turn an array into an unmodifiable UnmodifiableList.

public static final <Q extends QueryPart> QOM.UnmodifiableList<Q>
unmodifiable(List<Q> list)

Turn a List into an unmodifiable UnmodifiableList.

public static final <Q extends QueryPart> QOM.UnmodifiableList<Q>
unmodifiable(Collection<Q> collection)

Turn a Collection into an unmodifiable UnmodifiableList.

public static final <K extends QueryPart, V extends QueryPart> QOM.UnmodifiableMap<K, V>
unmodifiable(Map<K, V> map)

Turn a Map into an unmodifiable UnmodifiableMap.

Inherited from java.lang.Object:
cloneequalsfinalizegetClasshashCodenotifynotifyAlltoStringwaitwaitwait