Module org.jooq
Package org.jooq.impl

Class QOM

java.lang.Object
org.jooq.impl.QOM

@Experimental public final class QOM extends Object
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(Replacer) as well as via per-querypart methods, such as for example QOM.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:

  • All public model API types are nested in the QOM class, whereas DSL API types are top level types in the org.jooq package.
  • All accessor methods and their corresponding "immutable setters" (returning a copy containing the modification) are named $property(), e.g. QOM.Substring.$startingPosition() and QOM.Substring.$startingPosition(Field).
  • All private model API utility types are named UXyz, e.g. QOM.UEmpty

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:

  • Not all QueryPart implementations have a corresponding public QueryPart type yet, but may just implement the API via a QOM.UEmpty or QOM.UNotYetImplemented subtype, and may not provide access to contents via accessor methods.
  • Some child elements of a 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.

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
  • Constructor Details

    • QOM

      public QOM()
  • Method Details

    • AlterDatabase

      public static final QOM.AlterDatabase AlterDatabase()
      The ALTER DATABASE statement.
    • AlterDatabase

      public static final QOM.AlterDatabase AlterDatabase(Catalog database, boolean ifExists, Catalog renameTo)
      The ALTER DATABASE statement.
    • AlterDomain

      public static final <T> QOM.AlterDomain<T> AlterDomain()
      The ALTER DOMAIN statement.
    • AlterDomain

      public static final <T> QOM.AlterDomain<T> AlterDomain(Domain<T> domain, boolean ifExists, Constraint addConstraint, Constraint dropConstraint, boolean dropConstraintIfExists, Domain<?> renameTo, Constraint renameConstraint, boolean renameConstraintIfExists, Field<T> setDefault, boolean dropDefault, boolean setNotNull, boolean dropNotNull, QOM.Cascade cascade, Constraint renameConstraintTo)
      The ALTER DOMAIN statement.
    • AlterIndex

      public static final QOM.AlterIndex AlterIndex()
      The ALTER INDEX statement.
    • AlterIndex

      public static final QOM.AlterIndex AlterIndex(Index index, boolean ifExists, Table<?> on, Index renameTo)
      The ALTER INDEX statement.
    • AlterSchema

      public static final QOM.AlterSchema AlterSchema()
      The ALTER SCHEMA statement.
    • AlterSchema

      public static final QOM.AlterSchema AlterSchema(Schema schema, boolean ifExists, Schema renameTo)
      The ALTER SCHEMA statement.
    • AlterSequence

      public static final <T extends Number> QOM.AlterSequence<T> AlterSequence()
      The ALTER SEQUENCE statement.
    • AlterSequence

      public static final <T extends Number> QOM.AlterSequence<T> AlterSequence(Sequence<T> sequence, boolean ifExists, Sequence<?> renameTo, boolean restart, Field<T> restartWith, Field<T> startWith, Field<T> incrementBy, Field<T> minvalue, boolean noMinvalue, Field<T> maxvalue, boolean noMaxvalue, QOM.CycleOption cycle, Field<T> cache, boolean noCache)
      The ALTER SEQUENCE statement.
    • AlterType

      public static final QOM.AlterType AlterType()
      The ALTER TYPE statement.
    • AlterType

      public static final QOM.AlterType AlterType(Name type, boolean ifExists, Name renameTo, Schema setSchema, Field<String> addValue, Field<String> renameValue, Field<String> renameValueTo)
      The ALTER TYPE statement.
    • AlterView

      public static final QOM.AlterView AlterView()
      The ALTER VIEW statement.
    • AlterView

      public static final QOM.AlterView AlterView(Table<?> view, Collection<? extends Field<?>> fields, boolean materialized, boolean ifExists, Comment comment, Table<?> renameTo, Select<?> as)
      The ALTER VIEW statement.
    • CommentOn

      public static final QOM.CommentOn CommentOn()
      The COMMENT ON TABLE statement.
    • CommentOn

      public static final QOM.CommentOn CommentOn(Table<?> table, boolean isView, boolean isMaterializedView, Field<?> field, Comment comment)
      The COMMENT ON TABLE statement.
    • CreateDatabase

      public static final QOM.CreateDatabase CreateDatabase()
      The CREATE DATABASE statement.
    • CreateDatabase

      public static final QOM.CreateDatabase CreateDatabase(Catalog database, boolean ifNotExists)
      The CREATE DATABASE statement.
    • CreateDomain

      public static final <T> QOM.CreateDomain<T> CreateDomain()
      The CREATE DOMAIN statement.
    • CreateDomain

      public static final <T> QOM.CreateDomain<T> CreateDomain(Domain<?> domain, boolean ifNotExists, DataType<T> dataType, Field<T> default_, Collection<? extends Constraint> constraints)
      The CREATE DOMAIN statement.
    • CreateFunction

      @Pro public static final QOM.CreateFunction CreateFunction()
      The CREATE FUNCTION statement.
    • CreateFunction

      @Pro public static final QOM.CreateFunction CreateFunction(Name function, boolean orReplace, Collection<? extends Parameter<?>> parameters, DataType<?> returns, Collection<? extends Field<?>> returnsTable, QOM.SQLDataAccess sqlDataAccess, QOM.NullCallClause returnsNullOnNullInput, QOM.Deterministic deterministic, Statement body)
      The CREATE FUNCTION statement.
    • CreateIndex

      public static final QOM.CreateIndex CreateIndex()
      The CREATE INDEX statement.
    • CreateIndex

      public static final QOM.CreateIndex CreateIndex(boolean unique, Index index, boolean ifNotExists, Table<?> table, Collection<? extends OrderField<?>> on, Collection<? extends Field<?>> include, Condition where, boolean excludeNullKeys)
      The CREATE INDEX statement.
    • CreateProcedure

      @Pro public static final QOM.CreateProcedure CreateProcedure()
      The CREATE PROCEDURE statement.
    • CreateProcedure

      @Pro public static final QOM.CreateProcedure CreateProcedure(Name procedure, boolean orReplace, Collection<? extends Parameter<?>> parameters, QOM.SQLDataAccess sqlDataAccess, Statement body)
      The CREATE PROCEDURE statement.
    • CreateTable

      public static final QOM.CreateTable CreateTable()
      The CREATE TABLE statement.
    • CreateTable

      public static final QOM.CreateTable CreateTable(Table<?> table, boolean temporary, boolean ifNotExists, Collection<? extends TableElement> tableElements, Select<?> select, QOM.WithOrWithoutData withData, QOM.TableCommitAction onCommit, Comment comment, SQL storage)
      The CREATE TABLE statement.
    • CreateView

      public static final <R extends Record> QOM.CreateView<R> CreateView()
      The CREATE VIEW statement.
    • CreateView

      public static final <R extends Record> QOM.CreateView<R> CreateView(Table<?> view, Collection<? extends Field<?>> fields, boolean orReplace, boolean materialized, boolean ifNotExists, ResultQuery<? extends R> query)
      The CREATE VIEW statement.
    • CreateTrigger

      @Pro public static final QOM.CreateTrigger CreateTrigger()
      The CREATE TRIGGER statement.
    • CreateTrigger

      @Pro public static final QOM.CreateTrigger CreateTrigger(Trigger trigger, boolean orReplace, boolean before, boolean after, boolean insteadOf, boolean insert, boolean update, boolean delete, Collection<? extends Field<?>> of, Table<?> on, Name referencingOldAs, Name referencingNewAs, boolean forEachRow, boolean forEachStatement, Condition when, Statement body)
      The CREATE TRIGGER statement.
    • CreateType

      public static final QOM.CreateType CreateType()
      The CREATE TYPE statement.
    • CreateType

      public static final QOM.CreateType CreateType(Type<?> type, boolean ifNotExists, Collection<? extends Field<String>> values, Collection<? extends Field<?>> attributes)
      The CREATE TYPE statement.
    • CreateSchema

      public static final QOM.CreateSchema CreateSchema()
      The CREATE SCHEMA statement.
    • CreateSchema

      public static final QOM.CreateSchema CreateSchema(Schema schema, boolean ifNotExists)
      The CREATE SCHEMA statement.
    • CreateSequence

      public static final <T extends Number> QOM.CreateSequence<T> CreateSequence()
      The CREATE SEQUENCE statement.
    • CreateSequence

      public static final <T extends Number> QOM.CreateSequence<T> CreateSequence(Sequence<?> sequence, boolean ifNotExists, DataType<T> dataType, Field<T> startWith, Field<T> incrementBy, Field<T> minvalue, boolean noMinvalue, Field<T> maxvalue, boolean noMaxvalue, QOM.CycleOption cycle, Field<T> cache, boolean noCache)
      The CREATE SEQUENCE statement.
    • DropDatabase

      public static final QOM.DropDatabase DropDatabase()
      The DROP DATABASE statement.
    • DropDatabase

      public static final QOM.DropDatabase DropDatabase(Catalog database, boolean ifExists)
      The DROP DATABASE statement.
    • DropDomain

      public static final QOM.DropDomain DropDomain()
      The DROP DOMAIN statement.
    • DropDomain

      public static final QOM.DropDomain DropDomain(Domain<?> domain, boolean ifExists, QOM.Cascade cascade)
      The DROP DOMAIN statement.
    • DropFunction

      @Pro public static final QOM.DropFunction DropFunction()
      The DROP FUNCTION statement.
    • DropFunction

      @Pro public static final QOM.DropFunction DropFunction(Name function, boolean ifExists)
      The DROP FUNCTION statement.
    • DropIndex

      public static final QOM.DropIndex DropIndex()
      The DROP INDEX statement.
    • DropIndex

      public static final QOM.DropIndex DropIndex(Index index, boolean ifExists, Table<?> on, QOM.Cascade cascade)
      The DROP INDEX statement.
    • DropProcedure

      @Pro public static final QOM.DropProcedure DropProcedure()
      The DROP PROCEDURE statement.
    • DropProcedure

      @Pro public static final QOM.DropProcedure DropProcedure(Name procedure, boolean ifExists)
      The DROP PROCEDURE statement.
    • DropSchema

      public static final QOM.DropSchema DropSchema()
      The DROP SCHEMA statement.
    • DropSchema

      public static final QOM.DropSchema DropSchema(Schema schema, boolean ifExists, QOM.Cascade cascade)
      The DROP SCHEMA statement.
    • DropSequence

      public static final QOM.DropSequence DropSequence()
      The DROP SEQUENCE statement.
    • DropSequence

      public static final QOM.DropSequence DropSequence(Sequence<?> sequence, boolean ifExists)
      The DROP SEQUENCE statement.
    • DropTable

      public static final QOM.DropTable DropTable()
      The DROP TABLE statement.
    • DropTable

      public static final QOM.DropTable DropTable(boolean temporary, Table<?> table, boolean ifExists, QOM.Cascade cascade)
      The DROP TABLE statement.
    • DropTrigger

      @Pro public static final QOM.DropTrigger DropTrigger()
      The DROP TRIGGER statement.
    • DropTrigger

      @Pro public static final QOM.DropTrigger DropTrigger(Trigger trigger, boolean ifExists, Table<?> on)
      The DROP TRIGGER statement.
    • DropType

      public static final QOM.DropType DropType()
      The DROP TYPE statement.
    • DropType

      public static final QOM.DropType DropType(Collection<? extends Type<?>> types, boolean ifExists, QOM.Cascade cascade)
      The DROP TYPE statement.
    • DropView

      public static final QOM.DropView DropView()
      The DROP VIEW statement.
    • DropView

      public static final QOM.DropView DropView(Table<?> view, boolean materialized, boolean ifExists)
      The DROP VIEW statement.
    • Grant

      public static final QOM.Grant Grant()
      The GRANT statement.
    • Grant

      public static final QOM.Grant Grant(Collection<? extends Privilege> privileges, Table<?> on, Role to, boolean toPublic, boolean withGrantOption)
      The GRANT statement.
    • Revoke

      public static final QOM.Revoke Revoke()
      The REVOKE statement.
    • Revoke

      public static final QOM.Revoke Revoke(Collection<? extends Privilege> privileges, boolean grantOptionFor, Table<?> on, Role from, boolean fromPublic)
      The REVOKE statement.
    • SetCommand

      public static final QOM.SetCommand SetCommand()
      The SET statement.

      Set a vendor specific session configuration to a new value.

    • SetCommand

      public static final QOM.SetCommand SetCommand(Name name, Param<?> value, boolean local)
      The SET statement.

      Set a vendor specific session configuration to a new value.

    • SetCatalog

      public static final QOM.SetCatalog SetCatalog()
      The SET CATALOG statement.

      Set the current catalog to a new value.

    • SetCatalog

      public static final QOM.SetCatalog SetCatalog(Catalog catalog)
      The SET CATALOG statement.

      Set the current catalog to a new value.

    • SetSchema

      public static final QOM.SetSchema SetSchema()
      The SET SCHEMA statement.

      Set the current schema to a new value.

    • SetSchema

      public static final QOM.SetSchema SetSchema(Schema schema)
      The SET SCHEMA statement.

      Set the current schema to a new value.

    • Truncate

      public static final <R extends Record> QOM.Truncate<R> Truncate()
      The TRUNCATE statement.
    • Truncate

      public static final <R extends Record> QOM.Truncate<R> Truncate(Collection<? extends Table<?>> table, QOM.IdentityRestartOption restartIdentity, QOM.Cascade cascade)
      The TRUNCATE statement.
    • Call

      @Pro public static final QOM.Call Call()
      The CALL statement.

      Call a stored procedure.

    • Call

      @Pro public static final QOM.Call Call(Name procedure, Collection<? extends Field<?>> args)
      The CALL statement.

      Call a stored procedure.

    • StartTransaction

      public static final QOM.StartTransaction StartTransaction()
      The START TRANSACTION statement.

      Start a transaction

    • Savepoint

      public static final QOM.Savepoint Savepoint()
      The SAVEPOINT statement.

      Specify a savepoint

    • Savepoint

      public static final QOM.Savepoint Savepoint(Name name)
      The SAVEPOINT statement.

      Specify a savepoint

    • ReleaseSavepoint

      public static final QOM.ReleaseSavepoint ReleaseSavepoint()
      The RELEASE SAVEPOINT statement.

      Release a savepoint

    • ReleaseSavepoint

      public static final QOM.ReleaseSavepoint ReleaseSavepoint(Name name)
      The RELEASE SAVEPOINT statement.

      Release a savepoint

    • Commit

      public static final QOM.Commit Commit()
      The COMMIT statement.

      Commit a transaction

    • Rollback

      public static final QOM.Rollback Rollback()
      The ROLLBACK statement.

      Rollback a transaction

    • Rollback

      public static final QOM.Rollback Rollback(Name toSavepoint)
      The ROLLBACK statement.

      Rollback a transaction

    • And

      public static final QOM.And And()
      The AND operator.
    • And

      public static final QOM.And And(Condition arg1, Condition arg2)
      The AND operator.
    • TableEq

      public static final <R extends Record> QOM.TableEq<R> TableEq()
      The EQ operator.
    • TableEq

      public static final <R extends Record> QOM.TableEq<R> TableEq(Table<R> arg1, Table<R> arg2)
      The EQ operator.
    • Eq

      public static final <T> QOM.Eq<T> Eq()
      The EQ operator.
    • Eq

      public static final <T> QOM.Eq<T> Eq(Field<T> arg1, Field<T> arg2)
      The EQ operator.
    • EqQuantified

      public static final <T> QOM.EqQuantified<T> EqQuantified()
      The EQ operator.
    • EqQuantified

      public static final <T> QOM.EqQuantified<T> EqQuantified(Field<T> arg1, QuantifiedSelect<? extends Record1<T>> arg2)
      The EQ operator.
    • Exists

      public static final QOM.Exists Exists()
      The EXISTS function.
    • Exists

      public static final QOM.Exists Exists(Select<?> query)
      The EXISTS function.
    • Ge

      public static final <T> QOM.Ge<T> Ge()
      The GE operator.
    • Ge

      public static final <T> QOM.Ge<T> Ge(Field<T> arg1, Field<T> arg2)
      The GE operator.
    • GeQuantified

      public static final <T> QOM.GeQuantified<T> GeQuantified()
      The GE operator.
    • GeQuantified

      public static final <T> QOM.GeQuantified<T> GeQuantified(Field<T> arg1, QuantifiedSelect<? extends Record1<T>> arg2)
      The GE operator.
    • Gt

      public static final <T> QOM.Gt<T> Gt()
      The GT operator.
    • Gt

      public static final <T> QOM.Gt<T> Gt(Field<T> arg1, Field<T> arg2)
      The GT operator.
    • GtQuantified

      public static final <T> QOM.GtQuantified<T> GtQuantified()
      The GT operator.
    • GtQuantified

      public static final <T> QOM.GtQuantified<T> GtQuantified(Field<T> arg1, QuantifiedSelect<? extends Record1<T>> arg2)
      The GT operator.
    • In

      public static final <T> QOM.In<T> In()
      The IN operator.

      The subquery must return exactly one field. This is not checked by jOOQ and will result in syntax errors in the database, if not used correctly.

    • In

      public static final <T> QOM.In<T> In(Field<T> arg1, Select<? extends Record1<T>> arg2)
      The IN operator.

      The subquery must return exactly one field. This is not checked by jOOQ and will result in syntax errors in the database, if not used correctly.

    • IsDistinctFrom

      public static final <T> QOM.IsDistinctFrom<T> IsDistinctFrom()
      The IS DISTINCT FROM operator.

      The DISTINCT predicate allows for creating NULL safe comparisons where the two operands are tested for non-equality

    • IsDistinctFrom

      public static final <T> QOM.IsDistinctFrom<T> IsDistinctFrom(Field<T> arg1, Field<T> arg2)
      The IS DISTINCT FROM operator.

      The DISTINCT predicate allows for creating NULL safe comparisons where the two operands are tested for non-equality

    • IsNull

      public static final QOM.IsNull IsNull()
      The IS NULL operator.
    • IsNull

      public static final QOM.IsNull IsNull(Field<?> field)
      The IS NULL operator.
    • IsNotDistinctFrom

      public static final <T> QOM.IsNotDistinctFrom<T> IsNotDistinctFrom()
      The IS NOT DISTINCT FROM operator.

      The NOT DISTINCT predicate allows for creating NULL safe comparisons where the two operands are tested for equality

    • IsNotDistinctFrom

      public static final <T> QOM.IsNotDistinctFrom<T> IsNotDistinctFrom(Field<T> arg1, Field<T> arg2)
      The IS NOT DISTINCT FROM operator.

      The NOT DISTINCT predicate allows for creating NULL safe comparisons where the two operands are tested for equality

    • IsNotNull

      public static final QOM.IsNotNull IsNotNull()
      The IS NOT NULL operator.
    • IsNotNull

      public static final QOM.IsNotNull IsNotNull(Field<?> field)
      The IS NOT NULL operator.
    • Le

      public static final <T> QOM.Le<T> Le()
      The LE operator.
    • Le

      public static final <T> QOM.Le<T> Le(Field<T> arg1, Field<T> arg2)
      The LE operator.
    • LeQuantified

      public static final <T> QOM.LeQuantified<T> LeQuantified()
      The LE operator.
    • LeQuantified

      public static final <T> QOM.LeQuantified<T> LeQuantified(Field<T> arg1, QuantifiedSelect<? extends Record1<T>> arg2)
      The LE operator.
    • Like

      public static final QOM.Like Like()
      The LIKE operator.
    • Like

      public static final QOM.Like Like(Field<?> value, Field<String> pattern, Character escape)
      The LIKE operator.
    • LikeQuantified

      public static final QOM.LikeQuantified LikeQuantified()
      The LIKE operator.
    • LikeQuantified

      public static final QOM.LikeQuantified LikeQuantified(Field<?> value, QuantifiedSelect<? extends Record1<String>> pattern, Character escape)
      The LIKE operator.
    • LikeIgnoreCase

      public static final QOM.LikeIgnoreCase LikeIgnoreCase()
      The LIKE IGNORE CASE operator.

      Create a condition to case-insensitively pattern-check this field against a value.

      This translates to this ilike value in SQLDialect.POSTGRES, or to lower(this) like lower(value) in all other dialects.

    • LikeIgnoreCase

      public static final QOM.LikeIgnoreCase LikeIgnoreCase(Field<?> value, Field<String> pattern, Character escape)
      The LIKE IGNORE CASE operator.

      Create a condition to case-insensitively pattern-check this field against a value.

      This translates to this ilike value in SQLDialect.POSTGRES, or to lower(this) like lower(value) in all other dialects.

    • Lt

      public static final <T> QOM.Lt<T> Lt()
      The LT operator.
    • Lt

      public static final <T> QOM.Lt<T> Lt(Field<T> arg1, Field<T> arg2)
      The LT operator.
    • LtQuantified

      public static final <T> QOM.LtQuantified<T> LtQuantified()
      The LT operator.
    • LtQuantified

      public static final <T> QOM.LtQuantified<T> LtQuantified(Field<T> arg1, QuantifiedSelect<? extends Record1<T>> arg2)
      The LT operator.
    • TableNe

      public static final <R extends Record> QOM.TableNe<R> TableNe()
      The NE operator.
    • TableNe

      public static final <R extends Record> QOM.TableNe<R> TableNe(Table<R> arg1, Table<R> arg2)
      The NE operator.
    • Ne

      public static final <T> QOM.Ne<T> Ne()
      The NE operator.
    • Ne

      public static final <T> QOM.Ne<T> Ne(Field<T> arg1, Field<T> arg2)
      The NE operator.
    • NeQuantified

      public static final <T> QOM.NeQuantified<T> NeQuantified()
      The NE operator.
    • NeQuantified

      public static final <T> QOM.NeQuantified<T> NeQuantified(Field<T> arg1, QuantifiedSelect<? extends Record1<T>> arg2)
      The NE operator.
    • Not

      public static final QOM.Not Not()
      The NOT operator.
    • Not

      public static final QOM.Not Not(Condition condition)
      The NOT operator.
    • NotField

      public static final QOM.NotField NotField()
      The NOT operator.
    • NotField

      public static final QOM.NotField NotField(Field<Boolean> field)
      The NOT operator.
    • NotIn

      public static final <T> QOM.NotIn<T> NotIn()
      The NOT IN operator.

      The subquery must return exactly one field. This is not checked by jOOQ and will result in syntax errors in the database, if not used correctly.

      If any of the passed values is NULL, then the condition will be NULL (or false, depending on the dialect) as well. This is standard SQL behaviour.

    • NotIn

      public static final <T> QOM.NotIn<T> NotIn(Field<T> arg1, Select<? extends Record1<T>> arg2)
      The NOT IN operator.

      The subquery must return exactly one field. This is not checked by jOOQ and will result in syntax errors in the database, if not used correctly.

      If any of the passed values is NULL, then the condition will be NULL (or false, depending on the dialect) as well. This is standard SQL behaviour.

    • NotLike

      public static final QOM.NotLike NotLike()
      The NOT LIKE operator.
    • NotLike

      public static final QOM.NotLike NotLike(Field<?> value, Field<String> pattern, Character escape)
      The NOT LIKE operator.
    • NotLikeQuantified

      public static final QOM.NotLikeQuantified NotLikeQuantified()
      The NOT LIKE operator.
    • NotLikeQuantified

      public static final QOM.NotLikeQuantified NotLikeQuantified(Field<?> value, QuantifiedSelect<? extends Record1<String>> pattern, Character escape)
      The NOT LIKE operator.
    • NotLikeIgnoreCase

      public static final QOM.NotLikeIgnoreCase NotLikeIgnoreCase()
      The NOT LIKE IGNORE CASE operator.

      Create a condition to case-insensitively pattern-check this field against a value.

      This translates to this not ilike value in SQLDialect.POSTGRES, or to lower(this) not like lower(value) in all other dialects.

    • NotLikeIgnoreCase

      public static final QOM.NotLikeIgnoreCase NotLikeIgnoreCase(Field<?> value, Field<String> pattern, Character escape)
      The NOT LIKE IGNORE CASE operator.

      Create a condition to case-insensitively pattern-check this field against a value.

      This translates to this not ilike value in SQLDialect.POSTGRES, or to lower(this) not like lower(value) in all other dialects.

    • NotSimilarTo

      public static final QOM.NotSimilarTo NotSimilarTo()
      The NOT SIMILAR TO operator.
    • NotSimilarTo

      public static final QOM.NotSimilarTo NotSimilarTo(Field<?> value, Field<String> pattern, Character escape)
      The NOT SIMILAR TO operator.
    • NotSimilarToQuantified

      public static final QOM.NotSimilarToQuantified NotSimilarToQuantified()
      The NOT SIMILAR TO operator.
    • NotSimilarToQuantified

      public static final QOM.NotSimilarToQuantified NotSimilarToQuantified(Field<?> value, QuantifiedSelect<? extends Record1<String>> pattern, Character escape)
      The NOT SIMILAR TO operator.
    • Or

      public static final QOM.Or Or()
      The OR operator.
    • Or

      public static final QOM.Or Or(Condition arg1, Condition arg2)
      The OR operator.
    • SimilarTo

      public static final QOM.SimilarTo SimilarTo()
      The SIMILAR TO operator.
    • SimilarTo

      public static final QOM.SimilarTo SimilarTo(Field<?> value, Field<String> pattern, Character escape)
      The SIMILAR TO operator.
    • SimilarToQuantified

      public static final QOM.SimilarToQuantified SimilarToQuantified()
      The SIMILAR TO operator.
    • SimilarToQuantified

      public static final QOM.SimilarToQuantified SimilarToQuantified(Field<?> value, QuantifiedSelect<? extends Record1<String>> pattern, Character escape)
      The SIMILAR TO operator.
    • Unique

      public static final QOM.Unique Unique()
      The UNIQUE function.
    • Unique

      public static final QOM.Unique Unique(Select<?> query)
      The UNIQUE function.
    • Xor

      public static final QOM.Xor Xor()
      The XOR operator.
    • Xor

      public static final QOM.Xor Xor(Condition arg1, Condition arg2)
      The XOR operator.
    • RowEq

      public static final <T extends Row> QOM.RowEq<T> RowEq()
      The ROW EQ operator.
    • RowEq

      public static final <T extends Row> QOM.RowEq<T> RowEq(T arg1, T arg2)
      The ROW EQ operator.
    • RowNe

      public static final <T extends Row> QOM.RowNe<T> RowNe()
      The ROW NE operator.
    • RowNe

      public static final <T extends Row> QOM.RowNe<T> RowNe(T arg1, T arg2)
      The ROW NE operator.
    • RowGt

      public static final <T extends Row> QOM.RowGt<T> RowGt()
      The ROW GT operator.
    • RowGt

      public static final <T extends Row> QOM.RowGt<T> RowGt(T arg1, T arg2)
      The ROW GT operator.
    • RowGe

      public static final <T extends Row> QOM.RowGe<T> RowGe()
      The ROW GE operator.
    • RowGe

      public static final <T extends Row> QOM.RowGe<T> RowGe(T arg1, T arg2)
      The ROW GE operator.
    • RowLt

      public static final <T extends Row> QOM.RowLt<T> RowLt()
      The ROW LT operator.
    • RowLt

      public static final <T extends Row> QOM.RowLt<T> RowLt(T arg1, T arg2)
      The ROW LT operator.
    • RowLe

      public static final <T extends Row> QOM.RowLe<T> RowLe()
      The ROW LE operator.
    • RowLe

      public static final <T extends Row> QOM.RowLe<T> RowLe(T arg1, T arg2)
      The ROW LE operator.
    • IsDocument

      public static final QOM.IsDocument IsDocument()
      The IS DOCUMENT operator.

      Create a condition to check if this field contains XML data.

    • IsDocument

      public static final QOM.IsDocument IsDocument(Field<?> field)
      The IS DOCUMENT operator.

      Create a condition to check if this field contains XML data.

    • IsNotDocument

      public static final QOM.IsNotDocument IsNotDocument()
      The IS NOT DOCUMENT operator.

      Create a condition to check if this field does not contain XML data.

    • IsNotDocument

      public static final QOM.IsNotDocument IsNotDocument(Field<?> field)
      The IS NOT DOCUMENT operator.

      Create a condition to check if this field does not contain XML data.

    • IsJson

      public static final QOM.IsJson IsJson()
      The IS JSON operator.

      Create a condition to check if this field contains JSON data.

    • IsJson

      public static final QOM.IsJson IsJson(Field<?> field)
      The IS JSON operator.

      Create a condition to check if this field contains JSON data.

    • IsNotJson

      public static final QOM.IsNotJson IsNotJson()
      The IS NOT JSON operator.

      Create a condition to check if this field does not contain JSON data.

    • IsNotJson

      public static final QOM.IsNotJson IsNotJson(Field<?> field)
      The IS NOT JSON operator.

      Create a condition to check if this field does not contain JSON data.

    • Excluded

      public static final <T> QOM.Excluded<T> Excluded()
      The EXCLUDED function.

      Provide "EXCLUDED" qualification for a column for use in ON CONFLICT or ON DUPLICATE KEY UPDATE.

    • Excluded

      public static final <T> QOM.Excluded<T> Excluded(Field<T> field)
      The EXCLUDED function.

      Provide "EXCLUDED" qualification for a column for use in ON CONFLICT or ON DUPLICATE KEY UPDATE.

    • QualifiedRowid

      public static final QOM.QualifiedRowid QualifiedRowid()
      The ROWID operator.

      Get a table.rowid reference from this table.

      A rowid value describes the physical location of a row on the disk, which can be used as a replacement for a primary key in some situations - especially within a query, e.g. to self-join a table:

      
       -- Emulating this MySQL statement...
       DELETE FROM x ORDER BY x.y LIMIT 1
      
       -- ... in other databases
       DELETE FROM x
       WHERE x.rowid IN (
         SELECT x.rowid FROM x ORDER BY x.a LIMIT 1
       )
       

      It is not recommended to use rowid values in client applications as actual row identifiers as the database system may move a row to a different physical location at any time, thus changing the rowid value. In general, use primary keys, instead.

    • QualifiedRowid

      public static final QOM.QualifiedRowid QualifiedRowid(Table<?> table)
      The ROWID operator.

      Get a table.rowid reference from this table.

      A rowid value describes the physical location of a row on the disk, which can be used as a replacement for a primary key in some situations - especially within a query, e.g. to self-join a table:

      
       -- Emulating this MySQL statement...
       DELETE FROM x ORDER BY x.y LIMIT 1
      
       -- ... in other databases
       DELETE FROM x
       WHERE x.rowid IN (
         SELECT x.rowid FROM x ORDER BY x.a LIMIT 1
       )
       

      It is not recommended to use rowid values in client applications as actual row identifiers as the database system may move a row to a different physical location at any time, thus changing the rowid value. In general, use primary keys, instead.

    • Abs

      public static final <T extends Number> QOM.Abs<T> Abs()
      The ABS function.
    • Abs

      public static final <T extends Number> QOM.Abs<T> Abs(Field<T> value)
      The ABS function.
    • Acos

      public static final QOM.Acos Acos()
      The ACOS function.
    • Acos

      public static final QOM.Acos Acos(Field<? extends Number> value)
      The ACOS function.
    • Acosh

      public static final QOM.Acosh Acosh()
      The ACOSH function.
    • Acosh

      public static final QOM.Acosh Acosh(Field<? extends Number> value)
      The ACOSH function.
    • Acoth

      public static final QOM.Acoth Acoth()
      The ACOTH function.
    • Acoth

      public static final QOM.Acoth Acoth(Field<? extends Number> value)
      The ACOTH function.
    • Add

      public static final <T> QOM.Add<T> Add()
      The ADD operator.
    • Add

      public static final <T> QOM.Add<T> Add(Field<T> arg1, Field<T> arg2)
      The ADD operator.
    • Asin

      public static final QOM.Asin Asin()
      The ASIN function.
    • Asin

      public static final QOM.Asin Asin(Field<? extends Number> value)
      The ASIN function.
    • Asinh

      public static final QOM.Asinh Asinh()
      The ASINH function.
    • Asinh

      public static final QOM.Asinh Asinh(Field<? extends Number> value)
      The ASINH function.
    • Atan

      public static final QOM.Atan Atan()
      The ATAN function.
    • Atan

      public static final QOM.Atan Atan(Field<? extends Number> value)
      The ATAN function.
    • Atan2

      public static final QOM.Atan2 Atan2()
      The ATAN2 function.
    • Atan2

      public static final QOM.Atan2 Atan2(Field<? extends Number> x, Field<? extends Number> y)
      The ATAN2 function.
    • Atanh

      public static final QOM.Atanh Atanh()
      The ATANH function.
    • Atanh

      public static final QOM.Atanh Atanh(Field<? extends Number> value)
      The ATANH function.
    • BitAnd

      public static final <T extends Number> QOM.BitAnd<T> BitAnd()
      The BIT AND operator.
    • BitAnd

      public static final <T extends Number> QOM.BitAnd<T> BitAnd(Field<T> arg1, Field<T> arg2)
      The BIT AND operator.
    • BitCount

      public static final QOM.BitCount BitCount()
      The BIT COUNT function.

      Count the number of bits set in a number

    • BitCount

      public static final QOM.BitCount BitCount(Field<? extends Number> value)
      The BIT COUNT function.

      Count the number of bits set in a number

    • BitGet

      public static final <T extends Number> QOM.BitGet<T> BitGet()
      The BIT GET function.
    • BitGet

      public static final <T extends Number> QOM.BitGet<T> BitGet(Field<T> value, Field<? extends Number> bit)
      The BIT GET function.
    • BitNand

      public static final <T extends Number> QOM.BitNand<T> BitNand()
      The BIT NAND operator.
    • BitNand

      public static final <T extends Number> QOM.BitNand<T> BitNand(Field<T> arg1, Field<T> arg2)
      The BIT NAND operator.
    • BitNor

      public static final <T extends Number> QOM.BitNor<T> BitNor()
      The BIT NOR operator.
    • BitNor

      public static final <T extends Number> QOM.BitNor<T> BitNor(Field<T> arg1, Field<T> arg2)
      The BIT NOR operator.
    • BitNot

      public static final <T extends Number> QOM.BitNot<T> BitNot()
      The BIT NOT operator.
    • BitNot

      public static final <T extends Number> QOM.BitNot<T> BitNot(Field<T> arg1)
      The BIT NOT operator.
    • BitOr

      public static final <T extends Number> QOM.BitOr<T> BitOr()
      The BIT OR operator.
    • BitOr

      public static final <T extends Number> QOM.BitOr<T> BitOr(Field<T> arg1, Field<T> arg2)
      The BIT OR operator.
    • BitSet

      public static final <T extends Number> QOM.BitSet<T> BitSet()
      The BIT SET function.
    • BitSet

      public static final <T extends Number> QOM.BitSet<T> BitSet(Field<T> value, Field<? extends Number> bit, Field<T> newValue)
      The BIT SET function.
    • BitXNor

      public static final <T extends Number> QOM.BitXNor<T> BitXNor()
      The BIT X NOR operator.
    • BitXNor

      public static final <T extends Number> QOM.BitXNor<T> BitXNor(Field<T> arg1, Field<T> arg2)
      The BIT X NOR operator.
    • BitXor

      public static final <T extends Number> QOM.BitXor<T> BitXor()
      The BIT XOR operator.
    • BitXor

      public static final <T extends Number> QOM.BitXor<T> BitXor(Field<T> arg1, Field<T> arg2)
      The BIT XOR operator.
    • Cbrt

      public static final QOM.Cbrt Cbrt()
      The CBRT function.
    • Cbrt

      public static final QOM.Cbrt Cbrt(Field<? extends Number> value)
      The CBRT function.
    • Ceil

      public static final <T extends Number> QOM.Ceil<T> Ceil()
      The CEIL function.

      Get the smallest integer value equal or greater to a value.

    • Ceil

      public static final <T extends Number> QOM.Ceil<T> Ceil(Field<T> value)
      The CEIL function.

      Get the smallest integer value equal or greater to a value.

    • Cos

      public static final QOM.Cos Cos()
      The COS function.
    • Cos

      public static final QOM.Cos Cos(Field<? extends Number> value)
      The COS function.
    • Cosh

      public static final QOM.Cosh Cosh()
      The COSH function.
    • Cosh

      public static final QOM.Cosh Cosh(Field<? extends Number> value)
      The COSH function.
    • Cot

      public static final QOM.Cot Cot()
      The COT function.
    • Cot

      public static final QOM.Cot Cot(Field<? extends Number> value)
      The COT function.
    • Coth

      public static final QOM.Coth Coth()
      The COTH function.
    • Coth

      public static final QOM.Coth Coth(Field<? extends Number> value)
      The COTH function.
    • Degrees

      public static final QOM.Degrees Degrees()
      The DEGREES function.

      Turn a value in radians to degrees.

    • Degrees

      public static final QOM.Degrees Degrees(Field<? extends Number> radians)
      The DEGREES function.

      Turn a value in radians to degrees.

    • Div

      public static final <T> QOM.Div<T> Div()
      The DIV operator.
    • Div

      public static final <T> QOM.Div<T> Div(Field<T> arg1, Field<T> arg2)
      The DIV operator.
    • Euler

      public static final QOM.Euler Euler()
      The E function.

      The E literal (Euler number).

    • Exp

      public static final QOM.Exp Exp()
      The EXP function.
    • Exp

      public static final QOM.Exp Exp(Field<? extends Number> value)
      The EXP function.
    • Floor

      public static final <T extends Number> QOM.Floor<T> Floor()
      The FLOOR function.

      Get the biggest integer value equal or less than a value.

    • Floor

      public static final <T extends Number> QOM.Floor<T> Floor(Field<T> value)
      The FLOOR function.

      Get the biggest integer value equal or less than a value.

    • Ln

      public static final QOM.Ln Ln()
      The LN function.

      Get the natural logarithm of a value.

    • Ln

      public static final QOM.Ln Ln(Field<? extends Number> value)
      The LN function.

      Get the natural logarithm of a value.

    • Log

      public static final QOM.Log Log()
      The LOG function.

      Get the logarithm of a value for a base.

    • Log

      public static final QOM.Log Log(Field<? extends Number> value, Field<? extends Number> base)
      The LOG function.

      Get the logarithm of a value for a base.

    • Log10

      public static final QOM.Log10 Log10()
      The LOG10 function.

      Get the logarithm of a value for base 10.

    • Log10

      public static final QOM.Log10 Log10(Field<? extends Number> value)
      The LOG10 function.

      Get the logarithm of a value for base 10.

    • Mod

      public static final <T extends Number> QOM.Mod<T> Mod()
      The MOD operator.
    • Mod

      public static final <T extends Number> QOM.Mod<T> Mod(Field<T> dividend, Field<? extends Number> divisor)
      The MOD operator.
    • Mul

      public static final <T> QOM.Mul<T> Mul()
      The MUL operator.
    • Mul

      public static final <T> QOM.Mul<T> Mul(Field<T> arg1, Field<T> arg2)
      The MUL operator.
    • Pi

      public static final QOM.Pi Pi()
      The PI function.

      The π literal.

    • Power

      public static final QOM.Power Power()
      The POWER operator.
    • Power

      public static final QOM.Power Power(Field<? extends Number> base, Field<? extends Number> exponent)
      The POWER operator.
    • Radians

      public static final QOM.Radians Radians()
      The RADIANS function.

      Turn a value in degrees to radians.

    • Radians

      public static final QOM.Radians Radians(Field<? extends Number> degrees)
      The RADIANS function.

      Turn a value in degrees to radians.

    • Rand

      public static final QOM.Rand Rand()
      The RAND function.

      Get a random numeric value.

    • Root

      public static final QOM.Root Root()
      The ROOT function.
    • Root

      public static final QOM.Root Root(Field<? extends Number> value, Field<? extends Number> degree)
      The ROOT function.
    • Round

      public static final <T extends Number> QOM.Round<T> Round()
      The ROUND function.

      Round a numeric value to the nearest decimal precision.

    • Round

      public static final <T extends Number> QOM.Round<T> Round(Field<T> value, Field<Integer> decimals)
      The ROUND function.

      Round a numeric value to the nearest decimal precision.

    • Shl

      public static final <T extends Number> QOM.Shl<T> Shl()
      The SHL operator.

      Left shift all bits in a number

    • Shl

      public static final <T extends Number> QOM.Shl<T> Shl(Field<T> value, Field<? extends Number> count)
      The SHL operator.

      Left shift all bits in a number

    • Shr

      public static final <T extends Number> QOM.Shr<T> Shr()
      The SHR operator.

      Right shift all bits in a number

    • Shr

      public static final <T extends Number> QOM.Shr<T> Shr(Field<T> value, Field<? extends Number> count)
      The SHR operator.

      Right shift all bits in a number

    • Sign

      public static final QOM.Sign Sign()
      The SIGN function.

      Get the sign of a number and return it as any of +1, 0, -1.

    • Sign

      public static final QOM.Sign Sign(Field<? extends Number> value)
      The SIGN function.

      Get the sign of a number and return it as any of +1, 0, -1.

    • Sin

      public static final QOM.Sin Sin()
      The SIN function.
    • Sin

      public static final QOM.Sin Sin(Field<? extends Number> value)
      The SIN function.
    • Sinh

      public static final QOM.Sinh Sinh()
      The SINH function.
    • Sinh

      public static final QOM.Sinh Sinh(Field<? extends Number> value)
      The SINH function.
    • Sqrt

      public static final QOM.Sqrt Sqrt()
      The SQRT function.
    • Sqrt

      public static final QOM.Sqrt Sqrt(Field<? extends Number> value)
      The SQRT function.
    • Square

      public static final <T extends Number> QOM.Square<T> Square()
      The SQUARE function.
    • Square

      public static final <T extends Number> QOM.Square<T> Square(Field<T> value)
      The SQUARE function.
    • Sub

      public static final <T> QOM.Sub<T> Sub()
      The SUB operator.
    • Sub

      public static final <T> QOM.Sub<T> Sub(Field<T> arg1, Field<T> arg2)
      The SUB operator.
    • Tan

      public static final QOM.Tan Tan()
      The TAN function.
    • Tan

      public static final QOM.Tan Tan(Field<? extends Number> value)
      The TAN function.
    • Tanh

      public static final QOM.Tanh Tanh()
      The TANH function.
    • Tanh

      public static final QOM.Tanh Tanh(Field<? extends Number> value)
      The TANH function.
    • Tau

      public static final QOM.Tau Tau()
      The TAU function.

      The τ literal, or π, in a better world.

    • Trunc

      public static final <T extends Number> QOM.Trunc<T> Trunc()
      The TRUNC function.

      Truncate a number to a given number of decimals.

    • Trunc

      public static final <T extends Number> QOM.Trunc<T> Trunc(Field<T> value, Field<Integer> decimals)
      The TRUNC function.

      Truncate a number to a given number of decimals.

    • WidthBucket

      public static final <T extends Number> QOM.WidthBucket<T> WidthBucket()
      The WIDTH BUCKET function.

      Divide a range into buckets of equal size.

    • WidthBucket

      public static final <T extends Number> QOM.WidthBucket<T> WidthBucket(Field<T> field, Field<T> low, Field<T> high, Field<Integer> buckets)
      The WIDTH BUCKET function.

      Divide a range into buckets of equal size.

    • Ascii

      public static final QOM.Ascii Ascii()
      The ASCII function.

      The ASCII value of a character.

    • Ascii

      public static final QOM.Ascii Ascii(Field<String> string)
      The ASCII function.

      The ASCII value of a character.

    • BitLength

      public static final QOM.BitLength BitLength()
      The BIT LENGTH function.

      The length of a string in bits.

    • BitLength

      public static final QOM.BitLength BitLength(Field<String> string)
      The BIT LENGTH function.

      The length of a string in bits.

    • CharLength

      public static final QOM.CharLength CharLength()
      The CHAR LENGTH function.

      The length of a string in characters.

    • CharLength

      public static final QOM.CharLength CharLength(Field<String> string)
      The CHAR LENGTH function.

      The length of a string in characters.

    • Chr

      public static final QOM.Chr Chr()
      The CHR function.
    • Chr

      public static final QOM.Chr Chr(Field<? extends Number> value)
      The CHR function.
    • Contains

      public static final <T> QOM.Contains<T> Contains()
      The CONTAINS operator.

      Convenience method for Field.like(String, char) including proper adding of wildcards and escaping.

      SQL: this like ('%' || escape(value, '\') || '%') escape '\'

      Note: This also works with numbers, for instance val(1133).contains(13)

      If you're using SQLDialect.POSTGRES, then you can use this method also to express the "ARRAY contains" operator. For example:

      
       // Use this expression
       val(new Integer[] { 1, 2, 3 }).contains(new Integer[] { 1, 2 })
      
       // ... to render this SQL
       ARRAY[1, 2, 3] @> ARRAY[1, 2]
       

      Note, this does not correspond to the Oracle Text CONTAINS() function. Refer to OracleDSL.contains(Field, String) instead.

    • Contains

      public static final <T> QOM.Contains<T> Contains(Field<T> value, Field<T> content)
      The CONTAINS operator.

      Convenience method for Field.like(String, char) including proper adding of wildcards and escaping.

      SQL: this like ('%' || escape(value, '\') || '%') escape '\'

      Note: This also works with numbers, for instance val(1133).contains(13)

      If you're using SQLDialect.POSTGRES, then you can use this method also to express the "ARRAY contains" operator. For example:

      
       // Use this expression
       val(new Integer[] { 1, 2, 3 }).contains(new Integer[] { 1, 2 })
      
       // ... to render this SQL
       ARRAY[1, 2, 3] @> ARRAY[1, 2]
       

      Note, this does not correspond to the Oracle Text CONTAINS() function. Refer to OracleDSL.contains(Field, String) instead.

    • ContainsIgnoreCase

      public static final <T> QOM.ContainsIgnoreCase<T> ContainsIgnoreCase()
      The CONTAINS IGNORE CASE operator.

      Convenience method for Field.likeIgnoreCase(String, char) including proper adding of wildcards and escaping.

      This translates to this ilike ('%' || escape(value, '\') || '%') escape '\' in SQLDialect.POSTGRES, or to lower(this) like lower(('%' || escape(value, '\') || '%') escape '\') in all other dialects.

    • ContainsIgnoreCase

      public static final <T> QOM.ContainsIgnoreCase<T> ContainsIgnoreCase(Field<T> value, Field<T> content)
      The CONTAINS IGNORE CASE operator.

      Convenience method for Field.likeIgnoreCase(String, char) including proper adding of wildcards and escaping.

      This translates to this ilike ('%' || escape(value, '\') || '%') escape '\' in SQLDialect.POSTGRES, or to lower(this) like lower(('%' || escape(value, '\') || '%') escape '\') in all other dialects.

    • Digits

      public static final QOM.Digits Digits()
      The DIGITS function.
    • Digits

      public static final QOM.Digits Digits(Field<? extends Number> value)
      The DIGITS function.
    • EndsWith

      public static final <T> QOM.EndsWith<T> EndsWith()
      The ENDS WITH operator.

      Convenience method for Field.like(String, char) including proper adding of wildcards and escaping.

      SQL: this like ('%' || escape(value, '\')) escape '\'

      Note: This also works with numbers, for instance val(1133).endsWith(33)

    • EndsWith

      public static final <T> QOM.EndsWith<T> EndsWith(Field<T> string, Field<T> suffix)
      The ENDS WITH operator.

      Convenience method for Field.like(String, char) including proper adding of wildcards and escaping.

      SQL: this like ('%' || escape(value, '\')) escape '\'

      Note: This also works with numbers, for instance val(1133).endsWith(33)

    • EndsWithIgnoreCase

      public static final <T> QOM.EndsWithIgnoreCase<T> EndsWithIgnoreCase()
      The ENDS WITH IGNORE CASE operator.

      Convenience method for Field.like(String, char) including proper adding of wildcards and escaping.

      SQL: lower(this) like ('%' || lower(escape(value, '\'))) escape '\'

      Note: This also works with numbers, for instance val(1133).endsWithIgnoreCase(33)

    • EndsWithIgnoreCase

      public static final <T> QOM.EndsWithIgnoreCase<T> EndsWithIgnoreCase(Field<T> string, Field<T> suffix)
      The ENDS WITH IGNORE CASE operator.

      Convenience method for Field.like(String, char) including proper adding of wildcards and escaping.

      SQL: lower(this) like ('%' || lower(escape(value, '\'))) escape '\'

      Note: This also works with numbers, for instance val(1133).endsWithIgnoreCase(33)

    • Left

      public static final QOM.Left Left()
      The LEFT function.

      Get the left outermost characters from a string.

    • Left

      public static final QOM.Left Left(Field<String> string, Field<? extends Number> length)
      The LEFT function.

      Get the left outermost characters from a string.

    • Lower

      public static final QOM.Lower Lower()
      The LOWER function.

      Turn a string into lower case.

    • Lower

      public static final QOM.Lower Lower(Field<String> string)
      The LOWER function.

      Turn a string into lower case.

    • Lpad

      public static final QOM.Lpad Lpad()
      The LPAD function.

      Left-pad a string with a character (whitespace as default) for a number of times.

    • Lpad

      public static final QOM.Lpad Lpad(Field<String> string, Field<? extends Number> length, Field<String> character)
      The LPAD function.

      Left-pad a string with a character (whitespace as default) for a number of times.

    • Ltrim

      public static final QOM.Ltrim Ltrim()
      The LTRIM function.

      Trim characters (whitespace as default) from the left side of a string.

    • Ltrim

      public static final QOM.Ltrim Ltrim(Field<String> string, Field<String> characters)
      The LTRIM function.

      Trim characters (whitespace as default) from the left side of a string.

    • Md5

      public static final QOM.Md5 Md5()
      The MD5 function.

      Calculate an MD5 hash from a string.

    • Md5

      public static final QOM.Md5 Md5(Field<String> string)
      The MD5 function.

      Calculate an MD5 hash from a string.

    • OctetLength

      public static final QOM.OctetLength OctetLength()
      The OCTET LENGTH function.

      The length of a string in octets.

    • OctetLength

      public static final QOM.OctetLength OctetLength(Field<String> string)
      The OCTET LENGTH function.

      The length of a string in octets.

    • Overlay

      public static final QOM.Overlay Overlay()
      The OVERLAY function.

      Place a string on top of another string, replacing the original contents.

    • Overlay

      public static final QOM.Overlay Overlay(Field<String> in, Field<String> placing, Field<? extends Number> startIndex, Field<? extends Number> length)
      The OVERLAY function.

      Place a string on top of another string, replacing the original contents.

    • Position

      public static final QOM.Position Position()
      The POSITION function.

      Search the position (1-based) of a substring in another string.

    • Position

      public static final QOM.Position Position(Field<String> in, Field<String> search, Field<? extends Number> startIndex)
      The POSITION function.

      Search the position (1-based) of a substring in another string.

    • Repeat

      public static final QOM.Repeat Repeat()
      The REPEAT function.

      Repeat a string a number of times.

    • Repeat

      public static final QOM.Repeat Repeat(Field<String> string, Field<? extends Number> count)
      The REPEAT function.

      Repeat a string a number of times.

    • Replace

      public static final QOM.Replace Replace()
      The REPLACE function.

      Replace all occurrences of a substring in another string.

    • Replace

      public static final QOM.Replace Replace(Field<String> string, Field<String> search, Field<String> replace)
      The REPLACE function.

      Replace all occurrences of a substring in another string.

    • Reverse

      public static final QOM.Reverse Reverse()
      The REVERSE function.

      Reverse a string.

    • Reverse

      public static final QOM.Reverse Reverse(Field<String> string)
      The REVERSE function.

      Reverse a string.

    • Right

      public static final QOM.Right Right()
      The RIGHT function.

      Get the right outermost characters from a string.

    • Right

      public static final QOM.Right Right(Field<String> string, Field<? extends Number> length)
      The RIGHT function.

      Get the right outermost characters from a string.

    • Rpad

      public static final QOM.Rpad Rpad()
      The RPAD function.

      Right-pad a string with a character (whitespace as default) for a number of times.

    • Rpad

      public static final QOM.Rpad Rpad(Field<String> string, Field<? extends Number> length, Field<String> character)
      The RPAD function.

      Right-pad a string with a character (whitespace as default) for a number of times.

    • Rtrim

      public static final QOM.Rtrim Rtrim()
      The RTRIM function.

      Trim characters (whitespace as default) from the right side of a string.

    • Rtrim

      public static final QOM.Rtrim Rtrim(Field<String> string, Field<String> characters)
      The RTRIM function.

      Trim characters (whitespace as default) from the right side of a string.

    • Space

      public static final QOM.Space Space()
      The SPACE function.

      Get a string of spaces of a given length.

    • Space

      public static final QOM.Space Space(Field<? extends Number> count)
      The SPACE function.

      Get a string of spaces of a given length.

    • SplitPart

      public static final QOM.SplitPart SplitPart()
      The SPLIT PART function.

      Split a string into tokens, and retrieve the nth token.

    • SplitPart

      public static final QOM.SplitPart SplitPart(Field<String> string, Field<String> delimiter, Field<? extends Number> n)
      The SPLIT PART function.

      Split a string into tokens, and retrieve the nth token.

    • StartsWith

      public static final <T> QOM.StartsWith<T> StartsWith()
      The STARTS WITH operator.

      Convenience method for Field.like(String, char) including proper adding of wildcards and escaping.

      SQL: this like (escape(value, '\') || '%') escape '\'

      Note: This also works with numbers, for instance val(1133).startsWith(11)

    • StartsWith

      public static final <T> QOM.StartsWith<T> StartsWith(Field<T> string, Field<T> prefix)
      The STARTS WITH operator.

      Convenience method for Field.like(String, char) including proper adding of wildcards and escaping.

      SQL: this like (escape(value, '\') || '%') escape '\'

      Note: This also works with numbers, for instance val(1133).startsWith(11)

    • StartsWithIgnoreCase

      public static final <T> QOM.StartsWithIgnoreCase<T> StartsWithIgnoreCase()
      The STARTS WITH IGNORE CASE operator.

      Convenience method for Field.like(String, char) including proper adding of wildcards and escaping.

      SQL: lower(this) like (lower(escape(value, '\')) || '%') escape '\'

      Note: This also works with numbers, for instance val(1133).startsWithIgnoreCase(11)

    • StartsWithIgnoreCase

      public static final <T> QOM.StartsWithIgnoreCase<T> StartsWithIgnoreCase(Field<T> string, Field<T> prefix)
      The STARTS WITH IGNORE CASE operator.

      Convenience method for Field.like(String, char) including proper adding of wildcards and escaping.

      SQL: lower(this) like (lower(escape(value, '\')) || '%') escape '\'

      Note: This also works with numbers, for instance val(1133).startsWithIgnoreCase(11)

    • Substring

      public static final QOM.Substring Substring()
      The SUBSTRING function.

      Get a substring of a string, from a given position.

    • Substring

      public static final QOM.Substring Substring(Field<String> string, Field<? extends Number> startingPosition, Field<? extends Number> length)
      The SUBSTRING function.

      Get a substring of a string, from a given position.

    • SubstringIndex

      public static final QOM.SubstringIndex SubstringIndex()
      The SUBSTRING INDEX function.

      Get a substring of a string, from the beginning until the nth occurrence of a substring.

    • SubstringIndex

      public static final QOM.SubstringIndex SubstringIndex(Field<String> string, Field<String> delimiter, Field<? extends Number> n)
      The SUBSTRING INDEX function.

      Get a substring of a string, from the beginning until the nth occurrence of a substring.

    • ToChar

      public static final QOM.ToChar ToChar()
      The TO CHAR function.

      Format an arbitrary value as a string.

    • ToChar

      public static final QOM.ToChar ToChar(Field<?> value, Field<String> formatMask)
      The TO CHAR function.

      Format an arbitrary value as a string.

    • ToDate

      public static final QOM.ToDate ToDate()
      The TO DATE function.

      Parse a string-formatted date value to a date.

    • ToDate

      public static final QOM.ToDate ToDate(Field<String> value, Field<String> formatMask)
      The TO DATE function.

      Parse a string-formatted date value to a date.

    • ToHex

      public static final QOM.ToHex ToHex()
      The TO HEX function.

      Format a number to its hex value.

    • ToHex

      public static final QOM.ToHex ToHex(Field<? extends Number> value)
      The TO HEX function.

      Format a number to its hex value.

    • ToTimestamp

      public static final QOM.ToTimestamp ToTimestamp()
      The TO TIMESTAMP function.

      Parse a string-formatted timestamp value to a timestamp.

    • ToTimestamp

      public static final QOM.ToTimestamp ToTimestamp(Field<String> value, Field<String> formatMask)
      The TO TIMESTAMP function.

      Parse a string-formatted timestamp value to a timestamp.

    • Translate

      public static final QOM.Translate Translate()
      The TRANSLATE function.

      Translate a set of characters to another set of characters in a string.

    • Translate

      public static final QOM.Translate Translate(Field<String> string, Field<String> from, Field<String> to)
      The TRANSLATE function.

      Translate a set of characters to another set of characters in a string.

    • Trim

      public static final QOM.Trim Trim()
      The TRIM function.

      Trim characters (whitespace as default) from both sides of a string.

    • Trim

      public static final QOM.Trim Trim(Field<String> string, Field<String> characters)
      The TRIM function.

      Trim characters (whitespace as default) from both sides of a string.

    • Upper

      public static final QOM.Upper Upper()
      The UPPER function.

      Turn a string into upper case.

    • Upper

      public static final QOM.Upper Upper(Field<String> string)
      The UPPER function.

      Turn a string into upper case.

    • Uuid

      public static final QOM.Uuid Uuid()
      The UUID function.

      Generate a random UUID.

    • BinaryBitLength

      public static final QOM.BinaryBitLength BinaryBitLength()
      The BINARY BIT LENGTH function.

      The length of a binary string in bits.

    • BinaryBitLength

      public static final QOM.BinaryBitLength BinaryBitLength(Field<byte[]> bytes)
      The BINARY BIT LENGTH function.

      The length of a binary string in bits.

    • BinaryConcat

      public static final QOM.BinaryConcat BinaryConcat()
      The BINARY CONCAT function.

      The concatenation of binary strings.

    • BinaryConcat

      public static final QOM.BinaryConcat BinaryConcat(Field<byte[]> bytes1, Field<byte[]> bytes2)
      The BINARY CONCAT function.

      The concatenation of binary strings.

    • BinaryLength

      public static final QOM.BinaryLength BinaryLength()
      The BINARY LENGTH function.

      The length of a binary string in bytes.

    • BinaryLength

      public static final QOM.BinaryLength BinaryLength(Field<byte[]> bytes)
      The BINARY LENGTH function.

      The length of a binary string in bytes.

    • BinaryLtrim

      public static final QOM.BinaryLtrim BinaryLtrim()
      The BINARY LTRIM function.

      Trim bytes from the left side of a binary string.

    • BinaryLtrim

      public static final QOM.BinaryLtrim BinaryLtrim(Field<byte[]> bytes, Field<byte[]> characters)
      The BINARY LTRIM function.

      Trim bytes from the left side of a binary string.

    • BinaryMd5

      public static final QOM.BinaryMd5 BinaryMd5()
      The BINARY MD5 function.

      Calculate an MD5 hash from a binary string.

    • BinaryMd5

      public static final QOM.BinaryMd5 BinaryMd5(Field<byte[]> bytes)
      The BINARY MD5 function.

      Calculate an MD5 hash from a binary string.

    • BinaryOctetLength

      public static final QOM.BinaryOctetLength BinaryOctetLength()
      The BINARY OCTET LENGTH function.

      The length of a binary string in octets.

    • BinaryOctetLength

      public static final QOM.BinaryOctetLength BinaryOctetLength(Field<byte[]> bytes)
      The BINARY OCTET LENGTH function.

      The length of a binary string in octets.

    • BinaryOverlay

      public static final QOM.BinaryOverlay BinaryOverlay()
      The BINARY OVERLAY function.

      Place a binary string on top of another binary string, replacing the original contents.

    • BinaryOverlay

      public static final QOM.BinaryOverlay BinaryOverlay(Field<byte[]> in, Field<byte[]> placing, Field<? extends Number> startIndex, Field<? extends Number> length)
      The BINARY OVERLAY function.

      Place a binary string on top of another binary string, replacing the original contents.

    • BinaryPosition

      public static final QOM.BinaryPosition BinaryPosition()
      The BINARY POSITION function.

      Search the position (1-based) of a substring in another string.

    • BinaryPosition

      public static final QOM.BinaryPosition BinaryPosition(Field<byte[]> in, Field<byte[]> search, Field<? extends Number> startIndex)
      The BINARY POSITION function.

      Search the position (1-based) of a substring in another string.

    • BinaryRtrim

      public static final QOM.BinaryRtrim BinaryRtrim()
      The BINARY RTRIM function.

      Trim bytes from the right side of a binary string.

    • BinaryRtrim

      public static final QOM.BinaryRtrim BinaryRtrim(Field<byte[]> bytes, Field<byte[]> characters)
      The BINARY RTRIM function.

      Trim bytes from the right side of a binary string.

    • BinarySubstring

      public static final QOM.BinarySubstring BinarySubstring()
      The BINARY SUBSTRING function.

      Get a substring of a binary string, from a given position.

    • BinarySubstring

      public static final QOM.BinarySubstring BinarySubstring(Field<byte[]> string, Field<? extends Number> startingPosition, Field<? extends Number> length)
      The BINARY SUBSTRING function.

      Get a substring of a binary string, from a given position.

    • BinaryTrim

      public static final QOM.BinaryTrim BinaryTrim()
      The BINARY TRIM function.

      Trim characters from both sides of a string.

    • BinaryTrim

      public static final QOM.BinaryTrim BinaryTrim(Field<byte[]> bytes, Field<byte[]> characters)
      The BINARY TRIM function.

      Trim characters from both sides of a string.

    • DateAdd

      public static final <T> QOM.DateAdd<T> DateAdd()
      The DATE ADD function.

      Add an interval to a date.

    • DateAdd

      public static final <T> QOM.DateAdd<T> DateAdd(Field<T> date, Field<? extends Number> interval, DatePart datePart)
      The DATE ADD function.

      Add an interval to a date.

    • Cardinality

      public static final QOM.Cardinality Cardinality()
      The CARDINALITY function.

      Calculate the cardinality of an array field.

    • Cardinality

      public static final QOM.Cardinality Cardinality(Field<? extends Object[]> array)
      The CARDINALITY function.

      Calculate the cardinality of an array field.

    • ArrayGet

      public static final <T> QOM.ArrayGet<T> ArrayGet()
      The ARRAY GET function.

      Get an array element at a given index (1 based).

    • ArrayGet

      public static final <T> QOM.ArrayGet<T> ArrayGet(Field<T[]> array, Field<Integer> index)
      The ARRAY GET function.

      Get an array element at a given index (1 based).

    • ArrayConcat

      public static final <T> QOM.ArrayConcat<T> ArrayConcat()
      The ARRAY CONCAT function.

      Concatenate two arrays.

    • ArrayConcat

      public static final <T> QOM.ArrayConcat<T> ArrayConcat(Field<T[]> arg1, Field<T[]> arg2)
      The ARRAY CONCAT function.

      Concatenate two arrays.

    • ArrayAppend

      public static final <T> QOM.ArrayAppend<T> ArrayAppend()
      The ARRAY APPEND function.

      Append an element to an array.

    • ArrayAppend

      public static final <T> QOM.ArrayAppend<T> ArrayAppend(Field<T[]> arg1, Field<T> arg2)
      The ARRAY APPEND function.

      Append an element to an array.

    • ArrayPrepend

      public static final <T> QOM.ArrayPrepend<T> ArrayPrepend()
      The ARRAY PREPEND function.

      Prepend an element to an array.

    • ArrayPrepend

      public static final <T> QOM.ArrayPrepend<T> ArrayPrepend(Field<T> arg1, Field<T[]> arg2)
      The ARRAY PREPEND function.

      Prepend an element to an array.

    • ArrayOverlap

      public static final <T> QOM.ArrayOverlap<T> ArrayOverlap()
      The ARRAY OVERLAP function.

      Check if 2 arrays overlap.

    • ArrayOverlap

      public static final <T> QOM.ArrayOverlap<T> ArrayOverlap(Field<T[]> arg1, Field<T[]> arg2)
      The ARRAY OVERLAP function.

      Check if 2 arrays overlap.

    • ArrayRemove

      public static final <T> QOM.ArrayRemove<T> ArrayRemove()
      The ARRAY REMOVE function.

      Remove an element from an array.

    • ArrayRemove

      public static final <T> QOM.ArrayRemove<T> ArrayRemove(Field<T[]> arg1, Field<T> arg2)
      The ARRAY REMOVE function.

      Remove an element from an array.

    • ArrayReplace

      public static final <T> QOM.ArrayReplace<T> ArrayReplace()
      The ARRAY REPLACE function.

      Replace an element in an array.

    • ArrayReplace

      public static final <T> QOM.ArrayReplace<T> ArrayReplace(Field<T[]> arg1, Field<T> arg2, Field<T> arg3)
      The ARRAY REPLACE function.

      Replace an element in an array.

    • Nvl

      public static final <T> QOM.Nvl<T> Nvl()
      The NVL function.

      Return the first non-null argument.

    • Nvl

      public static final <T> QOM.Nvl<T> Nvl(Field<T> value, Field<T> defaultValue)
      The NVL function.

      Return the first non-null argument.

    • Nullif

      public static final <T> QOM.Nullif<T> Nullif()
      The NULLIF function.
    • Nullif

      public static final <T> QOM.Nullif<T> Nullif(Field<T> value, Field<T> other)
      The NULLIF function.
    • TryCast

      public static final <T> QOM.TryCast<T> TryCast()
      The TRY CAST function.
    • TryCast

      public static final <T> QOM.TryCast<T> TryCast(Field<?> value, DataType<T> dataType)
      The TRY CAST function.
    • CurrentCatalog

      public static final QOM.CurrentCatalog CurrentCatalog()
      The CURRENT CATALOG function.

      The CURRENT_CATALOG of the current session

    • CurrentSchema

      public static final QOM.CurrentSchema CurrentSchema()
      The CURRENT SCHEMA function.

      The CURRENT_SCHEMA of the current session

    • CurrentUser

      public static final QOM.CurrentUser CurrentUser()
      The CURRENT USER function.

      The CURRENT_USER of the current session with the database

    • ConnectByIsCycle

      @Pro public static final QOM.ConnectByIsCycle ConnectByIsCycle()
      The CONNECT BY ISCYCLE function.

      The CONNECT_BY_ISCYCLE pseudo column is used with the Oracle style CONNECT BY clause.

    • ConnectByIsLeaf

      @Pro public static final QOM.ConnectByIsLeaf ConnectByIsLeaf()
      The CONNECT BY ISLEAF function.

      The CONNECT_BY_ISLEAF pseudo column is used with the Oracle style CONNECT BY clause.

    • ConnectByRoot

      @Pro public static final <T> QOM.ConnectByRoot<T> ConnectByRoot()
      The CONNECT BY ROOT function.

      The CONNECT_BY_ROOT operator is used with the Oracle style CONNECT BY clause.

    • ConnectByRoot

      @Pro public static final <T> QOM.ConnectByRoot<T> ConnectByRoot(Field<T> field)
      The CONNECT BY ROOT function.

      The CONNECT_BY_ROOT operator is used with the Oracle style CONNECT BY clause.

    • Level

      @Pro public static final QOM.Level Level()
      The LEVEL function.

      The LEVEL pseudo column is used with the Oracle style CONNECT BY clause.

    • Prior

      @Pro public static final <T> QOM.Prior<T> Prior()
      The PRIOR function.

      The PRIOR operator is used with the Oracle style CONNECT BY clause.

    • Prior

      @Pro public static final <T> QOM.Prior<T> Prior(Field<T> field)
      The PRIOR function.

      The PRIOR operator is used with the Oracle style CONNECT BY clause.

    • SysConnectByPath

      @Pro public static final QOM.SysConnectByPath SysConnectByPath()
      The SYS CONNECT BY PATH function.

      The SYS_CONNECT_BY_PATH function is used with the Oracle style CONNECT BY clause.

    • SysConnectByPath

      @Pro public static final QOM.SysConnectByPath SysConnectByPath(Field<?> field, String separator)
      The SYS CONNECT BY PATH function.

      The SYS_CONNECT_BY_PATH function is used with the Oracle style CONNECT BY clause.

    • Rownum

      @Pro public static final QOM.Rownum Rownum()
      The ROWNUM function.

      Depending on its usage, the Oracle-specific ROWNUM pseudo-field can be emulated using LIMIT or ROW_NUMBER().

    • PlusJoin

      @Pro public static final <T> QOM.PlusJoin<T> PlusJoin()
      The PLUS operator.

      Turn this field into an Oracle-specific field for use in outer-join predicates. It can be emulated using Settings.isTransformTableListsToAnsiJoin().

      Example:

      
       TABLE1.COL.plus().eq(TABLE2.COL);
       TABLE1.COL.eq(TABLE2.COL.plus());
       

      The above will generate

      
       TABLE1.COL(+) = TABLE2.COL
       TABLE1.COL = TABLE2.COL(+)
       
    • PlusJoin

      @Pro public static final <T> QOM.PlusJoin<T> PlusJoin(Field<T> field)
      The PLUS operator.

      Turn this field into an Oracle-specific field for use in outer-join predicates. It can be emulated using Settings.isTransformTableListsToAnsiJoin().

      Example:

      
       TABLE1.COL.plus().eq(TABLE2.COL);
       TABLE1.COL.eq(TABLE2.COL.plus());
       

      The above will generate

      
       TABLE1.COL(+) = TABLE2.COL
       TABLE1.COL = TABLE2.COL(+)
       
    • XMLComment

      public static final QOM.XMLComment XMLComment()
      The XMLCOMMENT function.
    • XMLComment

      public static final QOM.XMLComment XMLComment(Field<String> comment)
      The XMLCOMMENT function.
    • XMLConcat

      public static final QOM.XMLConcat XMLConcat()
      The XMLCONCAT function.
    • XMLConcat

      public static final QOM.XMLConcat XMLConcat(Collection<? extends Field<?>> args)
      The XMLCONCAT function.
    • XMLDocument

      @Pro public static final QOM.XMLDocument XMLDocument()
      The XMLDOCUMENT function.
    • XMLDocument

      @Pro public static final QOM.XMLDocument XMLDocument(Field<XML> content)
      The XMLDOCUMENT function.
    • XMLForest

      public static final QOM.XMLForest XMLForest()
      The XMLFOREST function.
    • XMLForest

      public static final QOM.XMLForest XMLForest(Collection<? extends Field<?>> fields)
      The XMLFOREST function.
    • XMLPi

      public static final QOM.XMLPi XMLPi()
      The XMLPI function.
    • XMLPi

      public static final QOM.XMLPi XMLPi(Name target, Field<?> content)
      The XMLPI function.
    • XMLSerialize

      public static final <T> QOM.XMLSerialize<T> XMLSerialize()
      The XMLSERIALIZE function.
    • XMLSerialize

      public static final <T> QOM.XMLSerialize<T> XMLSerialize(boolean content, Field<XML> value, DataType<T> type)
      The XMLSERIALIZE function.
    • JSONArray

      public static final <T> QOM.JSONArray<T> JSONArray()
      The JSON ARRAY function.
    • JSONArray

      public static final <T> QOM.JSONArray<T> JSONArray(DataType<T> type, Collection<? extends Field<?>> fields, QOM.JSONOnNull onNull, DataType<?> returning)
      The JSON ARRAY function.
    • JSONObject

      public static final <T> QOM.JSONObject<T> JSONObject()
      The JSON OBJECT function.
    • JSONObject

      public static final <T> QOM.JSONObject<T> JSONObject(DataType<T> type, Collection<? extends JSONEntry<?>> entries, QOM.JSONOnNull onNull, DataType<?> returning)
      The JSON OBJECT function.
    • JSONGetElement

      public static final QOM.JSONGetElement JSONGetElement()
      The JSON GET ELEMENT function.

      Access an array element from a JSON array expression.

    • JSONGetElement

      public static final QOM.JSONGetElement JSONGetElement(Field<JSON> field, Field<Integer> index)
      The JSON GET ELEMENT function.

      Access an array element from a JSON array expression.

    • JSONBGetElement

      public static final QOM.JSONBGetElement JSONBGetElement()
      The JSONB GET ELEMENT function.

      Access an array element from a JSONB array expression.

    • JSONBGetElement

      public static final QOM.JSONBGetElement JSONBGetElement(Field<JSONB> field, Field<Integer> index)
      The JSONB GET ELEMENT function.

      Access an array element from a JSONB array expression.

    • JSONGetElementAsText

      public static final QOM.JSONGetElementAsText JSONGetElementAsText()
      The JSON GET ELEMENT AS TEXT function.

      Access an array element from a JSON array expression and return it as a string.

    • JSONGetElementAsText

      public static final QOM.JSONGetElementAsText JSONGetElementAsText(Field<JSON> field, Field<Integer> index)
      The JSON GET ELEMENT AS TEXT function.

      Access an array element from a JSON array expression and return it as a string.

    • JSONBGetElementAsText

      public static final QOM.JSONBGetElementAsText JSONBGetElementAsText()
      The JSONB GET ELEMENT AS TEXT function.

      Access an array element from a JSONB array expression and return it as a string.

    • JSONBGetElementAsText

      public static final QOM.JSONBGetElementAsText JSONBGetElementAsText(Field<JSONB> field, Field<Integer> index)
      The JSONB GET ELEMENT AS TEXT function.

      Access an array element from a JSONB array expression and return it as a string.

    • JSONGetAttribute

      public static final QOM.JSONGetAttribute JSONGetAttribute()
      The JSON GET ATTRIBUTE function.

      Access an object attribute value from a JSON object expression.

    • JSONGetAttribute

      public static final QOM.JSONGetAttribute JSONGetAttribute(Field<JSON> field, Field<String> attribute)
      The JSON GET ATTRIBUTE function.

      Access an object attribute value from a JSON object expression.

    • JSONBGetAttribute

      public static final QOM.JSONBGetAttribute JSONBGetAttribute()
      The JSONB GET ATTRIBUTE function.

      Access an object attribute value from a JSONB object expression.

    • JSONBGetAttribute

      public static final QOM.JSONBGetAttribute JSONBGetAttribute(Field<JSONB> field, Field<String> attribute)
      The JSONB GET ATTRIBUTE function.

      Access an object attribute value from a JSONB object expression.

    • JSONGetAttributeAsText

      public static final QOM.JSONGetAttributeAsText JSONGetAttributeAsText()
      The JSON GET ATTRIBUTE AS TEXT function.

      Access an object attribute value from a JSON object expression and return it as string.

    • JSONGetAttributeAsText

      public static final QOM.JSONGetAttributeAsText JSONGetAttributeAsText(Field<JSON> field, Field<String> attribute)
      The JSON GET ATTRIBUTE AS TEXT function.

      Access an object attribute value from a JSON object expression and return it as string.

    • JSONBGetAttributeAsText

      public static final QOM.JSONBGetAttributeAsText JSONBGetAttributeAsText()
      The JSONB GET ATTRIBUTE AS TEXT function.

      Access an object attribute value from a JSONB object expression and return it as string.

    • JSONBGetAttributeAsText

      public static final QOM.JSONBGetAttributeAsText JSONBGetAttributeAsText(Field<JSONB> field, Field<String> attribute)
      The JSONB GET ATTRIBUTE AS TEXT function.

      Access an object attribute value from a JSONB object expression and return it as string.

    • JSONArrayLength

      public static final QOM.JSONArrayLength JSONArrayLength()
      The JSON ARRAY LENGTH function.

      Calculate the length of a JSON array.

    • JSONArrayLength

      public static final QOM.JSONArrayLength JSONArrayLength(Field<JSON> field)
      The JSON ARRAY LENGTH function.

      Calculate the length of a JSON array.

    • JSONBArrayLength

      public static final QOM.JSONBArrayLength JSONBArrayLength()
      The JSONB ARRAY LENGTH function.

      Calculate the length of a JSONB array.

    • JSONBArrayLength

      public static final QOM.JSONBArrayLength JSONBArrayLength(Field<JSONB> field)
      The JSONB ARRAY LENGTH function.

      Calculate the length of a JSONB array.

    • JSONKeys

      public static final QOM.JSONKeys JSONKeys()
      The JSON KEYS function.

      Retrieve all keys from a JSON object as an array of strings.

    • JSONKeys

      public static final QOM.JSONKeys JSONKeys(Field<JSON> field)
      The JSON KEYS function.

      Retrieve all keys from a JSON object as an array of strings.

    • JSONBKeys

      public static final QOM.JSONBKeys JSONBKeys()
      The JSONB KEYS function.

      Retrieve all keys from a JSONB object as an array of strings.

    • JSONBKeys

      public static final QOM.JSONBKeys JSONBKeys(Field<JSONB> field)
      The JSONB KEYS function.

      Retrieve all keys from a JSONB object as an array of strings.

    • JSONSet

      public static final QOM.JSONSet JSONSet()
      The JSON SET function.

      Add or replace a JSON value to a JSON field at a given path.

    • JSONSet

      public static final QOM.JSONSet JSONSet(Field<JSON> field, Field<String> path, Field<?> value)
      The JSON SET function.

      Add or replace a JSON value to a JSON field at a given path.

    • JSONBSet

      public static final QOM.JSONBSet JSONBSet()
      The JSONB SET function.

      Add or replace a JSONB value to a JSONB field at a given path.

    • JSONBSet

      public static final QOM.JSONBSet JSONBSet(Field<JSONB> field, Field<String> path, Field<?> value)
      The JSONB SET function.

      Add or replace a JSONB value to a JSONB field at a given path.

    • JSONInsert

      public static final QOM.JSONInsert JSONInsert()
      The JSON INSERT function.

      Add (but not replace) a JSON value to a JSON field at a given path.

    • JSONInsert

      public static final QOM.JSONInsert JSONInsert(Field<JSON> field, Field<String> path, Field<?> value)
      The JSON INSERT function.

      Add (but not replace) a JSON value to a JSON field at a given path.

    • JSONBInsert

      public static final QOM.JSONBInsert JSONBInsert()
      The JSONB INSERT function.

      Add (but not replace) a JSON value to a JSON field at a given path.

    • JSONBInsert

      public static final QOM.JSONBInsert JSONBInsert(Field<JSONB> field, Field<String> path, Field<?> value)
      The JSONB INSERT function.

      Add (but not replace) a JSON value to a JSON field at a given path.

    • JSONReplace

      public static final QOM.JSONReplace JSONReplace()
      The JSON REPLACE function.

      Replace (but not add) a JSON value to a JSON field at a given path.

    • JSONReplace

      public static final QOM.JSONReplace JSONReplace(Field<JSON> field, Field<String> path, Field<?> value)
      The JSON REPLACE function.

      Replace (but not add) a JSON value to a JSON field at a given path.

    • JSONBReplace

      public static final QOM.JSONBReplace JSONBReplace()
      The JSONB REPLACE function.

      Replace (but not add) a JSONB value to a JSONB field at a given path.

    • JSONBReplace

      public static final QOM.JSONBReplace JSONBReplace(Field<JSONB> field, Field<String> path, Field<?> value)
      The JSONB REPLACE function.

      Replace (but not add) a JSONB value to a JSONB field at a given path.

    • JSONRemove

      public static final QOM.JSONRemove JSONRemove()
      The JSON REMOVE function.

      Remove a JSON value from a JSON field at a given path.

    • JSONRemove

      public static final QOM.JSONRemove JSONRemove(Field<JSON> field, Field<String> path)
      The JSON REMOVE function.

      Remove a JSON value from a JSON field at a given path.

    • JSONBRemove

      public static final QOM.JSONBRemove JSONBRemove()
      The JSONB REMOVE function.

      Remove a JSONB value from a JSONB field at a given path.

    • JSONBRemove

      public static final QOM.JSONBRemove JSONBRemove(Field<JSONB> field, Field<String> path)
      The JSONB REMOVE function.

      Remove a JSONB value from a JSONB field at a given path.

    • Deleting

      @Pro public static final QOM.Deleting Deleting()
      The DELETING function.
    • Inserting

      @Pro public static final QOM.Inserting Inserting()
      The INSERTING function.
    • Updating

      @Pro public static final QOM.Updating Updating()
      The UPDATING function.
    • ConditionAsField

      public static final QOM.ConditionAsField ConditionAsField()
      The FIELD function.

      Wrap a condition in a boolean field.

    • ConditionAsField

      public static final QOM.ConditionAsField ConditionAsField(Condition condition)
      The FIELD function.

      Wrap a condition in a boolean field.

    • FieldCondition

      public static final QOM.FieldCondition FieldCondition()
      The CONDITION function.

      Create a condition from a boolean field.

      Databases that support boolean data types can use boolean expressions as predicates or as columns interchangeably. This extends to any type of field, including functions. A Postgres example:

      
       select 1 where texteq('a', 'a');
       
    • FieldCondition

      public static final QOM.FieldCondition FieldCondition(Field<Boolean> field)
      The CONDITION function.

      Create a condition from a boolean field.

      Databases that support boolean data types can use boolean expressions as predicates or as columns interchangeably. This extends to any type of field, including functions. A Postgres example:

      
       select 1 where texteq('a', 'a');
       
    • AnyValue

      public static final <T> QOM.AnyValue<T> AnyValue()
      The ANY VALUE function.

      Get any arbitrary value from the group.

    • AnyValue

      public static final <T> QOM.AnyValue<T> AnyValue(Field<T> field)
      The ANY VALUE function.

      Get any arbitrary value from the group.

    • Avg

      public static final QOM.Avg Avg()
      The AVG function.
    • Avg

      public static final QOM.Avg Avg(Field<? extends Number> field, boolean distinct)
      The AVG function.
    • BitAndAgg

      public static final <T extends Number> QOM.BitAndAgg<T> BitAndAgg()
      The BIT AND AGG function.

      Calculate the bitwise AND aggregate value.

    • BitAndAgg

      public static final <T extends Number> QOM.BitAndAgg<T> BitAndAgg(Field<T> value)
      The BIT AND AGG function.

      Calculate the bitwise AND aggregate value.

    • BitOrAgg

      public static final <T extends Number> QOM.BitOrAgg<T> BitOrAgg()
      The BIT OR AGG function.

      Calculate the bitwise OR aggregate value.

    • BitOrAgg

      public static final <T extends Number> QOM.BitOrAgg<T> BitOrAgg(Field<T> value)
      The BIT OR AGG function.

      Calculate the bitwise OR aggregate value.

    • BitXorAgg

      public static final <T extends Number> QOM.BitXorAgg<T> BitXorAgg()
      The BIT XOR AGG function.

      Calculate the bitwise XOR aggregate value.

    • BitXorAgg

      public static final <T extends Number> QOM.BitXorAgg<T> BitXorAgg(Field<T> value)
      The BIT XOR AGG function.

      Calculate the bitwise XOR aggregate value.

    • BitNandAgg

      public static final <T extends Number> QOM.BitNandAgg<T> BitNandAgg()
      The BIT NAND AGG function.

      Calculate the bitwise NAND aggregate value.

    • BitNandAgg

      public static final <T extends Number> QOM.BitNandAgg<T> BitNandAgg(Field<T> value)
      The BIT NAND AGG function.

      Calculate the bitwise NAND aggregate value.

    • BitNorAgg

      public static final <T extends Number> QOM.BitNorAgg<T> BitNorAgg()
      The BIT NOR AGG function.

      Calculate the bitwise NOR aggregate value.

    • BitNorAgg

      public static final <T extends Number> QOM.BitNorAgg<T> BitNorAgg(Field<T> value)
      The BIT NOR AGG function.

      Calculate the bitwise NOR aggregate value.

    • BitXNorAgg

      public static final <T extends Number> QOM.BitXNorAgg<T> BitXNorAgg()
      The BIT X NOR AGG function.

      Calculate the bitwise XNOR aggregate value.

    • BitXNorAgg

      public static final <T extends Number> QOM.BitXNorAgg<T> BitXNorAgg(Field<T> value)
      The BIT X NOR AGG function.

      Calculate the bitwise XNOR aggregate value.

    • BoolAnd

      public static final QOM.BoolAnd BoolAnd()
      The BOOL AND function.
    • BoolAnd

      public static final QOM.BoolAnd BoolAnd(Condition condition)
      The BOOL AND function.
    • BoolOr

      public static final QOM.BoolOr BoolOr()
      The BOOL OR function.
    • BoolOr

      public static final QOM.BoolOr BoolOr(Condition condition)
      The BOOL OR function.
    • Corr

      public static final QOM.Corr Corr()
      The CORR function.

      Calculate the correlation coefficient. This standard SQL function may be supported natively, or emulated using DSL.covarPop(Field, Field) and DSL.stddevPop(Field). If an emulation is applied, beware of the risk of "Catastrophic cancellation" in case the calculations are performed using floating point arithmetic.

    • Corr

      public static final QOM.Corr Corr(Field<? extends Number> y, Field<? extends Number> x)
      The CORR function.

      Calculate the correlation coefficient. This standard SQL function may be supported natively, or emulated using DSL.covarPop(Field, Field) and DSL.stddevPop(Field). If an emulation is applied, beware of the risk of "Catastrophic cancellation" in case the calculations are performed using floating point arithmetic.

    • Count

      public static final QOM.Count Count()
      The COUNT function.
    • Count

      public static final QOM.Count Count(Field<?> field, boolean distinct)
      The COUNT function.
    • CovarSamp

      public static final QOM.CovarSamp CovarSamp()
      The COVAR SAMP function.

      Calculate the sample covariance. This standard SQL function may be supported natively, or emulated using DSL.sum(Field) and DSL.count(Field). If an emulation is applied, beware of the risk of "Catastrophic cancellation" in case the calculations are performed using floating point arithmetic.

    • CovarSamp

      public static final QOM.CovarSamp CovarSamp(Field<? extends Number> y, Field<? extends Number> x)
      The COVAR SAMP function.

      Calculate the sample covariance. This standard SQL function may be supported natively, or emulated using DSL.sum(Field) and DSL.count(Field). If an emulation is applied, beware of the risk of "Catastrophic cancellation" in case the calculations are performed using floating point arithmetic.

    • CovarPop

      public static final QOM.CovarPop CovarPop()
      The COVAR POP function.

      Calculate the population covariance. This standard SQL function may be supported natively, or emulated using DSL.sum(Field) and DSL.count(Field). If an emulation is applied, beware of the risk of "Catastrophic cancellation" in case the calculations are performed using floating point arithmetic.

    • CovarPop

      public static final QOM.CovarPop CovarPop(Field<? extends Number> y, Field<? extends Number> x)
      The COVAR POP function.

      Calculate the population covariance. This standard SQL function may be supported natively, or emulated using DSL.sum(Field) and DSL.count(Field). If an emulation is applied, beware of the risk of "Catastrophic cancellation" in case the calculations are performed using floating point arithmetic.

    • Max

      public static final <T> QOM.Max<T> Max()
      The MAX function.
    • Max

      public static final <T> QOM.Max<T> Max(Field<T> field, boolean distinct)
      The MAX function.
    • Median

      public static final QOM.Median Median()
      The MEDIAN function.
    • Median

      public static final QOM.Median Median(Field<? extends Number> field)
      The MEDIAN function.
    • Min

      public static final <T> QOM.Min<T> Min()
      The MIN function.
    • Min

      public static final <T> QOM.Min<T> Min(Field<T> field, boolean distinct)
      The MIN function.
    • Product

      public static final QOM.Product Product()
      The PRODUCT function.

      Get the sum over a numeric field: product(distinct field).

      Few dialects currently support multiplicative aggregation natively. jOOQ emulates this using exp(sum(log(arg))) for strictly positive numbers, and does some additional handling for zero and negative numbers.

      Note that this implementation may introduce rounding errors, even for integer multiplication.

      More information here: https://blog.jooq.org/how-to-write-a-multiplication-aggregate-function-in-sql.

    • Product

      public static final QOM.Product Product(Field<? extends Number> field, boolean distinct)
      The PRODUCT function.

      Get the sum over a numeric field: product(distinct field).

      Few dialects currently support multiplicative aggregation natively. jOOQ emulates this using exp(sum(log(arg))) for strictly positive numbers, and does some additional handling for zero and negative numbers.

      Note that this implementation may introduce rounding errors, even for integer multiplication.

      More information here: https://blog.jooq.org/how-to-write-a-multiplication-aggregate-function-in-sql.

    • RegrAvgX

      public static final QOM.RegrAvgX RegrAvgX()
      The REGR AVGX function.

      Calculate the average of the independent values (x). This standard SQL function may be supported natively, or emulated using DSL.sum(Field) and DSL.count(Field). If an emulation is applied, beware of the risk of "Catastrophic cancellation" in case the calculations are performed using floating point arithmetic.

    • RegrAvgX

      public static final QOM.RegrAvgX RegrAvgX(Field<? extends Number> y, Field<? extends Number> x)
      The REGR AVGX function.

      Calculate the average of the independent values (x). This standard SQL function may be supported natively, or emulated using DSL.sum(Field) and DSL.count(Field). If an emulation is applied, beware of the risk of "Catastrophic cancellation" in case the calculations are performed using floating point arithmetic.

    • RegrAvgY

      public static final QOM.RegrAvgY RegrAvgY()
      The REGR AVGY function.

      Calculate the average of the dependent values (y). This standard SQL function may be supported natively, or emulated using DSL.sum(Field) and DSL.count(Field). If an emulation is applied, beware of the risk of "Catastrophic cancellation" in case the calculations are performed using floating point arithmetic.

    • RegrAvgY

      public static final QOM.RegrAvgY RegrAvgY(Field<? extends Number> y, Field<? extends Number> x)
      The REGR AVGY function.

      Calculate the average of the dependent values (y). This standard SQL function may be supported natively, or emulated using DSL.sum(Field) and DSL.count(Field). If an emulation is applied, beware of the risk of "Catastrophic cancellation" in case the calculations are performed using floating point arithmetic.

    • RegrCount

      public static final QOM.RegrCount RegrCount()
      The REGR COUNT function.

      Calculate the number of non-NULL pairs. This standard SQL function may be supported natively, or emulated using DSL.sum(Field) and DSL.count(Field). If an emulation is applied, beware of the risk of "Catastrophic cancellation" in case the calculations are performed using floating point arithmetic.

    • RegrCount

      public static final QOM.RegrCount RegrCount(Field<? extends Number> y, Field<? extends Number> x)
      The REGR COUNT function.

      Calculate the number of non-NULL pairs. This standard SQL function may be supported natively, or emulated using DSL.sum(Field) and DSL.count(Field). If an emulation is applied, beware of the risk of "Catastrophic cancellation" in case the calculations are performed using floating point arithmetic.

    • RegrIntercept

      public static final QOM.RegrIntercept RegrIntercept()
      The REGR INTERCEPT function.

      Calculate the y intercept of the regression line. This standard SQL function may be supported natively, or emulated using DSL.sum(Field) and DSL.count(Field). If an emulation is applied, beware of the risk of "Catastrophic cancellation" in case the calculations are performed using floating point arithmetic.

    • RegrIntercept

      public static final QOM.RegrIntercept RegrIntercept(Field<? extends Number> y, Field<? extends Number> x)
      The REGR INTERCEPT function.

      Calculate the y intercept of the regression line. This standard SQL function may be supported natively, or emulated using DSL.sum(Field) and DSL.count(Field). If an emulation is applied, beware of the risk of "Catastrophic cancellation" in case the calculations are performed using floating point arithmetic.

    • RegrR2

      public static final QOM.RegrR2 RegrR2()
      The REGR R2 function.

      Calculate the coefficient of determination. This standard SQL function may be supported natively, or emulated using DSL.sum(Field) and DSL.count(Field). If an emulation is applied, beware of the risk of "Catastrophic cancellation" in case the calculations are performed using floating point arithmetic.

    • RegrR2

      public static final QOM.RegrR2 RegrR2(Field<? extends Number> y, Field<? extends Number> x)
      The REGR R2 function.

      Calculate the coefficient of determination. This standard SQL function may be supported natively, or emulated using DSL.sum(Field) and DSL.count(Field). If an emulation is applied, beware of the risk of "Catastrophic cancellation" in case the calculations are performed using floating point arithmetic.

    • RegrSlope

      public static final QOM.RegrSlope RegrSlope()
      The REGR SLOPE function.

      Calculate the slope of the regression line. This standard SQL function may be supported natively, or emulated using DSL.sum(Field) and DSL.count(Field). If an emulation is applied, beware of the risk of "Catastrophic cancellation" in case the calculations are performed using floating point arithmetic.

    • RegrSlope

      public static final QOM.RegrSlope RegrSlope(Field<? extends Number> y, Field<? extends Number> x)
      The REGR SLOPE function.

      Calculate the slope of the regression line. This standard SQL function may be supported natively, or emulated using DSL.sum(Field) and DSL.count(Field). If an emulation is applied, beware of the risk of "Catastrophic cancellation" in case the calculations are performed using floating point arithmetic.

    • RegrSxx

      public static final QOM.RegrSxx RegrSxx()
      The REGR SXX function.

      Calculate the REGR_SXX auxiliary function. This standard SQL function may be supported natively, or emulated using DSL.sum(Field) and DSL.count(Field). If an emulation is applied, beware of the risk of "Catastrophic cancellation" in case the calculations are performed using floating point arithmetic.

    • RegrSxx

      public static final QOM.RegrSxx RegrSxx(Field<? extends Number> y, Field<? extends Number> x)
      The REGR SXX function.

      Calculate the REGR_SXX auxiliary function. This standard SQL function may be supported natively, or emulated using DSL.sum(Field) and DSL.count(Field). If an emulation is applied, beware of the risk of "Catastrophic cancellation" in case the calculations are performed using floating point arithmetic.

    • RegrSxy

      public static final QOM.RegrSxy RegrSxy()
      The REGR SXY function.

      Calculate the REGR_SXY auxiliary function. This standard SQL function may be supported natively, or emulated using DSL.sum(Field) and DSL.count(Field). If an emulation is applied, beware of the risk of "Catastrophic cancellation" in case the calculations are performed using floating point arithmetic.

    • RegrSxy

      public static final QOM.RegrSxy RegrSxy(Field<? extends Number> y, Field<? extends Number> x)
      The REGR SXY function.

      Calculate the REGR_SXY auxiliary function. This standard SQL function may be supported natively, or emulated using DSL.sum(Field) and DSL.count(Field). If an emulation is applied, beware of the risk of "Catastrophic cancellation" in case the calculations are performed using floating point arithmetic.

    • RegrSyy

      public static final QOM.RegrSyy RegrSyy()
      The REGR SYY function.

      Calculate the REGR_SYY auxiliary function. This standard SQL function may be supported natively, or emulated using DSL.sum(Field) and DSL.count(Field). If an emulation is applied, beware of the risk of "Catastrophic cancellation" in case the calculations are performed using floating point arithmetic.

    • RegrSyy

      public static final QOM.RegrSyy RegrSyy(Field<? extends Number> y, Field<? extends Number> x)
      The REGR SYY function.

      Calculate the REGR_SYY auxiliary function. This standard SQL function may be supported natively, or emulated using DSL.sum(Field) and DSL.count(Field). If an emulation is applied, beware of the risk of "Catastrophic cancellation" in case the calculations are performed using floating point arithmetic.

    • StddevPop

      public static final QOM.StddevPop StddevPop()
      The STDDEV POP function.

      Calculate the population standard deviation. This standard SQL function may be supported natively, or emulated using DSL.sum(Field) and DSL.count(Field). If an emulation is applied, beware of the risk of "Catastrophic cancellation" in case the calculations are performed using floating point arithmetic.

    • StddevPop

      public static final QOM.StddevPop StddevPop(Field<? extends Number> field)
      The STDDEV POP function.

      Calculate the population standard deviation. This standard SQL function may be supported natively, or emulated using DSL.sum(Field) and DSL.count(Field). If an emulation is applied, beware of the risk of "Catastrophic cancellation" in case the calculations are performed using floating point arithmetic.

    • StddevSamp

      public static final QOM.StddevSamp StddevSamp()
      The STDDEV SAMP function.

      Calculate the sample standard deviation. This standard SQL function may be supported natively, or emulated using DSL.sum(Field) and DSL.count(Field). If an emulation is applied, beware of the risk of "Catastrophic cancellation" in case the calculations are performed using floating point arithmetic.

    • StddevSamp

      public static final QOM.StddevSamp StddevSamp(Field<? extends Number> field)
      The STDDEV SAMP function.

      Calculate the sample standard deviation. This standard SQL function may be supported natively, or emulated using DSL.sum(Field) and DSL.count(Field). If an emulation is applied, beware of the risk of "Catastrophic cancellation" in case the calculations are performed using floating point arithmetic.

    • Sum

      public static final QOM.Sum Sum()
      The SUM function.
    • Sum

      public static final QOM.Sum Sum(Field<? extends Number> field, boolean distinct)
      The SUM function.
    • VarPop

      public static final QOM.VarPop VarPop()
      The VAR POP function.

      Calculate the population variance. This standard SQL function may be supported natively, or emulated using DSL.sum(Field) and DSL.count(Field). If an emulation is applied, beware of the risk of "Catastrophic cancellation" in case the calculations are performed using floating point arithmetic.

    • VarPop

      public static final QOM.VarPop VarPop(Field<? extends Number> field)
      The VAR POP function.

      Calculate the population variance. This standard SQL function may be supported natively, or emulated using DSL.sum(Field) and DSL.count(Field). If an emulation is applied, beware of the risk of "Catastrophic cancellation" in case the calculations are performed using floating point arithmetic.

    • VarSamp

      public static final QOM.VarSamp VarSamp()
      The VAR SAMP function.

      Calculate the sample variance. This standard SQL function may be supported natively, or emulated using DSL.sum(Field) and DSL.count(Field). If an emulation is applied, beware of the risk of "Catastrophic cancellation" in case the calculations are performed using floating point arithmetic.

    • VarSamp

      public static final QOM.VarSamp VarSamp(Field<? extends Number> field)
      The VAR SAMP function.

      Calculate the sample variance. This standard SQL function may be supported natively, or emulated using DSL.sum(Field) and DSL.count(Field). If an emulation is applied, beware of the risk of "Catastrophic cancellation" in case the calculations are performed using floating point arithmetic.

    • Goto

      @Pro public static final QOM.Goto Goto()
      The GOTO function.
    • Goto

      @Pro public static final QOM.Goto Goto(Label label)
      The GOTO function.
    • Execute

      @Pro public static final QOM.Execute Execute()
      The EXECUTE function.

      Execute a statement dynamically from within procedural code.

      Many dialects support some way of running procedural and SQL statements dynamically from within procedural code. For example, in Oracle, this syntax is required to run DDL statements from PL/SQL:

      
       BEGIN
         EXECUTE IMMEDIATE 'CREATE TABLE x (i INT)';
       END;
       
    • Execute

      @Pro public static final QOM.Execute Execute(Field<String> sql)
      The EXECUTE function.

      Execute a statement dynamically from within procedural code.

      Many dialects support some way of running procedural and SQL statements dynamically from within procedural code. For example, in Oracle, this syntax is required to run DDL statements from PL/SQL:

      
       BEGIN
         EXECUTE IMMEDIATE 'CREATE TABLE x (i INT)';
       END;
       
    • Return

      @Pro public static final QOM.Return Return()
      The RETURN_ function.
    • Return

      @Pro public static final QOM.Return Return(Field<?> value)
      The RETURN_ function.
    • Signal

      @Pro public static final QOM.Signal Signal()
      The SIGNAL SQL STATE function.
    • Signal

      @Pro public static final QOM.Signal Signal(Field<?> value, Field<String> messageText)
      The SIGNAL SQL STATE function.
    • StArea

      @Pro public static final QOM.StArea StArea()
      The ST AREA function.

      Calculate the area from a spatial type.

    • StArea

      @Pro public static final QOM.StArea StArea(Field<? extends Spatial> value)
      The ST AREA function.

      Calculate the area from a spatial type.

    • StAsBinary

      @Pro public static final QOM.StAsBinary StAsBinary()
      The ST ASBINARY function.

      Create a WKB representation from a spatial type.

    • StAsBinary

      @Pro public static final QOM.StAsBinary StAsBinary(Field<? extends Spatial> value)
      The ST ASBINARY function.

      Create a WKB representation from a spatial type.

    • StAsText

      @Pro public static final QOM.StAsText StAsText()
      The ST ASTEXT function.

      Create a text representation from a spatial type.

    • StAsText

      @Pro public static final QOM.StAsText StAsText(Field<? extends Spatial> value)
      The ST ASTEXT function.

      Create a text representation from a spatial type.

    • StCentroid

      @Pro public static final QOM.StCentroid StCentroid()
      The ST CENTROID function.

      Get the geometric center of a spatial value.

    • StCentroid

      @Pro public static final QOM.StCentroid StCentroid(Field<Geometry> value)
      The ST CENTROID function.

      Get the geometric center of a spatial value.

    • StContains

      @Pro public static final <T extends Spatial> QOM.StContains<T> StContains()
      The ST CONTAINS function.

      Check if a spatial value contains another.

    • StContains

      @Pro public static final <T extends Spatial> QOM.StContains<T> StContains(Field<T> arg1, Field<T> arg2)
      The ST CONTAINS function.

      Check if a spatial value contains another.

    • StCrosses

      @Pro public static final QOM.StCrosses StCrosses()
      The ST CROSSES function.

      Check if a geometry crosses another.

    • StCrosses

      @Pro public static final QOM.StCrosses StCrosses(Field<Geometry> arg1, Field<Geometry> arg2)
      The ST CROSSES function.

      Check if a geometry crosses another.

    • StDifference

      @Pro public static final <T extends Spatial> QOM.StDifference<T> StDifference()
      The ST DIFFERENCE function.

      Get the difference of two spatial values.

    • StDifference

      @Pro public static final <T extends Spatial> QOM.StDifference<T> StDifference(Field<T> arg1, Field<T> arg2)
      The ST DIFFERENCE function.

      Get the difference of two spatial values.

    • StDisjoint

      @Pro public static final <T extends Spatial> QOM.StDisjoint<T> StDisjoint()
      The ST DISJOINT function.

      Check if a spatial value is disjoint from another.

    • StDisjoint

      @Pro public static final <T extends Spatial> QOM.StDisjoint<T> StDisjoint(Field<T> arg1, Field<T> arg2)
      The ST DISJOINT function.

      Check if a spatial value is disjoint from another.

    • StDistance

      @Pro public static final <T extends Spatial> QOM.StDistance<T> StDistance()
      The ST DISTANCE function.

      Get the distance between two spatial values.

    • StDistance

      @Pro public static final <T extends Spatial> QOM.StDistance<T> StDistance(Field<T> arg1, Field<T> arg2)
      The ST DISTANCE function.

      Get the distance between two spatial values.

    • StEndPoint

      @Pro public static final <T extends Spatial> QOM.StEndPoint<T> StEndPoint()
      The ST ENDPOINT function.

      Get the end point of a spatial value.

    • StEndPoint

      @Pro public static final <T extends Spatial> QOM.StEndPoint<T> StEndPoint(Field<T> value)
      The ST ENDPOINT function.

      Get the end point of a spatial value.

    • StEquals

      @Pro public static final <T extends Spatial> QOM.StEquals<T> StEquals()
      The ST EQUALS function.

      Check if a spatial value is equal to another.

    • StEquals

      @Pro public static final <T extends Spatial> QOM.StEquals<T> StEquals(Field<T> arg1, Field<T> arg2)
      The ST EQUALS function.

      Check if a spatial value is equal to another.

    • StExteriorRing

      @Pro public static final QOM.StExteriorRing StExteriorRing()
      The ST EXTERIORRING function.

      Get the exterior ring of a spatial value.

    • StExteriorRing

      @Pro public static final QOM.StExteriorRing StExteriorRing(Field<Geometry> value)
      The ST EXTERIORRING function.

      Get the exterior ring of a spatial value.

    • StGeometryN

      @Pro public static final <T extends Spatial> QOM.StGeometryN<T> StGeometryN()
      The ST GEOMETRYN function.

      Get the N-th geometry from a collection of spatial values.

    • StGeometryN

      @Pro public static final <T extends Spatial> QOM.StGeometryN<T> StGeometryN(Field<T> value, Field<? extends Number> position)
      The ST GEOMETRYN function.

      Get the N-th geometry from a collection of spatial values.

    • StGeometryType

      @Pro public static final QOM.StGeometryType StGeometryType()
      The ST GEOMETRYTYPE function.

      Get the geometry type of a spatial value.

    • StGeometryType

      @Pro public static final QOM.StGeometryType StGeometryType(Field<? extends Spatial> value)
      The ST GEOMETRYTYPE function.

      Get the geometry type of a spatial value.

    • StGeomFromText

      @Pro public static final QOM.StGeomFromText StGeomFromText()
      The ST GEOMFROMTEXT function.

      Create a geometry from a text representation.

    • StGeomFromText

      @Pro public static final QOM.StGeomFromText StGeomFromText(Field<String> text, Field<? extends Number> srid)
      The ST GEOMFROMTEXT function.

      Create a geometry from a text representation.

    • StGeomFromWKB

      @Pro public static final QOM.StGeomFromWKB StGeomFromWKB()
      The ST GEOMFROMWKB function.

      Create a geometry from a binary representation.

    • StGeomFromWKB

      @Pro public static final QOM.StGeomFromWKB StGeomFromWKB(Field<byte[]> wkb, Field<? extends Number> srid)
      The ST GEOMFROMWKB function.

      Create a geometry from a binary representation.

    • StInteriorRingN

      @Pro public static final QOM.StInteriorRingN StInteriorRingN()
      The ST INTERIORRINGN function.

      Get the N-th interior ring of a spatial value.

    • StInteriorRingN

      @Pro public static final QOM.StInteriorRingN StInteriorRingN(Field<Geometry> value, Field<? extends Number> position)
      The ST INTERIORRINGN function.

      Get the N-th interior ring of a spatial value.

    • StIntersection

      @Pro public static final <T extends Spatial> QOM.StIntersection<T> StIntersection()
      The ST INTERSECTION function.

      Get the intersection of two spatial values.

    • StIntersection

      @Pro public static final <T extends Spatial> QOM.StIntersection<T> StIntersection(Field<T> arg1, Field<T> arg2)
      The ST INTERSECTION function.

      Get the intersection of two spatial values.

    • StIntersects

      @Pro public static final <T extends Spatial> QOM.StIntersects<T> StIntersects()
      The ST INTERSECTS function.

      Check whether two spatial values intersect.

    • StIntersects

      @Pro public static final <T extends Spatial> QOM.StIntersects<T> StIntersects(Field<T> arg1, Field<T> arg2)
      The ST INTERSECTS function.

      Check whether two spatial values intersect.

    • StIsClosed

      @Pro public static final QOM.StIsClosed StIsClosed()
      The ST ISCLOSED function.

      Check whether a spatial value is closed.

    • StIsClosed

      @Pro public static final QOM.StIsClosed StIsClosed(Field<? extends Spatial> value)
      The ST ISCLOSED function.

      Check whether a spatial value is closed.

    • StIsEmpty

      @Pro public static final QOM.StIsEmpty StIsEmpty()
      The ST ISEMPTY function.

      Check whether a spatial value is empty.

    • StIsEmpty

      @Pro public static final QOM.StIsEmpty StIsEmpty(Field<? extends Spatial> value)
      The ST ISEMPTY function.

      Check whether a spatial value is empty.

    • StLength

      @Pro public static final QOM.StLength StLength()
      The ST LENGTH function.

      Get the length of a spatial value.

    • StLength

      @Pro public static final QOM.StLength StLength(Field<? extends Spatial> value)
      The ST LENGTH function.

      Get the length of a spatial value.

    • StNumGeometries

      @Pro public static final QOM.StNumGeometries StNumGeometries()
      The ST NUMGEOMETRIES function.

      Get the number of geometries in a collection of spatial values.

    • StNumGeometries

      @Pro public static final QOM.StNumGeometries StNumGeometries(Field<? extends Spatial> value)
      The ST NUMGEOMETRIES function.

      Get the number of geometries in a collection of spatial values.

    • StNumInteriorRings

      @Pro public static final QOM.StNumInteriorRings StNumInteriorRings()
      The ST NUMINTERIORRING function.

      Get the number of interior rings of a spatial value.

    • StNumInteriorRings

      @Pro public static final QOM.StNumInteriorRings StNumInteriorRings(Field<Geometry> value)
      The ST NUMINTERIORRING function.

      Get the number of interior rings of a spatial value.

    • StNumPoints

      @Pro public static final QOM.StNumPoints StNumPoints()
      The ST NUMPOINTS function.

      Get the number of points in a spatial value.

    • StNumPoints

      @Pro public static final QOM.StNumPoints StNumPoints(Field<? extends Spatial> value)
      The ST NUMPOINTS function.

      Get the number of points in a spatial value.

    • StOverlaps

      @Pro public static final <T extends Spatial> QOM.StOverlaps<T> StOverlaps()
      The ST OVERLAPS function.

      Check whether two spatial values overlap.

    • StOverlaps

      @Pro public static final <T extends Spatial> QOM.StOverlaps<T> StOverlaps(Field<T> arg1, Field<T> arg2)
      The ST OVERLAPS function.

      Check whether two spatial values overlap.

    • StPointN

      @Pro public static final <T extends Spatial> QOM.StPointN<T> StPointN()
      The ST POINTN function.

      Get the Nth point of a spatial value.

    • StPointN

      @Pro public static final <T extends Spatial> QOM.StPointN<T> StPointN(Field<T> value, Field<? extends Number> position)
      The ST POINTN function.

      Get the Nth point of a spatial value.

    • StSrid

      @Pro public static final QOM.StSrid StSrid()
      The ST SRID function.

      Get the SRID of a spatial value.

    • StSrid

      @Pro public static final QOM.StSrid StSrid(Field<? extends Spatial> value)
      The ST SRID function.

      Get the SRID of a spatial value.

    • StStartPoint

      @Pro public static final <T extends Spatial> QOM.StStartPoint<T> StStartPoint()
      The ST STARTPOINT function.

      Get the start point of a spatial value.

    • StStartPoint

      @Pro public static final <T extends Spatial> QOM.StStartPoint<T> StStartPoint(Field<T> value)
      The ST STARTPOINT function.

      Get the start point of a spatial value.

    • StTouches

      @Pro public static final <T extends Spatial> QOM.StTouches<T> StTouches()
      The ST TOUCHES function.

      Check whether two spatial values touch.

    • StTouches

      @Pro public static final <T extends Spatial> QOM.StTouches<T> StTouches(Field<T> arg1, Field<T> arg2)
      The ST TOUCHES function.

      Check whether two spatial values touch.

    • StUnion

      @Pro public static final <T extends Spatial> QOM.StUnion<T> StUnion()
      The ST UNION function.

      Get the union of two spatial values.

    • StUnion

      @Pro public static final <T extends Spatial> QOM.StUnion<T> StUnion(Field<T> arg1, Field<T> arg2)
      The ST UNION function.

      Get the union of two spatial values.

    • StWithin

      @Pro public static final <T extends Spatial> QOM.StWithin<T> StWithin()
      The ST WITHIN function.

      Check if a spatial value is contained within another.

    • StWithin

      @Pro public static final <T extends Spatial> QOM.StWithin<T> StWithin(Field<T> arg1, Field<T> arg2)
      The ST WITHIN function.

      Check if a spatial value is contained within another.

    • StX

      @Pro public static final QOM.StX StX()
      The ST X function.

      Extract the X coordinate from the argument geometry.

    • StX

      @Pro public static final QOM.StX StX(Field<Geometry> value)
      The ST X function.

      Extract the X coordinate from the argument geometry.

    • StY

      @Pro public static final QOM.StY StY()
      The ST Y function.

      Extract the Y coordinate from the argument geometry.

    • StY

      @Pro public static final QOM.StY StY(Field<Geometry> value)
      The ST Y function.

      Extract the Y coordinate from the argument geometry.

    • StZ

      @Pro public static final QOM.StZ StZ()
      The ST Z function.

      Extract the Z coordinate from the argument geometry.

    • StZ

      @Pro public static final QOM.StZ StZ(Field<Geometry> value)
      The ST Z function.

      Extract the Z coordinate from the argument geometry.

    • unmodifiable

      @Internal public static final <Q extends QueryPart> QOM.UnmodifiableList<Q> unmodifiable(Q[] array)
      Turn an array into an unmodifiable QOM.UnmodifiableList.
    • unmodifiable

      @Internal public static final <Q extends QueryPart> QOM.UnmodifiableList<Q> unmodifiable(List<Q> list)
      Turn a List into an unmodifiable QOM.UnmodifiableList.
    • unmodifiable

      @Internal public static final <Q extends QueryPart> QOM.UnmodifiableList<Q> unmodifiable(Collection<Q> collection)
      Turn a Collection into an unmodifiable QOM.UnmodifiableList.
    • unmodifiable

      @Internal public static final <K extends QueryPart, V extends QueryPart> QOM.UnmodifiableMap<K,V> unmodifiable(Map<K,V> map)
      Turn a Map into an unmodifiable QOM.UnmodifiableMap.
    • tuple

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