Uses of Interface
org.jooq.QueryPart

Packages that use QueryPart

Package	Description
org.jooq	This package contains jOOQ's public API.
org.jooq.impl	This package contains jOOQ's implementation classes.

Uses of QueryPart in org.jooq

Classes in org.jooq with type parameters of type QueryPart

Modifier and Type	Interface	Description
interface	Lambda1<Q1 extends QueryPart,QR extends QueryPart>	A lambda expression of degree 1.
interface	Lambda1<Q1 extends QueryPart,QR extends QueryPart>	A lambda expression of degree 1.

Subinterfaces of QueryPart in org.jooq

Modifier and Type	Interface	Description
interface	AggregateFilterStep<T>	The step in the specification of aggregate functions where the SQL:2003 standard FILTER clause can be added.
interface	AggregateFunction<T>	An aggregate function.
interface	AlterDatabaseFinalStep	Deprecated, for removal: This API element is subject to removal in a future version. - [#11329] - 3.15.0 - This type will be removed in the future.
interface	AlterDomainDropConstraintCascadeStep	A step in the construction of the ALTER DOMAIN statement.
interface	AlterDomainFinalStep	Deprecated, for removal: This API element is subject to removal in a future version. - [#11329] - 3.15.0 - This type will be removed in the future.
interface	AlterIndexFinalStep	Deprecated, for removal: This API element is subject to removal in a future version. - [#11329] - 3.15.0 - This type will be removed in the future.
interface	AlterSchemaFinalStep	Deprecated, for removal: This API element is subject to removal in a future version. - [#11329] - 3.15.0 - This type will be removed in the future.
interface	AlterSequenceFinalStep	Deprecated, for removal: This API element is subject to removal in a future version. - [#11329] - 3.15.0 - This type will be removed in the future.
interface	AlterSequenceFlagsStep<T extends Number>	A step in the construction of the ALTER SEQUENCE statement.
interface	AlterSequenceStep<T extends Number>	A step in the construction of the ALTER SEQUENCE statement.
interface	AlterTableAddStep	The step in the ALTER TABLE DSL used to ADD columns.
interface	AlterTableDropStep	The step in the ALTER TABLE DSL used to DROP columns or constraints.
interface	AlterTableFinalStep	Deprecated, for removal: This API element is subject to removal in a future version. - [#11329] - 3.15.0 - This type will be removed in the future.
interface	AlterTableUsingIndexStep	The step in the ALTER TABLE … ADD CONSTRAINT statement where an optional index can be specified to enforce the constraint.
interface	AlterTypeFinalStep	Deprecated, for removal: This API element is subject to removal in a future version. - [#11329] - 3.15.0 - This type will be removed in the future.
interface	AlterViewFinalStep	Deprecated, for removal: This API element is subject to removal in a future version. - [#11329] - 3.15.0 - This type will be removed in the future.
interface	ArrayAggOrderByStep<T>	The SQL standard ARRAY_AGG() function.
interface	Asterisk	An unqualified asterisk.
interface	AttachableQueryPart	A type that is both Attachable and a QueryPart.
interface	Block	A procedural block.
interface	CallArgsStep	A step in the construction of the CALL statement.
interface	CaseConditionStep<T>	The final step in creating a case statement of the type
interface	CaseWhenStep<V,T>	The final step in creating a case statement of the type
interface	Catalog	A catalog.
interface	CharacterSet	A character set.
interface	Check<R extends Record>	A check constraint.
interface	CloseableQuery	A Query that holds a reference to the underlying PreparedStatement without closing it, for reuse.
interface	CloseableResultQuery<R extends Record>	A ResultQuery that holds a reference to the underlying PreparedStatement without closing it, for reuse.
interface	Collation	A collation.
interface	ColumnElement	A common base type for Comment and other, potential future types where DSL API accepts all types alike.
interface	Comment	A comment.
interface	CommentOnFinalStep	Deprecated, for removal: This API element is subject to removal in a future version. - [#11329] - 3.15.0 - This type will be removed in the future.
interface	CommonTableExpression<R extends Record>	A common table expression.
interface	Condition	A condition or predicate.
interface	Constraint	A DDL constraint.
interface	ConstraintEnforcementStep	The step in the Constraint construction DSL API that allows for adding ENFORCED and NOT ENFORCED clauses.
interface	ConstraintFinalStep	Deprecated, for removal: This API element is subject to removal in a future version. - [#11329] - 3.15.0 - This type will be removed in the future.
interface	ConstraintForeignKeyOnStep	The step in the Constraint construction DSL API that allows for adding ON DELETE and ON UPDATE clauses.
interface	ConstraintTypeStep	The step in the Constraint construction DSL API that allows for specifying the constraint type.
interface	ContinueWhenStep	A step in the construction of an CONTINUE statement where a WHEN clause can be added.
interface	CreateDatabaseFinalStep	Deprecated, for removal: This API element is subject to removal in a future version. - [#11329] - 3.15.0 - This type will be removed in the future.
interface	CreateDomainConstraintStep	A step in the construction of the CREATE DOMAIN statement.
interface	CreateDomainDefaultStep<T>	A step in the construction of the CREATE DOMAIN statement.
interface	CreateDomainFinalStep	Deprecated, for removal: This API element is subject to removal in a future version. - [#11329] - 3.15.0 - This type will be removed in the future.
interface	CreateIndexFinalStep	Deprecated, for removal: This API element is subject to removal in a future version. - [#11329] - 3.15.0 - This type will be removed in the future.
interface	CreateIndexIncludeStep	A step in the construction of the CREATE INDEX statement.
interface	CreateIndexWhereStep	A step in the construction of the CREATE INDEX statement.
interface	CreateSchemaFinalStep	Deprecated, for removal: This API element is subject to removal in a future version. - [#11329] - 3.15.0 - This type will be removed in the future.
interface	CreateSequenceAsStep<T extends Number>	A step in the construction of the CREATE SEQUENCE statement.
interface	CreateSequenceFinalStep	Deprecated, for removal: This API element is subject to removal in a future version. - [#11329] - 3.15.0 - This type will be removed in the future.
interface	CreateSequenceFlagsStep<T extends Number>	A step in the construction of the CREATE SEQUENCE statement.
interface	CreateTableAsStep	A step in the construction of the CREATE TABLE statement.
interface	CreateTableCommentStep	A step in the construction of the CREATE TABLE statement.
interface	CreateTableElementListStep	A step in the construction of the CREATE TABLE statement.
interface	CreateTableFinalStep	Deprecated, for removal: This API element is subject to removal in a future version. - [#11329] - 3.15.0 - This type will be removed in the future.
interface	CreateTableOnCommitStep	A step in the construction of the CREATE TABLE statement.
interface	CreateTableStorageStep	A step in the construction of the CREATE TABLE statement.
interface	CreateTableWithDataStep	A step in the construction of the CREATE TABLE statement.
interface	CreateTypeFinalStep	Deprecated, for removal: This API element is subject to removal in a future version. - [#11329] - 3.15.0 - This type will be removed in the future.
interface	CreateViewFinalStep	Deprecated, for removal: This API element is subject to removal in a future version. - [#11329] - 3.15.0 - This type will be removed in the future.
interface	DataType<T>	A common interface to all dialect-specific data types.
interface	DDLQuery	A marker interface for all DDL queries.
interface	Declaration<T>	A local variable declaration.
interface	Delete<R extends Record>	A DELETE statement.
interface	DeleteConditionStep<R extends Record>	This type is used for the Delete's DSL API.
interface	DeleteFinalStep<R extends Record>	Deprecated, for removal: This API element is subject to removal in a future version. - [#11329] - 3.15.0 - This type will be removed in the future.
interface	DeleteLimitStep<R extends Record>	This type is used for the Delete's DSL API.
interface	DeleteOrderByStep<R extends Record>	This type is used for the Delete's DSL API.
interface	DeleteQuery<R extends Record>	A DELETE statement (model API).
interface	DeleteResultStep<R extends Record>	This type is used for the Delete's DSL API.
interface	DeleteReturningStep<R extends Record>	This type is used for the Delete's DSL API.
interface	DeleteUsingStep<R extends Record>	This type is used for the Delete's DSL API.
interface	DeleteWhereStep<R extends Record>	This type is used for the Delete's DSL API.
interface	DerivedColumnList	A derived column list.
interface	DerivedColumnList1	A derived column list.
interface	DerivedColumnList10	A derived column list.
interface	DerivedColumnList11	A derived column list.
interface	DerivedColumnList12	A derived column list.
interface	DerivedColumnList13	A derived column list.
interface	DerivedColumnList14	A derived column list.
interface	DerivedColumnList15	A derived column list.
interface	DerivedColumnList16	A derived column list.
interface	DerivedColumnList17	A derived column list.
interface	DerivedColumnList18	A derived column list.
interface	DerivedColumnList19	A derived column list.
interface	DerivedColumnList2	A derived column list.
interface	DerivedColumnList20	A derived column list.
interface	DerivedColumnList21	A derived column list.
interface	DerivedColumnList22	A derived column list.
interface	DerivedColumnList3	A derived column list.
interface	DerivedColumnList4	A derived column list.
interface	DerivedColumnList5	A derived column list.
interface	DerivedColumnList6	A derived column list.
interface	DerivedColumnList7	A derived column list.
interface	DerivedColumnList8	A derived column list.
interface	DerivedColumnList9	A derived column list.
interface	DMLQuery<R extends Record>	A marker interface for all DML queries (namely Insert, Update, Delete, and Merge).
interface	Domain<T>	The meta model of a SQL DOMAIN
interface	DropDatabaseFinalStep	Deprecated, for removal: This API element is subject to removal in a future version. - [#11329] - 3.15.0 - This type will be removed in the future.
interface	DropDomainCascadeStep	A step in the construction of the DROP DOMAIN statement.
interface	DropDomainFinalStep	Deprecated, for removal: This API element is subject to removal in a future version. - [#11329] - 3.15.0 - This type will be removed in the future.
interface	DropIndexCascadeStep	A step in the construction of the DROP INDEX statement.
interface	DropIndexFinalStep	Deprecated, for removal: This API element is subject to removal in a future version. - [#11329] - 3.15.0 - This type will be removed in the future.
interface	DropIndexOnStep	A step in the construction of the DROP INDEX statement.
interface	DropSchemaFinalStep	Deprecated, for removal: This API element is subject to removal in a future version. - [#11329] - 3.15.0 - This type will be removed in the future.
interface	DropSchemaStep	A step in the construction of the DROP SCHEMA statement.
interface	DropSequenceFinalStep	Deprecated, for removal: This API element is subject to removal in a future version. - [#11329] - 3.15.0 - This type will be removed in the future.
interface	DropTableFinalStep	Deprecated, for removal: This API element is subject to removal in a future version. - [#11329] - 3.15.0 - This type will be removed in the future.
interface	DropTableStep	A step in the construction of the DROP TABLE statement.
interface	DropTriggerOnStep	A step in the construction of the DROP TRIGGER statement.
interface	DropTypeFinalStep	Deprecated, for removal: This API element is subject to removal in a future version. - [#11329] - 3.15.0 - This type will be removed in the future.
interface	DropTypeStep	A step in the construction of the DROP TYPE statement.
interface	DropViewFinalStep	Deprecated, for removal: This API element is subject to removal in a future version. - [#11329] - 3.15.0 - This type will be removed in the future.
interface	ExitWhenStep	A step in the construction of an EXIT statement where a WHEN clause can be added.
interface	False	A Condition that always yields false.
interface	Field<T>	A column expression.
interface	FieldOrConstraint	Deprecated. - 3.17.0 - [#13005] - Use TableElement instead.
interface	FieldOrRow	A common base type for Field and Row where DSL API accepts both types alike.
interface	FieldOrRowOrSelect	A common base type for Field, Row, and Select where DSL API accepts all types alike.
interface	ForeignKey<CHILD extends Record,PARENT extends Record>	A ForeignKey is an object referencing a UniqueKey.
interface	GrantFinalStep	Deprecated, for removal: This API element is subject to removal in a future version. - [#11329] - 3.15.0 - This type will be removed in the future.
interface	GrantWithGrantOptionStep	A step in the construction of the GRANT statement.
interface	GroupConcatOrderByStep	MySQL's GROUP_CONCAT function.
interface	GroupConcatSeparatorStep	MySQL's GROUP_CONCAT function.
interface	GroupField	An expression to be used exclusively in GROUP BY clauses.
interface	IfElseStep	An intermediate step in building a procedural IF statement.
interface	Index	A DDL index definition.
interface	Insert<R extends Record>	An INSERT statement.
interface	InsertFinalStep<R extends Record>	Deprecated, for removal: This API element is subject to removal in a future version. - [#11329] - 3.15.0 - This type will be removed in the future.
interface	InsertOnConflictConditionStep<R extends Record>	This type is used for the Insert's DSL API.
interface	InsertOnConflictWhereStep<R extends Record>	This type is used for the Insert's DSL API.
interface	InsertOnDuplicateSetMoreStep<R extends Record>	This type is used for the Insert's DSL API.
interface	InsertOnDuplicateStep<R extends Record>	This type is used for the Insert's DSL API.
interface	InsertQuery<R extends Record>	An INSERT statement (model API).
interface	InsertResultStep<R extends Record>	This type is used for the Insert's DSL API.
interface	InsertReturningStep<R extends Record>	This type is used for the Insert's DSL API.
interface	InsertSetMoreStep<R extends Record>	This type is used for the Insert's alternative DSL API.
interface	InsertValuesStep1<R extends Record,T1>	This type is used for the Insert's DSL API.
interface	InsertValuesStep10<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>	This type is used for the Insert's DSL API.
interface	InsertValuesStep11<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>	This type is used for the Insert's DSL API.
interface	InsertValuesStep12<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>	This type is used for the Insert's DSL API.
interface	InsertValuesStep13<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>	This type is used for the Insert's DSL API.
interface	InsertValuesStep14<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>	This type is used for the Insert's DSL API.
interface	InsertValuesStep15<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>	This type is used for the Insert's DSL API.
interface	InsertValuesStep16<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>	This type is used for the Insert's DSL API.
interface	InsertValuesStep17<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>	This type is used for the Insert's DSL API.
interface	InsertValuesStep18<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>	This type is used for the Insert's DSL API.
interface	InsertValuesStep19<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>	This type is used for the Insert's DSL API.
interface	InsertValuesStep2<R extends Record,T1,T2>	This type is used for the Insert's DSL API.
interface	InsertValuesStep20<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>	This type is used for the Insert's DSL API.
interface	InsertValuesStep21<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>	This type is used for the Insert's DSL API.
interface	InsertValuesStep22<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>	This type is used for the Insert's DSL API.
interface	InsertValuesStep3<R extends Record,T1,T2,T3>	This type is used for the Insert's DSL API.
interface	InsertValuesStep4<R extends Record,T1,T2,T3,T4>	This type is used for the Insert's DSL API.
interface	InsertValuesStep5<R extends Record,T1,T2,T3,T4,T5>	This type is used for the Insert's DSL API.
interface	InsertValuesStep6<R extends Record,T1,T2,T3,T4,T5,T6>	This type is used for the Insert's DSL API.
interface	InsertValuesStep7<R extends Record,T1,T2,T3,T4,T5,T6,T7>	This type is used for the Insert's DSL API.
interface	InsertValuesStep8<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8>	This type is used for the Insert's DSL API.
interface	InsertValuesStep9<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9>	This type is used for the Insert's DSL API.
interface	InsertValuesStepN<R extends Record>	This type is used for the Insert's DSL API.
interface	InverseForeignKey<PARENT extends Record,CHILD extends Record>	An InverseForeignKey is an inverse ForeignKey.
interface	JSONArrayAggNullStep<T>	A step in the construction of DSL.jsonArrayAgg(Field) or DSL.jsonbArrayAgg(Field) functions where the NULL clause can be defined.
interface	JSONArrayAggOrderByStep<J>	A step in the construction of DSL.jsonArrayAgg(Field) or DSL.jsonbArrayAgg(Field) functions where the ORDER BY clause can be defined.
interface	JSONArrayAggReturningStep<T>	A step in the construction of DSL.jsonArrayAgg(Field) or DSL.jsonbArrayAgg(Field) functions where the RETURNING clause can be defined.
interface	JSONArrayNullStep<T>	A step in the construction of the JSON ARRAY function.
interface	JSONArrayReturningStep<T>	A step in the construction of the JSON ARRAY function.
interface	JSONEntry<T>	A JSON entry for JSON objects.
interface	JSONExistsOnStep	A step in the construction of DSL.jsonExists(Field, Field) or DSL.jsonbExists(Field, Field) functions where the ON ERROR clause can be defined.
interface	JSONObjectAggNullStep<T>	A step in the construction of DSL.jsonObjectAgg(JSONEntry) or DSL.jsonbObjectAgg(JSONEntry) functions where the NULL clause can be defined.
interface	JSONObjectAggReturningStep<T>	A step in the construction of DSL.jsonObjectAgg(JSONEntry) or DSL.jsonbObjectAgg(JSONEntry) functions where the RETURNING clause can be defined.
interface	JSONObjectNullStep<T>	A step in the construction of the JSON OBJECT function.
interface	JSONObjectReturningStep<T>	A step in the construction of the JSON OBJECT function.
interface	JSONTableColumnPathStep	A step in the construction of an JSON_TABLE expression.
interface	JSONTableColumnsStep	A step in the construction of an JSON_TABLE expression.
interface	JSONValueOnStep<J>	A step in the construction of DSL.jsonValue(Field, Field) or DSL.jsonbValue(Field, Field) functions where the ON EMPTY and ON ERROR clauses can be defined.
interface	JSONValueReturningStep<T>	A step in the construction of the JSON VALUE function.
interface	Key<R extends Record>	A Key is an object representing a UNIQUE KEY, a PRIMARY KEY, or a FOREIGN KEY.
interface	Keyword	A SQL keyword.
interface	Label	A label for use in procedural code.
interface	Lambda1<Q1 extends QueryPart,QR extends QueryPart>	A lambda expression of degree 1.
interface	LikeEscapeStep	A step in the construction of the LIKE function.
interface	Link	A database link reference.
interface	Merge<R extends Record>	A MERGE statement.
interface	MergeFinalStep<R extends Record>	Deprecated, for removal: This API element is subject to removal in a future version. - [#11329] - 3.15.0 - This type will be removed in the future.
interface	MergeMatchedDeleteStep<R extends Record>	This type is used for the Merge's DSL API.
interface	MergeMatchedSetMoreStep<R extends Record>	This type is used for the Merge's DSL API.
interface	MergeMatchedStep<R extends Record>	This type is used for the Merge's DSL API.
interface	MergeMatchedWhereStep<R extends Record>	This type is used for the Merge's DSL API.
interface	MergeNotMatchedSetMoreStep<R extends Record>	This type is used for the Merge's DSL API.
interface	MergeNotMatchedStep<R extends Record>	This type is used for the Merge's DSL API.
interface	MergeNotMatchedWhereStep<R extends Record>	This type is used for the Merge's DSL API.
interface	MergeOnConditionStep<R extends Record>	This type is used for the Merge's DSL API.
interface	Name	An identifier.
interface	Named	A common base type for all qualifiable, named objects.
interface	Null	A Condition that always yields null.
interface	OptionallyOrderedAggregateFunction<T>	An ordered-set aggregate function.
interface	OrderField<T>	A QueryPart to be used exclusively in ORDER BY clauses.
interface	Package	A container for stored procedures and functions
interface	Param<T>	A named parameter and/or bind value.
interface	Parameter<T>	A parameter to a stored procedure or function.
interface	ParamOrVariable<T>	A common super type of Param and Variable.
interface	Path<R extends Record>	A relationship path.
interface	Period<T>	A period specification for usage in temporal tables.
interface	PeriodSpecification	A specification of a Period application for use in Select queries.
interface	Privilege	A privilege for use in GRANT and REVOKE statements.
interface	Qualified	A QueryPart that is Named and located in a Schema.
interface	QualifiedAsterisk	A qualified asterisk.
interface	QuantifiedSelect<R extends Record>	A quantified select for use in quantified comparison predicates.
interface	Queries	A wrapper for a collection of queries.
interface	Query	Any query.
interface	QueryPartInternal	Base functionality declaration for all query objects
interface	RecordQualifier<R extends Record>	A UDT or Table.
interface	ResultQuery<R extends Record>	A query that can return results.
interface	RevokeFinalStep	Deprecated, for removal: This API element is subject to removal in a future version. - [#11329] - 3.15.0 - This type will be removed in the future.
interface	Role	A privilege for use in GRANT and REVOKE statements.
interface	RollbackToSavepointStep	A step in the construction of the ROLLBACK statement.
interface	Routine<T>	A routine is a callable object in your RDBMS.
interface	Row	A row value expression.
interface	Row1<T1>	A row value expression.
interface	Row10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>	A row value expression.
interface	Row11<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>	A row value expression.
interface	Row12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>	A row value expression.
interface	Row13<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>	A row value expression.
interface	Row14<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>	A row value expression.
interface	Row15<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>	A row value expression.
interface	Row16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>	A row value expression.
interface	Row17<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>	A row value expression.
interface	Row18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>	A row value expression.
interface	Row19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>	A row value expression.
interface	Row2<T1,T2>	A row value expression.
interface	Row20<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>	A row value expression.
interface	Row21<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>	A row value expression.
interface	Row22<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>	A row value expression.
interface	Row3<T1,T2,T3>	A row value expression.
interface	Row4<T1,T2,T3,T4>	A row value expression.
interface	Row5<T1,T2,T3,T4,T5>	A row value expression.
interface	Row6<T1,T2,T3,T4,T5,T6>	A row value expression.
interface	Row7<T1,T2,T3,T4,T5,T6,T7>	A row value expression.
interface	Row8<T1,T2,T3,T4,T5,T6,T7,T8>	A row value expression.
interface	Row9<T1,T2,T3,T4,T5,T6,T7,T8,T9>	A row value expression.
interface	RowCountQuery	Any query that is not a ResultQuery, and thus possibly produces a row count as a result, instead of a Result.
interface	RowN	A row value expression.
interface	Schema	A schema.
interface	Select<R extends Record>	A SELECT statement.
interface	SelectConditionStep<R extends Record>	This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectConnectByAfterStartWithConditionStep<R extends Record>	This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectConnectByConditionStep<R extends Record>	This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectConnectByStep<R extends Record>	This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectCorrelatedSubqueryStep<R extends Record>	This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectDistinctOnStep<R extends Record>	This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectField<T>	A QueryPart to be used exclusively in SELECT clauses.
interface	SelectFieldOrAsterisk	A QueryPart to be used exclusively in SELECT clauses.
interface	SelectFinalStep<R extends Record>	This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectForJSONCommonDirectivesStep<R extends Record>	This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectForStep<R extends Record>	This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectForUpdateOfStep<R extends Record>	This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectForUpdateStep<R extends Record>	This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectForUpdateWaitStep<R extends Record>	This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectForXMLCommonDirectivesStep<R extends Record>	This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectForXMLPathDirectivesStep<R extends Record>	This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectForXMLRawDirectivesStep<R extends Record>	This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectFromStep<R extends Record>	This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectGroupByStep<R extends Record>	This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectHavingConditionStep<R extends Record>	This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectHavingStep<R extends Record>	This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectIntoStep<R extends Record>	This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectJoinStep<R extends Record>	This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectLimitAfterOffsetStep<R extends Record>	This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectLimitPercentAfterOffsetStep<R extends Record>	This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectLimitPercentStep<R extends Record>	This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectLimitStep<R extends Record>	This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectOffsetStep<R extends Record>	This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectOnConditionStep<R extends Record>	This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectOptionalOnStep<R extends Record>	This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectOptionStep<R extends Record>	This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectOrderByStep<R extends Record>	This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectQualifyConditionStep<R extends Record>	This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectQualifyStep<R extends Record>	This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectQuery<R extends Record>	A SELECT statement (model API).
interface	SelectSeekLimitStep<R extends Record>	This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectSeekStep1<R extends Record,T1>	This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectSeekStep10<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>	This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectSeekStep11<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11>	This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectSeekStep12<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12>	This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectSeekStep13<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13>	This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectSeekStep14<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14>	This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectSeekStep15<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15>	This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectSeekStep16<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>	This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectSeekStep17<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17>	This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectSeekStep18<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18>	This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectSeekStep19<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19>	This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectSeekStep2<R extends Record,T1,T2>	This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectSeekStep20<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20>	This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectSeekStep21<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21>	This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectSeekStep22<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21,T22>	This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectSeekStep3<R extends Record,T1,T2,T3>	This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectSeekStep4<R extends Record,T1,T2,T3,T4>	This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectSeekStep5<R extends Record,T1,T2,T3,T4,T5>	This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectSeekStep6<R extends Record,T1,T2,T3,T4,T5,T6>	This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectSeekStep7<R extends Record,T1,T2,T3,T4,T5,T6,T7>	This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectSeekStep8<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8>	This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectSeekStep9<R extends Record,T1,T2,T3,T4,T5,T6,T7,T8,T9>	This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectSeekStepN<R extends Record>	This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectSelectStep<R extends Record>	This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectStartWithStep<R extends Record>	This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectUnionStep<R extends Record>	This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectWhereStep<R extends Record>	This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectWindowStep<R extends Record>	This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectWithTiesAfterOffsetStep<R extends Record>	This type is used for the Select's DSL API when selecting generic Record types.
interface	SelectWithTiesStep<R extends Record>	This type is used for the Select's DSL API when selecting generic Record types.
interface	Sequence<T extends Number>	A sequence.
interface	SignalSetStep	A step in the construction of the SIGNAL SQL STATE function.
interface	SortField<T>	A sort specification.
interface	SQL	A plain SQL QueryPart.
interface	Statement	A statement that can be placed inside of a Block, but not executed on its own.
interface	StoreQuery<R extends Record>	A query storing objects to the database.
interface	Synonym
interface	Table<R extends Record>	A table.
interface	TableElement	A common base type for Field, Constraint, and Index where DSL API accepts all types alike.
interface	TableField<R extends Record,T>	A field contained in a table.
interface	TableLike<R extends Record>	An object that can behave like a table (a table-like object).
interface	TableOnConditionStep<R extends Record>	An intermediate (optional) type for the construction of a JOIN clause, where the join criteria is added using an ON clause (with a Condition.
interface	TableOptionalOnStep<R extends Record>	An intermediate type for the construction of a JOIN clause, where there may optionally be a join criteria added using an ON clause (with a Condition), or using a USING clause (with a list of Field)
interface	Trigger	A meta model of SQL TRIGGER objects.
interface	True	A Condition that always yields true.
interface	Truncate<R extends Record>	A step in the construction of the TRUNCATE statement.
interface	TruncateCascadeStep<R extends Record>	A step in the construction of the TRUNCATE statement.
interface	TruncateFinalStep<R extends Record>	Deprecated, for removal: This API element is subject to removal in a future version. - [#11329] - 3.15.0 - This type will be removed in the future.
interface	TruncateIdentityStep<R extends Record>	A step in the construction of the TRUNCATE statement.
interface	Type<T>	An object representing a user defined type.
interface	Typed<T>	A marker interface for all query parts that have a DataType.
interface	UDT<R extends UDTRecord<R>>	UDT definition.
interface	UDTField<R extends UDTRecord<R>,T>	A field contained in a UDT.
interface	UDTPathField<R extends Record,U extends UDTRecord<U>,T>	A field dereferenced from a UDT path.
interface	UDTPathTableField<R extends Record,U extends UDTRecord<U>,T>	A field dereferenced from a UDT path.
interface	UniqueKey<R extends Record>	A UniqueKey is an object representing a UNIQUE KEY or a PRIMARY KEY.
interface	Update<R extends Record>	An UPDATE statement.
interface	UpdateConditionStep<R extends Record>	This type is used for the Update's DSL API.
interface	UpdateFinalStep<R extends Record>	Deprecated, for removal: This API element is subject to removal in a future version. - [#11329] - 3.15.0 - This type will be removed in the future.
interface	UpdateFromStep<R extends Record>	This type is used for the Update's DSL API.
interface	UpdateLimitStep<R extends Record>	This type is used for the Update's DSL API.
interface	UpdateOrderByStep<R extends Record>	This type is used for the Update's DSL API.
interface	UpdateQuery<R extends Record>	An UPDATE statement (model API).
interface	UpdateResultStep<R extends Record>	This type is used for the Update's DSL API.
interface	UpdateReturningStep<R extends Record>	This type is used for the Update's DSL API.
interface	UpdateSetMoreStep<R extends Record>	This type is used for the Update's DSL API.
interface	UpdateWhereStep<R extends Record>	This type is used for the Update's DSL API.
interface	User	A privilege for use in GRANT and REVOKE statements.
interface	Variable<T>	A local variable reference.
interface	WindowBeforeOverStep<T>	This type is used for the window function DSL API.
interface	WindowDefinition	A window definition.
interface	WindowExcludeStep<T>	This type is used for the window function DSL API.
interface	WindowFinalStep<T>	Deprecated, for removal: This API element is subject to removal in a future version. - [#11329] - 3.15.0 - This type will be removed in the future.
interface	WindowOrderByStep<T>	This type is used for the window function DSL API.
interface	WindowPartitionByStep<T>	This type is used for the window function DSL API.
interface	WindowRowsStep<T>	This type is used for the window function DSL API.
interface	WindowSpecification	A window specification.
interface	WindowSpecificationExcludeStep	An intermediate step in the construction of a WindowSpecification.
interface	WindowSpecificationFinalStep	Deprecated, for removal: This API element is subject to removal in a future version. - [#11329] - 3.15.0 - This type will be removed in the future.
interface	WindowSpecificationOrderByStep	An intermediate step in the construction of a WindowSpecification.
interface	WindowSpecificationPartitionByStep	An intermediate step in the construction of a WindowSpecification.
interface	WindowSpecificationRowsStep	An intermediate step in the construction of a WindowSpecification.
interface	WithStep	This type is part of the jOOQ DSL to create Select, Insert, Update, Delete, Merge statements prefixed with a WITH clause and with CommonTableExpressions.
interface	XMLAggOrderByStep<T>	The SQL standard ARRAY_AGG() function.
interface	XMLAttributes	A type modelling XML attributes for use in DSL.xmlelement(Name, XMLAttributes, Field...).
interface	XMLTableColumnPathStep	A step in the construction of an XMLTABLE expression.
interface	XMLTableColumnsStep	A step in the construction of an XMLTABLE expression.

Methods in org.jooq with type parameters of type QueryPart

Modifier and Type	Method	Description
<Q extends QueryPart> @NotNull Iterable<Q>	Context.currentScopeParts(Class<? extends Q> type)	Get all values of a type that are in the current scope.
<Q extends QueryPart> @NotNull Iterable<Q>	Context.scopeParts(Class<? extends Q> type)	Get all values of a type that are in the current scope or higher.

Methods in org.jooq that return QueryPart

Modifier and Type	Method	Description
default @NotNull QueryPart	QueryPart.$replace(Function<? super QueryPart,? extends QueryPart> replacer)	Traverse a QueryPart hierarchy and recursively replace its elements by alternatives.
@NotNull QueryPart	QueryPart.$replace(Replacer replacer)	Traverse a QueryPart hierarchy and recursively replace its elements by alternatives.
@Nullable QueryPart	DiagnosticsContext.part()	The object that was diagnosed if available, or null, if there was no specific QueryPart to attach the diagnostic to.
@NotNull QueryPart	VisitContext.queryPart()	The most recent QueryPart that was encountered through Context.visit(QueryPart).
@NotNull QueryPart @NotNull []	VisitContext.queryParts()	A path of QueryParts going through the visiting tree.
@NotNull QueryPart	Context.scopeMapping(QueryPart part)	Retrieve the registered mapping for a query part in the current scope.
@Nullable QueryPart	Context.scopePart()	Return the QueryPart that defines the current Context.scopeStart(QueryPart), if any, or null if there is no such QueryPart.
@Nullable QueryPart	Context.topLevel()	The top level QueryPart that is being rendered.
@Nullable QueryPart	Context.topLevelForLanguageContext()	The top level QueryPart that is being rendered in the current Context.languageContext().
@Nullable QueryPart	DiagnosticsContext.transformedPart()	The transformed object from DiagnosticsContext.part() if available, or null, if there was no specific transformation to attach the diagnostic to.

Methods in org.jooq that return types with arguments of type QueryPart

Modifier and Type	Method	Description
BiFunction<A,QueryPart,A>	Traverser.after()	A callback that is invoked after recursing into a subtree.
BiFunction<A,QueryPart,A>	Traverser.before()	A callback that is invoked before recursing into a subtree.
static @NotNull Traverser<?,List<QueryPart>>	Traversers.findingAll(Predicate<? super QueryPart> predicate)	A traverser that finds all QueryParts that satisfy a predicate within the traversed QueryPart tree.
static @NotNull Traverser<?,Optional<QueryPart>>	Traversers.findingAny(Predicate<? super QueryPart> predicate)	A traverser that finds any QueryPart that satisfies a predicate within the traversed QueryPart tree.
Predicate<QueryPart>	Replacer.recurse()	An optional recursion condition to prevent entering a specific subtree, e.g.
Predicate<QueryPart>	Traverser.recurse()	An optional recursion condition to prevent entering a specific QueryPart, e.g.
Predicate<QueryPart>	Traverser.recurseChildren()	An optional recursion condition to prevent entering a specific QueryPart's children, e.g.
Function<QueryPart,QueryPart>	Replacer.replacer()	A callback that is invoked on all elements of the QueryPart expression tree.
Function<QueryPart,QueryPart>	Replacer.replacer()	A callback that is invoked on all elements of the QueryPart expression tree.

Methods in org.jooq with parameters of type QueryPart

Modifier and Type	Method	Description
@NotNull Condition	Condition.and(String sql, QueryPart... parts)	Combine this condition with another one using the Operator.AND operator.
@NotNull DeleteConditionStep<R>	DeleteConditionStep.and(String sql, QueryPart... parts)	Combine the currently assembled conditions with another one using the Operator.AND operator
@NotNull DivideByOnConditionStep	DivideByOnConditionStep.and(String sql, QueryPart... parts)	Combine the currently assembled conditions with another one using the Operator.AND operator.
@NotNull InsertOnConflictConditionStep<R>	InsertOnConflictConditionStep.and(String sql, QueryPart... parts)	Combine the currently assembled conditions with another one using the Operator.AND operator and proceed to the next step.
@NotNull MergeOnConditionStep<R>	MergeOnConditionStep.and(String sql, QueryPart... parts)	Combine the currently assembled conditions with another one using the Operator.AND operator and proceed to the next step.
@NotNull SelectConditionStep<R>	SelectConditionStep.and(String sql, QueryPart... parts)	Combine the currently assembled conditions with another one using the Operator.AND operator and proceed to the next step.
@NotNull SelectConnectByAfterStartWithConditionStep<R>	SelectConnectByAfterStartWithConditionStep.and(String sql, QueryPart... parts)	Combine the currently assembled conditions with another one using the Operator.AND operator and proceed to the next step.
@NotNull SelectConnectByConditionStep<R>	SelectConnectByConditionStep.and(String sql, QueryPart... parts)	Combine the currently assembled conditions with another one using the Operator.AND operator and proceed to the next step.
@NotNull SelectHavingConditionStep<R>	SelectHavingConditionStep.and(String sql, QueryPart... parts)	Combine the currently assembled conditions with another one using the Operator.AND operator and proceed to the next step.
@NotNull SelectOnConditionStep<R>	SelectOnConditionStep.and(String sql, QueryPart... parts)	Combine the currently assembled conditions with another one using the Operator.AND operator and proceed to the next step.
@NotNull SelectQualifyConditionStep<R>	SelectQualifyConditionStep.and(String sql, QueryPart... parts)	Combine the currently assembled conditions with another one using the Operator.AND operator and proceed to the next step.
@NotNull TableOnConditionStep<R>	TableOnConditionStep.and(String sql, QueryPart... parts)	Combine the currently assembled conditions with another one using the Operator.AND operator.
@NotNull UpdateConditionStep<R>	UpdateConditionStep.and(String sql, QueryPart... parts)	Combine the currently assembled conditions with another one using the Operator.AND operator
@NotNull CreateViewFinalStep	CreateViewAsStep.as(String query, QueryPart... parts)	Add the AS clause to the CREATE VIEW statement.
@NotNull SelectConnectByAfterStartWithConditionStep<R>	SelectConnectByAfterStartWithStep.connectBy(String sql, QueryPart... parts)	Add an Oracle-specific CONNECT BY clause to the query
@NotNull SelectConnectByConditionStep<R>	SelectConnectByStep.connectBy(String sql, QueryPart... parts)	Add an Oracle-specific CONNECT BY clause to the query.
@NotNull SelectConnectByAfterStartWithConditionStep<R>	SelectConnectByAfterStartWithStep.connectByNoCycle(String sql, QueryPart... parts)	Add an Oracle-specific CONNECT BY NOCYCLE clause to the query
@NotNull SelectConnectByConditionStep<R>	SelectConnectByStep.connectByNoCycle(String sql, QueryPart... parts)	Add an Oracle-specific CONNECT BY NOCYCLE clause to the query
static @NotNull Traverser<?,Boolean>	Traversers.containing(QueryPart part)	A traverser that checks whether a QueryPart contains another QueryPart.
@NotNull SelectJoinStep<R>	SelectJoinStep.crossApply(String sql, QueryPart... parts)	CROSS APPLY a table to this table.
@NotNull Table<Record>	Table.crossApply(String sql, QueryPart... parts)	CROSS APPLY a table to this table.
@NotNull SelectJoinStep<R>	SelectJoinStep.crossJoin(String sql, QueryPart... parts)	Convenience method to CROSS JOIN a table to the last table added to the FROM clause using Table.crossJoin(String, QueryPart...)
@NotNull Table<Record>	Table.crossJoin(String sql, QueryPart... parts)	CROSS JOIN a table to this table.
int	DSLContext.execute(String sql, QueryPart... parts)	Execute a new query holding plain SQL.
@NotNull List<Object>	DSLContext.extractBindValues(QueryPart part)	Retrieve the bind values that will be bound by a given QueryPart.
@Nullable Param<?>	DSLContext.extractParam(QueryPart part, String name)	Get a named parameter from a QueryPart, provided its name.
@NotNull Map<String,Param<?>>	DSLContext.extractParams(QueryPart part)	Get a Map of named parameters.
@NotNull Result<Record>	DSLContext.fetch(String sql, QueryPart... parts)	Execute a new query holding plain SQL.
@NotNull CompletionStage<Result<Record>>	DSLContext.fetchAsync(String sql, QueryPart... parts)	Fetch results in a new CompletionStage.
@NotNull CompletionStage<Result<Record>>	DSLContext.fetchAsync(Executor executor, String sql, QueryPart... parts)	Fetch results in a new CompletionStage that is asynchronously completed by a task running in the given executor.
@NotNull Cursor<Record>	DSLContext.fetchLazy(String sql, QueryPart... parts)	Execute a new query holding plain SQL and "lazily" return the generated result.
@NotNull Results	DSLContext.fetchMany(String sql, QueryPart... parts)	Execute a new query holding plain SQL, possibly returning several result sets.
@Nullable Record	DSLContext.fetchOne(String sql, QueryPart... parts)	Execute a new query holding plain SQL.
@NotNull Optional<Record>	DSLContext.fetchOptional(String sql, QueryPart... parts)	Execute a new query holding plain SQL.
@NotNull Optional<?>	DSLContext.fetchOptionalValue(String sql, QueryPart... parts)	Execute a new query holding plain SQL.
@NotNull Record	DSLContext.fetchSingle(String sql, QueryPart... parts)	Execute a new query holding plain SQL.
@NotNull Stream<Record>	DSLContext.fetchStream(String sql, QueryPart... parts)	Execute a new query holding plain SQL and "lazily" return the generated result.
@Nullable Object	DSLContext.fetchValue(String sql, QueryPart... parts)	Execute a new query holding plain SQL.
@NotNull List<?>	DSLContext.fetchValues(String sql, QueryPart... parts)	Execute a new query holding plain SQL.
@NotNull WindowBeforeOverStep<T>	AggregateFilterStep.filterWhere(String sql, QueryPart... parts)	Add a FILTER clause to the aggregate function.
@NotNull SelectJoinStep<R>	SelectFromStep.from(String sql, QueryPart... parts)	Add a FROM clause to the query.
@NotNull UpdateWhereStep<R>	UpdateFromStep.from(String sql, QueryPart... parts)	Add a FROM clause to the query.
@NotNull SelectOnStep<R>	SelectJoinStep.fullJoin(String sql, QueryPart... parts)	Convenience method to FULL OUTER JOIN a tableto the last table added to the FROM clause using Table.fullOuterJoin(String, QueryPart...).
@NotNull TablePartitionByStep<Record>	Table.fullJoin(String sql, QueryPart... parts)	FULL OUTER JOIN a table to this table.
@NotNull TablePartitionByStep<Record>	TableOuterJoinStep.fullJoin(String sql, QueryPart... parts)	FULL OUTER JOIN a table to this table.
@NotNull SelectOnStep<R>	SelectJoinStep.fullOuterJoin(String sql, QueryPart... parts)	Convenience method to FULL OUTER JOIN a tableto the last table added to the FROM clause using Table.fullOuterJoin(String, QueryPart...)
@NotNull TablePartitionByStep<Record>	Table.fullOuterJoin(String sql, QueryPart... parts)	FULL OUTER JOIN a table to this table.
@NotNull TablePartitionByStep<Record>	TableOuterJoinStep.fullOuterJoin(String sql, QueryPart... parts)	FULL OUTER JOIN a table to this table.
@NotNull SelectHavingConditionStep<R>	SelectHavingStep.having(String sql, QueryPart... parts)	Add a HAVING clause to the query.
boolean	Context.inCurrentScope(QueryPart part)	Check whether a query part is registered in the current scope.
@NotNull SelectOnStep<R>	SelectJoinStep.innerJoin(String sql, QueryPart... parts)	Convenience method to INNER JOIN a table to the last table added to the FROM clause using Table.join(String, QueryPart...).
@NotNull TableOnStep<Record>	Table.innerJoin(String sql, QueryPart... parts)	INNER JOIN a table to this table.
boolean	Context.inScope(QueryPart part)	Check whether a query part is registered in the current scope or higher.
@NotNull SelectOnStep<R>	SelectJoinStep.join(String sql, QueryPart... parts)	Convenience method to INNER JOIN a table to the last table added to the FROM clause using Table.join(String, QueryPart...).
@NotNull TableOnStep<Record>	Table.join(String sql, QueryPart... parts)	INNER JOIN a table to this table.
C	Context.languageContext(LanguageContext languageContext, QueryPart topLevelForLanguageContext, Consumer<? super C> consumer)	Set the new language context for Context.languageContext() for the scope of a Consumer.
@NotNull SelectJoinPartitionByStep<R>	SelectJoinStep.leftJoin(String sql, QueryPart... parts)	Convenience method to LEFT OUTER JOIN a table to the last table added to the FROM clause using Table.leftOuterJoin(String, QueryPart...).
@NotNull TablePartitionByStep<Record>	Table.leftJoin(String sql, QueryPart... parts)	LEFT OUTER JOIN a table to this table.
@NotNull TablePartitionByStep<Record>	TableOuterJoinStep.leftJoin(String sql, QueryPart... parts)	LEFT OUTER JOIN a table to this table.
@NotNull SelectJoinPartitionByStep<R>	SelectJoinStep.leftOuterJoin(String sql, QueryPart... parts)	Convenience method to LEFT OUTER JOIN a table to the last table added to the FROM clause using Table.leftOuterJoin(String, QueryPart...)
@NotNull TablePartitionByStep<Record>	Table.leftOuterJoin(String sql, QueryPart... parts)	LEFT OUTER JOIN a table to this table.
@NotNull TablePartitionByStep<Record>	TableOuterJoinStep.leftOuterJoin(String sql, QueryPart... parts)	LEFT OUTER JOIN a table to this table.
@NotNull SelectJoinStep<R>	SelectJoinStep.naturalFullOuterJoin(String sql, QueryPart... parts)	Convenience method to NATURAL FULL OUTER JOIN a table to the last table added to the FROM clause using Table.naturalFullOuterJoin(String, QueryPart...)
@NotNull Table<Record>	Table.naturalFullOuterJoin(String sql, QueryPart... parts)	NATURAL FULL OUTER JOIN a table to this table.
@NotNull SelectJoinStep<R>	SelectJoinStep.naturalJoin(String sql, QueryPart... parts)	Convenience method to NATURAL JOIN a table to the last table added to the FROM clause using Table.naturalJoin(String, QueryPart...)
@NotNull Table<Record>	Table.naturalJoin(String sql, QueryPart... parts)	NATURAL JOIN a table to this table.
@NotNull SelectJoinStep<R>	SelectJoinStep.naturalLeftOuterJoin(String sql, QueryPart... parts)	Convenience method to NATURAL LEFT OUTER JOIN a table to the last table added to the FROM clause using Table.naturalLeftOuterJoin(String, QueryPart...)
@NotNull Table<Record>	Table.naturalLeftOuterJoin(String sql, QueryPart... parts)	NATURAL LEFT OUTER JOIN a table to this table.
@NotNull SelectJoinStep<R>	SelectJoinStep.naturalRightOuterJoin(String sql, QueryPart... parts)	Convenience method to NATURAL RIGHT OUTER JOIN a table to the last table added to the FROM clause using Table.naturalRightOuterJoin(String, QueryPart...)
@NotNull Table<Record>	Table.naturalRightOuterJoin(String sql, QueryPart... parts)	NATURAL RIGHT OUTER JOIN a table to this table.
@NotNull DivideByOnConditionStep	DivideByOnStep.on(String sql, QueryPart... parts)	Add a division condition to the DIVIDE BY clause
@NotNull MergeOnConditionStep<R>	MergeOnStep.on(String sql, QueryPart... parts)	Provide join conditions and proceed to the next step
@NotNull SelectOnConditionStep<R>	SelectOnStep.on(String sql, QueryPart... parts)	Add an ON clause to the previous JOIN.
@NotNull TableOnConditionStep<R>	TableOnStep.on(String sql, QueryPart... parts)	Add an ON clause to the JOIN.
@NotNull Condition	Condition.or(String sql, QueryPart... parts)	Combine this condition with another one using the Operator.OR operator.
@NotNull DeleteConditionStep<R>	DeleteConditionStep.or(String sql, QueryPart... parts)	Combine the currently assembled conditions with another one using the Operator.OR operator
@NotNull DivideByOnConditionStep	DivideByOnConditionStep.or(String sql, QueryPart... parts)	Combine the currently assembled conditions with another one using the Operator.OR operator.
@NotNull InsertOnConflictConditionStep<R>	InsertOnConflictConditionStep.or(String sql, QueryPart... parts)	Combine the currently assembled conditions with another one using the Operator.OR operator and proceed to the next step.
@NotNull MergeOnConditionStep<R>	MergeOnConditionStep.or(String sql, QueryPart... parts)	Combine the currently assembled conditions with another one using the Operator.OR operator and proceed to the next step.
@NotNull SelectConditionStep<R>	SelectConditionStep.or(String sql, QueryPart... parts)	Combine the currently assembled conditions with another one using the Operator.OR operator and proceed to the next step.
@NotNull SelectHavingConditionStep<R>	SelectHavingConditionStep.or(String sql, QueryPart... parts)	Combine the currently assembled conditions with another one using the Operator.OR operator and proceed to the next step.
@NotNull SelectOnConditionStep<R>	SelectOnConditionStep.or(String sql, QueryPart... parts)	Combine the currently assembled conditions with another one using the Operator.OR operator and proceed to the next step.
@NotNull SelectQualifyConditionStep<R>	SelectQualifyConditionStep.or(String sql, QueryPart... parts)	Combine the currently assembled conditions with another one using the Operator.OR operator and proceed to the next step.
@NotNull TableOnConditionStep<R>	TableOnConditionStep.or(String sql, QueryPart... parts)	Combine the currently assembled conditions with another one using the Operator.OR operator.
@NotNull UpdateConditionStep<R>	UpdateConditionStep.or(String sql, QueryPart... parts)	Combine the currently assembled conditions with another one using the Operator.OR operator
@NotNull SelectJoinStep<R>	SelectJoinStep.outerApply(String sql, QueryPart... parts)	OUTER APPLY a table to this table.
@NotNull Table<Record>	Table.outerApply(String sql, QueryPart... parts)	OUTER APPLY a table to this table.
@NotNull SelectQualifyConditionStep<R>	SelectQualifyStep.qualify(String sql, QueryPart... parts)	Add a QUALIFY clause to the query.
@NotNull RowCountQuery	DSLContext.query(String sql, QueryPart... parts)	Create a new query holding plain SQL.
void	VisitContext.queryPart(QueryPart part)	Replace the most recent QueryPart that was encountered through Context.visit(QueryPart).
@NotNull String	Context.render(QueryPart part)	Render a query part in a new context derived from this one.
@NotNull String	DSLContext.render(QueryPart part)	Render a QueryPart in the context of this DSLContext.
@NotNull String	DSLContext.renderInlined(QueryPart part)	Render a QueryPart in the context of this DSLContext, inlining all bind variables.
@NotNull String	DSLContext.renderNamedOrInlinedParams(QueryPart part)	Render a QueryPart in the context of this DSLContext, rendering bind variables as named parameters, or inlined parameters if they have no name.
@NotNull String	DSLContext.renderNamedParams(QueryPart part)	Render a QueryPart in the context of this DSLContext, rendering bind variables as named parameters.
@NotNull ResultQuery<Record>	DSLContext.resultQuery(String sql, QueryPart... parts)	Create a new query holding plain SQL.
@NotNull SelectJoinPartitionByStep<R>	SelectJoinStep.rightJoin(String sql, QueryPart... parts)	Convenience method to RIGHT OUTER JOIN a table to the last table added to the FROM clause using Table.rightOuterJoin(String, QueryPart...).
@NotNull TablePartitionByStep<Record>	Table.rightJoin(String sql, QueryPart... parts)	RIGHT OUTER JOIN a table to this table.
@NotNull TablePartitionByStep<Record>	TableOuterJoinStep.rightJoin(String sql, QueryPart... parts)	RIGHT OUTER JOIN a table to this table.
@NotNull SelectJoinPartitionByStep<R>	SelectJoinStep.rightOuterJoin(String sql, QueryPart... parts)	Convenience method to RIGHT OUTER JOIN a table to the last table added to the FROM clause using Table.rightOuterJoin(String, QueryPart...)
@NotNull TablePartitionByStep<Record>	Table.rightOuterJoin(String sql, QueryPart... parts)	RIGHT OUTER JOIN a table to this table.
@NotNull TablePartitionByStep<Record>	TableOuterJoinStep.rightOuterJoin(String sql, QueryPart... parts)	RIGHT OUTER JOIN a table to this table.
C	Context.scopeHide(QueryPart part)	Hide the argument query part from child scopes, if it has been registered previously.
@NotNull QueryPart	Context.scopeMapping(QueryPart part)	Retrieve the registered mapping for a query part in the current scope.
C	Context.scopeMarkEnd(QueryPart part)	Mark the end of a scoped query part.
C	Context.scopeMarkStart(QueryPart part)	Mark the beginning of a scoped query part.
C	Context.scopeRegister(QueryPart part)	Register a "special" query part in the scope, reusing the object from a higher scope, if available.
C	Context.scopeRegister(QueryPart part, boolean forceNew)	Register a "special" query part in the scope, allowing to force registering the object in the new scope, if a higher scope already has the object.
C	Context.scopeRegister(QueryPart part, boolean forceNew, QueryPart mapped)	Register a "special" query part in the scope, allowing to force registering the object in the new scope, if a higher scope already has the object, as well as providing a mapped part to map the original part to.
C	Context.scopeRegisterAndMark(QueryPart part, boolean forceNew)	Combine Context.scopeRegister(QueryPart, boolean), Context.scopeMarkStart(QueryPart) and Context.scopeMarkEnd(QueryPart).
C	Context.scopeShow(QueryPart part)	Show the argument query part in child scopes, if it has been registered previously.
C	Context.scopeStart(QueryPart part)	Start a new scope, passing the current QueryPart as the Context.scopePart().
@NotNull SelectWhereStep<Record>	DSLContext.selectFrom(String sql, QueryPart... parts)	Create a new DSL select statement, projecting *.
@NotNull SelectWhereStep<Record>	WithStep.selectFrom(String sql, QueryPart... parts)	Create a new DSL select statement, projecting *.
@NotNull SelectConnectByAfterStartWithStep<R>	SelectConnectByStep.startWith(String sql, QueryPart... parts)	Add an Oracle-specific START WITH clause to the query's CONNECT BY clause.
@NotNull SelectGroupByStep<R>	SelectStartWithStep.startWith(String sql, QueryPart... parts)	Add an Oracle-specific START WITH clause to the query's CONNECT BY clause.
@NotNull CreateTableFinalStep	CreateTableStorageStep.storage(String storage, QueryPart... parts)	Add the STORAGE clause to the CREATE TABLE statement.
@NotNull SelectOnStep<R>	SelectJoinStep.straightJoin(String sql, QueryPart... parts)	STRAIGHT_JOIN a table to this table.
@NotNull TableOnStep<Record>	Table.straightJoin(String sql, QueryPart... parts)	STRAIGHT_JOIN a table to this table.
C	Context.subquery(boolean subquery, QueryPart part)	Set the new context value for Context.subquery() as well as Context.scopePart() a
C	Context.topLevel(QueryPart topLevel)	Set the top level QueryPart that is being rendered.
C	Context.topLevelForLanguageContext(QueryPart topLevelForLanguageContext)	Set the top level QueryPart that is being rendered in the current Context.languageContext().
@NotNull DeleteWhereStep<R>	DeleteUsingStep.using(String sql, QueryPart... parts)	Add a USING clause to the query.
C	Context.visit(QueryPart part)	Visit a QueryPart in the current Context.
C	Context.visit(QueryPart part, ParamType paramType)	Visit a query part with a given value for Context.paramType().
C	Context.visitSubquery(QueryPart part)	Visit a QueryPart as a subquery in the current Context.
@NotNull CreateTriggerActionStep	CreateTriggerWhenStep.when(String when, QueryPart... parts)	Add the WHEN clause to the CREATE TRIGGER statement.
@NotNull MergeMatchedThenStep<R>	MergeMatchedStep.whenMatchedAnd(String sql, QueryPart... parts)	Add the WHEN MATCHED AND clause to the MERGE statement.
@NotNull CreateIndexFinalStep	CreateIndexWhereStep.where(String where, QueryPart... parts)	Add the WHERE clause to the CREATE INDEX statement.
@NotNull DeleteConditionStep<R>	DeleteWhereStep.where(String sql, QueryPart... parts)	Add conditions to the query.
@NotNull InsertOnConflictDoUpdateStep<R>	InsertOnConflictWhereIndexPredicateStep.where(String sql, QueryPart... parts)	Add a WHERE clause to supply an index predicate to the INSERT statement's ON CONFLICT … clause.
@NotNull InsertOnConflictConditionStep<R>	InsertOnConflictWhereStep.where(String sql, QueryPart... parts)	Add a WHERE clause to the INSERT statement's ON DUPLICATE KEY UPDATE or ON CONFLICT … DO UPDATE clause.
@NotNull SelectConditionStep<R>	SelectWhereStep.where(String sql, QueryPart... parts)	Add a WHERE clause to the query.
@NotNull Table<R>	Table.where(String sql, QueryPart... parts)	Add a WHERE clause to the table.
@NotNull UpdateConditionStep<R>	UpdateWhereStep.where(String sql, QueryPart... parts)	Add conditions to the query
@NotNull Table<R>	Table.with(String hint, QueryPart... parts)	Specify a SQL Server style table hint for query optimisation.
@NotNull Condition	Condition.xor(String sql, QueryPart... parts)	Combine this condition with another one using the Operator.XOR operator.

Method parameters in org.jooq with type arguments of type QueryPart

Modifier and Type	Method	Description
default @NotNull QueryPart	QueryPart.$replace(Function<? super QueryPart,? extends QueryPart> replacer)	Traverse a QueryPart hierarchy and recursively replace its elements by alternatives.
default @NotNull QueryPart	QueryPart.$replace(Function<? super QueryPart,? extends QueryPart> replacer)	Traverse a QueryPart hierarchy and recursively replace its elements by alternatives.
default <R> R	QueryPart.$traverse(Supplier<R> supplier, BiFunction<? super R,? super QueryPart,? extends R> before)	Traverser this QueryPart expression tree using a composable
static <T, R> Traverser<?,R>	Traversers.collecting(Collector<QueryPart,T,R> collector)	A traverser constructed from a Collector.
static @NotNull Traverser<?,?>	Traversers.consuming(Consumer<? super QueryPart> consumer)	A traverser that traverses the QueryPart tree without producing any results.
static @NotNull Traverser<?,Boolean>	Traversers.containing(Predicate<? super QueryPart> predicate)	A traverser that checks whether Predicate is satisfied by any QueryPart in the expression tree.
static @NotNull Traverser<?,List<QueryPart>>	Traversers.findingAll(Predicate<? super QueryPart> predicate)	A traverser that finds all QueryParts that satisfy a predicate within the traversed QueryPart tree.
static @NotNull Traverser<?,Optional<QueryPart>>	Traversers.findingAny(Predicate<? super QueryPart> predicate)	A traverser that finds any QueryPart that satisfies a predicate within the traversed QueryPart tree.
static final @NotNull Replacer	Replacers.listening(Replacer replacer, BiConsumer<? super QueryPart,? super QueryPart> replacement)	Wraps another Replacer, listening to all of the replacement events that it produces.
static final @NotNull Replacer	Replacers.listening(Replacer replacer, BiConsumer<? super QueryPart,? super QueryPart> replacement)	Wraps another Replacer, listening to all of the replacement events that it produces.
static Replacer	Replacer.of(Function<? super QueryPart,? extends QueryPart> replacer)	Convenience method to create a Replacer with a Replacer.replacer().
static Replacer	Replacer.of(Function<? super QueryPart,? extends QueryPart> replacer)	Convenience method to create a Replacer with a Replacer.replacer().
static Replacer	Replacer.of(Predicate<? super QueryPart> recurse, Function<? super QueryPart,? extends QueryPart> replacer)	Convenience method to create a Replacer with a Replacer.recurse() and Replacer.replacer().
static Replacer	Replacer.of(Predicate<? super QueryPart> recurse, Function<? super QueryPart,? extends QueryPart> replacer)	Convenience method to create a Replacer with a Replacer.recurse() and Replacer.replacer().
static Replacer	Replacer.of(Predicate<? super QueryPart> recurse, Function<? super QueryPart,? extends QueryPart> replacer)	Convenience method to create a Replacer with a Replacer.recurse() and Replacer.replacer().
static <A, R> Traverser<A,R>	Traverser.of(Supplier<A> supplier, Predicate<? super A> abort, Predicate<? super QueryPart> recurse, BiFunction<? super A,? super QueryPart,? extends A> before, BiFunction<? super A,? super QueryPart,? extends A> after, Function<? super A,? extends R> finisher)	Convenience method to create a Traverser with a Traverser.supplier(), Traverser.abort(), Traverser.recurse(), Traverser.before(), Traverser.after(), and Traverser.finisher().
static <A, R> Traverser<A,R>	Traverser.of(Supplier<A> supplier, Predicate<? super A> abort, Predicate<? super QueryPart> recurse, Predicate<? super QueryPart> recurseChildren, BiFunction<? super A,? super QueryPart,? extends A> before, BiFunction<? super A,? super QueryPart,? extends A> after, Function<? super A,? extends R> finisher)	Convenience method to create a Traverser with a Traverser.supplier(), Traverser.abort(), Traverser.recurse(), Traverser.recurseChildren(), Traverser.before(), Traverser.after(), and Traverser.finisher().
static <R> Traverser<R,R>	Traverser.of(Supplier<R> supplier, BiFunction<? super R,? super QueryPart,? extends R> before)	Convenience method to create a Traverser with a Traverser.supplier() and Traverser.before().
static <R> Traverser<R,R>	Traverser.of(Supplier<R> supplier, BiFunction<? super R,? super QueryPart,? extends R> before, BiFunction<? super R,? super QueryPart,? extends R> after)	Convenience method to create a Traverser with a Traverser.supplier(), Traverser.before(), and Traverser.after().
static <R> Traverser<R,R>	Traverser.of(Supplier<R> supplier, Predicate<? super R> abort, Predicate<? super QueryPart> recurse, BiFunction<? super R,? super QueryPart,? extends R> before)	Convenience method to create a Traverser with a Traverser.supplier(), Traverser.abort(), Traverser.recurse(), and Traverser.before().
static <R> Traverser<R,R>	Traverser.of(Supplier<R> supplier, Predicate<? super R> abort, Predicate<? super QueryPart> recurse, BiFunction<? super R,? super QueryPart,? extends R> before, BiFunction<? super R,? super QueryPart,? extends R> after)	Convenience method to create a Traverser with a Traverser.supplier(), Traverser.abort(), Traverser.recurse(), Traverser.before(), and Traverser.after()
static <A, R> Traverser<?,R>	Traversers.recursing(Predicate<? super QueryPart> recurse, Traverser<A,R> downstream)	Combine a recursion test predicate with an existing Traverser.
static <A, R> Traverser<?,R>	Traversers.recursingChildren(Predicate<? super QueryPart> recurseChildren, Traverser<A,R> downstream)	Combine a recursion test predicate with an existing Traverser.

Uses of QueryPart in org.jooq.impl

Classes in org.jooq.impl with type parameters of type QueryPart

Modifier and Type	Interface	Description
static interface	QOM.Aliasable<Q extends QueryPart>	A QueryPart that may associate an QOM.Aliasable.$alias() with the QOM.Aliasable.$aliased() part.
static interface	QOM.Tuple2<Q1 extends QueryPart,Q2 extends QueryPart>	A generic tuple of degree 2 for use in QOM types.
static interface	QOM.Tuple2<Q1 extends QueryPart,Q2 extends QueryPart>	A generic tuple of degree 2 for use in QOM types.
static interface	QOM.UnmodifiableCollection<Q extends QueryPart>	An unmodifiable Collection of QueryPart elements.
static interface	QOM.UnmodifiableList<Q extends QueryPart>	An unmodifiable List of QueryPart elements.
static interface	QOM.UnmodifiableMap<K extends QueryPart,V extends QueryPart>	An unmodifiable Map of QueryPart keys and values.
static interface	QOM.UnmodifiableMap<K extends QueryPart,V extends QueryPart>	An unmodifiable Map of QueryPart keys and values.

Subinterfaces of QueryPart in org.jooq.impl

Modifier and Type	Interface	Description
static interface	QOM.Abs<T extends Number>	The ABS function.
static interface	QOM.Acos	The ACOS function.
static interface	QOM.Acosh	The ACOSH function.
static interface	QOM.Acoth	The ACOTH function.
static interface	QOM.Add<T>	The ADD operator.
static interface	QOM.Aliasable<Q extends QueryPart>	A QueryPart that may associate an QOM.Aliasable.$alias() with the QOM.Aliasable.$aliased() part.
static interface	QOM.AlterDatabase	The ALTER DATABASE statement.
static interface	QOM.AlterDomain<T>	The ALTER DOMAIN statement.
static interface	QOM.AlterIndex	The ALTER INDEX statement.
static interface	QOM.AlterSchema	The ALTER SCHEMA statement.
static interface	QOM.AlterSequence<T extends Number>	The ALTER SEQUENCE statement.
static interface	QOM.AlterType	The ALTER TYPE statement.
static interface	QOM.AlterView	The ALTER VIEW statement.
static interface	QOM.And	The AND operator.
static interface	QOM.AnyValue<T>	The ANY VALUE function.
static interface	QOM.Array<T>
static interface	QOM.ArrayAgg<T>
static interface	QOM.ArrayAllMatch<T>	The ARRAY ALL MATCH function.
static interface	QOM.ArrayAnyMatch<T>	The ARRAY ANY MATCH function.
static interface	QOM.ArrayAppend<T>	The ARRAY APPEND function.
static interface	QOM.ArrayConcat<T>	The ARRAY CONCAT function.
static interface	QOM.ArrayFilter<T>	The ARRAY FILTER function.
static interface	QOM.ArrayGet<T>	The ARRAY GET function.
static interface	QOM.ArrayMap<T,U>	The ARRAY MAP function.
static interface	QOM.ArrayNoneMatch<T>	The ARRAY NONE MATCH function.
static interface	QOM.ArrayOverlap<T>	The ARRAY OVERLAP function.
static interface	QOM.ArrayPrepend<T>	The ARRAY PREPEND function.
static interface	QOM.ArrayQuery<T>
static interface	QOM.ArrayRemove<T>	The ARRAY REMOVE function.
static interface	QOM.ArrayReplace<T>	The ARRAY REPLACE function.
static interface	QOM.Ascii	The ASCII function.
static interface	QOM.Asin	The ASIN function.
static interface	QOM.Asinh	The ASINH function.
static interface	QOM.Assignment<T>
static interface	QOM.Atan	The ATAN function.
static interface	QOM.Atan2	The ATAN2 function.
static interface	QOM.Atanh	The ATANH function.
static interface	QOM.Avg	The AVG function.
static interface	QOM.Between<T>	The BETWEEN predicate.
static interface	QOM.BinaryBitLength	The BINARY BIT LENGTH function.
static interface	QOM.BinaryConcat	The BINARY CONCAT function.
static interface	QOM.BinaryLength	The BINARY LENGTH function.
static interface	QOM.BinaryLike	The BINARY LIKE operator.
static interface	QOM.BinaryLikeQuantified	The BINARY LIKE operator.
static interface	QOM.BinaryLtrim	The BINARY LTRIM function.
static interface	QOM.BinaryMd5	The BINARY MD5 function.
static interface	QOM.BinaryOctetLength	The BINARY OCTET LENGTH function.
static interface	QOM.BinaryOverlay	The BINARY OVERLAY function.
static interface	QOM.BinaryPosition	The BINARY POSITION function.
static interface	QOM.BinaryRtrim	The BINARY RTRIM function.
static interface	QOM.BinarySubstring	The BINARY SUBSTRING function.
static interface	QOM.BinaryTrim	The BINARY TRIM function.
static interface	QOM.BinToUuid	The BIN TO UUID function.
static interface	QOM.BitAnd<T extends Number>	The BIT AND operator.
static interface	QOM.BitAndAgg<T extends Number>	The BIT AND AGG function.
static interface	QOM.BitCount	The BIT COUNT function.
static interface	QOM.BitGet<T extends Number>	The BIT GET function.
static interface	QOM.BitLength	The BIT LENGTH function.
static interface	QOM.BitNand<T extends Number>	The BIT NAND operator.
static interface	QOM.BitNandAgg<T extends Number>	The BIT NAND AGG function.
static interface	QOM.BitNor<T extends Number>	The BIT NOR operator.
static interface	QOM.BitNorAgg<T extends Number>	The BIT NOR AGG function.
static interface	QOM.BitNot<T extends Number>	The BIT NOT operator.
static interface	QOM.BitOr<T extends Number>	The BIT OR operator.
static interface	QOM.BitOrAgg<T extends Number>	The BIT OR AGG function.
static interface	QOM.BitSet<T extends Number>	The BIT SET function.
static interface	QOM.BitXNor<T extends Number>	The BIT X NOR operator.
static interface	QOM.BitXNorAgg<T extends Number>	The BIT X NOR AGG function.
static interface	QOM.BitXor<T extends Number>	The BIT XOR operator.
static interface	QOM.BitXorAgg<T extends Number>	The BIT XOR AGG function.
static interface	QOM.BoolAnd	The BOOL AND function.
static interface	QOM.BoolOr	The BOOL OR function.
static interface	QOM.Call	The CALL statement.
static interface	QOM.Cardinality	The CARDINALITY function.
static interface	QOM.CaseSearched<T>
static interface	QOM.CaseSimple<V,T>
static interface	QOM.Cast<T>
static interface	QOM.Cbrt	The CBRT function.
static interface	QOM.Ceil<T extends Number>	The CEIL function.
static interface	QOM.CharLength	The CHAR LENGTH function.
static interface	QOM.Check	A CHECK constraint.
static interface	QOM.Choose<T>
static interface	QOM.Chr	The CHR function.
static interface	QOM.Coalesce<T>
static interface	QOM.Coerce<T>
static interface	QOM.Collated
static interface	QOM.Collect<T,A extends ArrayRecord<T>>
static interface	QOM.CombinedCondition<R extends QOM.CombinedCondition<R>>	A Condition consisting of two Condition operands and a binary logic Operator.
static interface	QOM.CommentOn	The COMMENT ON TABLE statement.
static interface	QOM.Commit	The COMMIT statement.
static interface	QOM.CompareCondition<T,R extends QOM.CompareCondition<T,R>>	A Condition consisting of two Field operands and a Comparator operator.
static interface	QOM.Concat
static interface	QOM.ConditionAsField	The FIELD function.
static interface	QOM.ConnectByIsCycle	The CONNECT BY ISCYCLE function.
static interface	QOM.ConnectByIsLeaf	The CONNECT BY ISLEAF function.
static interface	QOM.ConnectByRoot<T>	The CONNECT BY ROOT function.
static interface	QOM.Contains<T>	The CONTAINS operator.
static interface	QOM.ContainsIgnoreCase<T>	The CONTAINS IGNORE CASE operator.
static interface	QOM.Continue
static interface	QOM.Convert<T>
static interface	QOM.Corr	The CORR function.
static interface	QOM.Cos	The COS function.
static interface	QOM.Cosh	The COSH function.
static interface	QOM.Cot	The COT function.
static interface	QOM.Coth	The COTH function.
static interface	QOM.Count	The COUNT function.
static interface	QOM.CountTable
static interface	QOM.CovarPop	The COVAR POP function.
static interface	QOM.CovarSamp	The COVAR SAMP function.
static interface	QOM.CreateDatabase	The CREATE DATABASE statement.
static interface	QOM.CreateDomain<T>	The CREATE DOMAIN statement.
static interface	QOM.CreateFunction	The CREATE FUNCTION statement.
static interface	QOM.CreateIndex	The CREATE INDEX statement.
static interface	QOM.CreateProcedure	The CREATE PROCEDURE statement.
static interface	QOM.CreateSchema	The CREATE SCHEMA statement.
static interface	QOM.CreateSequence<T extends Number>	The CREATE SEQUENCE statement.
static interface	QOM.CreateSynonym	The CREATE SYNONYM statement.
static interface	QOM.CreateTable	The CREATE TABLE statement.
static interface	QOM.CreateTrigger	The CREATE TRIGGER statement.
static interface	QOM.CreateType	The CREATE TYPE statement.
static interface	QOM.CreateView<R extends Record>	The CREATE VIEW statement.
static interface	QOM.CrossApply<R extends Record>
static interface	QOM.CrossJoin<R extends Record>
static interface	QOM.Cube
static interface	QOM.CumeDist
static interface	QOM.CumeDistAgg	The CUME DIST function.
static interface	QOM.CurrentCatalog	The CURRENT CATALOG function.
static interface	QOM.CurrentDate<T>
static interface	QOM.CurrentSchema	The CURRENT SCHEMA function.
static interface	QOM.CurrentTime<T>
static interface	QOM.CurrentTimestamp<T>
static interface	QOM.CurrentUser	The CURRENT USER function.
static interface	QOM.DataChangeDeltaTable<R extends Record>
static interface	QOM.DateAdd<T>	The DATE ADD function.
static interface	QOM.Declaration<T>
static interface	QOM.Decode<V,T>
static interface	QOM.Default<T>
static interface	QOM.Degrees	The DEGREES function.
static interface	QOM.Delete<R extends Record>	The DELETE statement.
static interface	QOM.DeleteReturning<R extends Record>	An DELETE statement with a RETURNING clause.
static interface	QOM.Deleting	The DELETING function.
static interface	QOM.DenseRank
static interface	QOM.DenseRankAgg	The DENSE RANK function.
static interface	QOM.DerivedTable<R extends Record>
static interface	QOM.Digits	The DIGITS function.
static interface	QOM.Div<T>	The DIV operator.
static interface	QOM.DropDatabase	The DROP DATABASE statement.
static interface	QOM.DropDomain	The DROP DOMAIN statement.
static interface	QOM.DropFunction	The DROP FUNCTION statement.
static interface	QOM.DropIndex	The DROP INDEX statement.
static interface	QOM.DropProcedure	The DROP PROCEDURE statement.
static interface	QOM.DropSchema	The DROP SCHEMA statement.
static interface	QOM.DropSequence	The DROP SEQUENCE statement.
static interface	QOM.DropSynonym	The DROP SYNONYM statement.
static interface	QOM.DropTable	The DROP TABLE statement.
static interface	QOM.DropTrigger	The DROP TRIGGER statement.
static interface	QOM.DropType	The DROP TYPE statement.
static interface	QOM.DropView	The DROP VIEW statement.
static interface	QOM.Dual
static interface	QOM.EmptyGroupingSet
static interface	QOM.EndsWith<T>	The ENDS WITH operator.
static interface	QOM.EndsWithIgnoreCase<T>	The ENDS WITH IGNORE CASE operator.
static interface	QOM.Eq<T>	The EQ operator.
static interface	QOM.EqQuantified<T>	The EQ operator.
static interface	QOM.Euler	The E function.
static interface	QOM.Excluded<T>	The EXCLUDED function.
static interface	QOM.Execute	The EXECUTE function.
static interface	QOM.Exists	The EXISTS function.
static interface	QOM.Exit
static interface	QOM.Exp	The EXP function.
static interface	QOM.Extract
static interface	QOM.False	A Condition that is always FALSE.
static interface	QOM.FieldAlias<T>
static interface	QOM.FieldCondition	The CONDITION function.
static interface	QOM.FieldFunction<T>
static interface	QOM.FirstValue<T>
static interface	QOM.Floor<T extends Number>	The FLOOR function.
static interface	QOM.ForeignKey	A FOREIGN KEY constraint.
static interface	QOM.FullJoin<R extends Record>
static interface	QOM.Function<T>
static interface	QOM.Ge<T>	The GE operator.
static interface	QOM.GenerateSeries<T>
static interface	QOM.GeQuantified<T>	The GE operator.
static interface	QOM.Goto	The GOTO function.
static interface	QOM.Grant	The GRANT statement.
static interface	QOM.Greatest<T>
static interface	QOM.GroupingSets
static interface	QOM.Gt<T>	The GT operator.
static interface	QOM.GtQuantified<T>	The GT operator.
static interface	QOM.HintedTable<R extends Record>	A table with a MySQL style index access hint.
static interface	QOM.If
static interface	QOM.Iif<T>
static interface	QOM.In<T>	The IN operator.
static interface	QOM.InList<T>	The IN predicate accepting a list of values.
static interface	QOM.Insert<R extends Record>	The INSERT statement.
static interface	QOM.Inserting	The INSERTING function.
static interface	QOM.InsertReturning<R extends Record>	An INSERT statement with a RETURNING clause.
static interface	QOM.IsDistinctFrom<T>	The IS DISTINCT FROM operator.
static interface	QOM.IsDocument	The IS DOCUMENT operator.
static interface	QOM.IsJson	The IS JSON operator.
static interface	QOM.IsNotDistinctFrom<T>	The IS NOT DISTINCT FROM operator.
static interface	QOM.IsNotDocument	The IS NOT DOCUMENT operator.
static interface	QOM.IsNotJson	The IS NOT JSON operator.
static interface	QOM.IsNotNull	The IS NOT NULL operator.
static interface	QOM.IsNull	The IS NULL operator.
static interface	QOM.Join<R extends Record>
static interface	QOM.JoinTable<R extends Record,J extends QOM.JoinTable<R,J>>
static interface	QOM.JSONArray<T>	The JSON ARRAY function.
static interface	QOM.JSONArrayAgg<J>
static interface	QOM.JSONArrayLength	The JSON ARRAY LENGTH function.
static interface	QOM.JSONBArrayLength	The JSONB ARRAY LENGTH function.
static interface	QOM.JSONBGetAttribute	The JSONB GET ATTRIBUTE function.
static interface	QOM.JSONBGetAttributeAsText	The JSONB GET ATTRIBUTE AS TEXT function.
static interface	QOM.JSONBGetElement	The JSONB GET ELEMENT function.
static interface	QOM.JSONBGetElementAsText	The JSONB GET ELEMENT AS TEXT function.
static interface	QOM.JSONBInsert	The JSONB INSERT function.
static interface	QOM.JSONBKeyExists	The JSONB KEY EXISTS function.
static interface	QOM.JSONBKeys	The JSONB KEYS function.
static interface	QOM.JSONBRemove	The JSONB REMOVE function.
static interface	QOM.JSONBReplace	The JSONB REPLACE function.
static interface	QOM.JSONBSet	The JSONB SET function.
static interface	QOM.JSONGetAttribute	The JSON GET ATTRIBUTE function.
static interface	QOM.JSONGetAttributeAsText	The JSON GET ATTRIBUTE AS TEXT function.
static interface	QOM.JSONGetElement	The JSON GET ELEMENT function.
static interface	QOM.JSONGetElementAsText	The JSON GET ELEMENT AS TEXT function.
static interface	QOM.JSONInsert	The JSON INSERT function.
static interface	QOM.JSONKeyExists	The JSON KEY EXISTS function.
static interface	QOM.JSONKeys	The JSON KEYS function.
static interface	QOM.JSONObject<T>	The JSON OBJECT function.
static interface	QOM.JSONObjectAgg<J>
static interface	QOM.JSONRemove	The JSON REMOVE function.
static interface	QOM.JSONReplace	The JSON REPLACE function.
static interface	QOM.JSONSet	The JSON SET function.
static interface	QOM.Label
static interface	QOM.LabelledStatement
static interface	QOM.Lag<T>
static interface	QOM.LastValue<T>
static interface	QOM.Lateral<R extends Record>
static interface	QOM.Le<T>	The LE operator.
static interface	QOM.Lead<T>
static interface	QOM.Least<T>
static interface	QOM.Left	The LEFT function.
static interface	QOM.LeftAntiJoin<R extends Record>
static interface	QOM.LeftJoin<R extends Record>
static interface	QOM.LeftSemiJoin<R extends Record>
static interface	QOM.LeQuantified<T>	The LE operator.
static interface	QOM.Level	The LEVEL function.
static interface	QOM.Like	The LIKE operator.
static interface	QOM.LikeIgnoreCase	The LIKE IGNORE CASE operator.
static interface	QOM.LikeQuantified	The LIKE operator.
static interface	QOM.LinkedTable<R extends Record>	A table with a database link.
static interface	QOM.Ln	The LN function.
static interface	QOM.Log	The LOG function.
static interface	QOM.Log10	The LOG10 function.
static interface	QOM.Loop
static interface	QOM.Lower	The LOWER function.
static interface	QOM.Lpad	The LPAD function.
static interface	QOM.Lt<T>	The LT operator.
static interface	QOM.LtQuantified<T>	The LT operator.
static interface	QOM.Ltrim	The LTRIM function.
static interface	QOM.Max<T>	The MAX function.
static interface	QOM.MaxBy<T>	The MAX BY function.
static interface	QOM.Md5	The MD5 function.
static interface	QOM.Median	The MEDIAN function.
static interface	QOM.Min<T>	The MIN function.
static interface	QOM.MinBy<T>	The MIN BY function.
static interface	QOM.Mod<T extends Number>	The MOD operator.
static interface	QOM.Mode<T>
static interface	QOM.Mul<T>	The MUL operator.
static interface	QOM.Multiset<R extends Record>
static interface	QOM.MultisetAgg<R extends Record>
static interface	QOM.NaturalFullJoin<R extends Record>
static interface	QOM.NaturalJoin<R extends Record>
static interface	QOM.NaturalLeftJoin<R extends Record>
static interface	QOM.NaturalRightJoin<R extends Record>
static interface	QOM.Ne<T>	The NE operator.
static interface	QOM.Neg<T>
static interface	QOM.NeQuantified<T>	The NE operator.
static interface	QOM.Not	The NOT operator.
static interface	QOM.NotBinaryLike	The NOT BINARY LIKE operator.
static interface	QOM.NotBinaryLikeQuantified	The NOT BINARY LIKE operator.
static interface	QOM.NotField	The NOT operator.
static interface	QOM.NotIn<T>	The NOT IN operator.
static interface	QOM.NotInList<T>	The NOT IN predicate accepting a list of values.
static interface	QOM.NotLike	The NOT LIKE operator.
static interface	QOM.NotLikeIgnoreCase	The NOT LIKE IGNORE CASE operator.
static interface	QOM.NotLikeQuantified	The NOT LIKE operator.
static interface	QOM.NotSimilarTo	The NOT SIMILAR TO operator.
static interface	QOM.NotSimilarToQuantified	The NOT SIMILAR TO operator.
static interface	QOM.NthValue<T>
static interface	QOM.Ntile
static interface	QOM.Null	A Condition that is always NULL.
static interface	QOM.Nullif<T>	The NULLIF function.
static interface	QOM.NullStatement
static interface	QOM.Nvl<T>	The NVL function.
static interface	QOM.Nvl2<T>
static interface	QOM.OctetLength	The OCTET LENGTH function.
static interface	QOM.Or	The OR operator.
static interface	QOM.OuterApply<R extends Record>
static interface	QOM.Overlay	The OVERLAY function.
static interface	QOM.PercentileCont	The PERCENTILE CONT function.
static interface	QOM.PercentileDisc	The PERCENTILE DISC function.
static interface	QOM.PercentRank
static interface	QOM.PercentRankAgg	The PERCENT RANK function.
static interface	QOM.Pi	The PI function.
static interface	QOM.PlusJoin<T>	The PLUS operator.
static interface	QOM.Position	The POSITION function.
static interface	QOM.Power	The POWER operator.
static interface	QOM.PrimaryKey	A PRIMARY KEY constraint.
static interface	QOM.Prior<T>	The PRIOR function.
static interface	QOM.Product	The PRODUCT function.
static interface	QOM.QualifiedJoin<R extends Record,J extends QOM.QualifiedJoin<R,J>>
static interface	QOM.QualifiedRowid	The ROWID operator.
static interface	QOM.Quantified
static interface	QOM.QuantifiedArray<T>
static interface	QOM.QuantifiedSelect<R extends Record>
static interface	QOM.Radians	The RADIANS function.
static interface	QOM.Rand	The RAND function.
static interface	QOM.Rank
static interface	QOM.RankAgg	The RANK function.
static interface	QOM.RatioToReport
static interface	QOM.RegexpLike
static interface	QOM.RegrAvgX	The REGR AVGX function.
static interface	QOM.RegrAvgY	The REGR AVGY function.
static interface	QOM.RegrCount	The REGR COUNT function.
static interface	QOM.RegrIntercept	The REGR INTERCEPT function.
static interface	QOM.RegrR2	The REGR R2 function.
static interface	QOM.RegrSlope	The REGR SLOPE function.
static interface	QOM.RegrSxx	The REGR SXX function.
static interface	QOM.RegrSxy	The REGR SXY function.
static interface	QOM.RegrSyy	The REGR SYY function.
static interface	QOM.ReleaseSavepoint	The RELEASE SAVEPOINT statement.
static interface	QOM.Repeat	The REPEAT function.
static interface	QOM.Replace	The REPLACE function.
static interface	QOM.Return	The RETURN_ function.
static interface	QOM.Reverse	The REVERSE function.
static interface	QOM.Revoke	The REVOKE statement.
static interface	QOM.Right	The RIGHT function.
static interface	QOM.RightJoin<R extends Record>
static interface	QOM.Rollback	The ROLLBACK statement.
static interface	QOM.Rollup
static interface	QOM.Root	The ROOT function.
static interface	QOM.Round<T extends Number>	The ROUND function.
static interface	QOM.RowAsField<R extends Record>
static interface	QOM.RowAssignment
static interface	QOM.RowEq<T extends Row>	The ROW EQ operator.
static interface	QOM.RowGe<T extends Row>	The ROW GE operator.
static interface	QOM.RowGt<T extends Row>	The ROW GT operator.
static interface	QOM.RowIsNotNull
static interface	QOM.RowIsNull
static interface	QOM.RowLe<T extends Row>	The ROW LE operator.
static interface	QOM.RowLt<T extends Row>	The ROW LT operator.
static interface	QOM.RowNe<T extends Row>	The ROW NE operator.
static interface	QOM.Rownum	The ROWNUM function.
static interface	QOM.RowNumber
static interface	QOM.RowOverlaps
static interface	QOM.RowsFrom
static interface	QOM.RowSubquery
static interface	QOM.Rpad	The RPAD function.
static interface	QOM.Rtrim	The RTRIM function.
static interface	QOM.Savepoint	The SAVEPOINT statement.
static interface	QOM.ScalarSubquery<T>
static interface	QOM.SelectIsNotNull
static interface	QOM.SelectIsNull
static interface	QOM.SetCatalog	The SET CATALOG statement.
static interface	QOM.SetCommand	The SET statement.
static interface	QOM.SetSchema	The SET SCHEMA statement.
static interface	QOM.Shl<T extends Number>	The SHL operator.
static interface	QOM.Shr<T extends Number>	The SHR operator.
static interface	QOM.Sign	The SIGN function.
static interface	QOM.Signal	The SIGNAL SQL STATE function.
static interface	QOM.SimilarTo	The SIMILAR TO operator.
static interface	QOM.SimilarToQuantified	The SIMILAR TO operator.
static interface	QOM.Sin	The SIN function.
static interface	QOM.Sinh	The SINH function.
static interface	QOM.Space	The SPACE function.
static interface	QOM.SplitPart	The SPLIT PART function.
static interface	QOM.Sqrt	The SQRT function.
static interface	QOM.Square<T extends Number>	The SQUARE function.
static interface	QOM.StArea	The ST AREA function.
static interface	QOM.StartsWith<T>	The STARTS WITH operator.
static interface	QOM.StartsWithIgnoreCase<T>	The STARTS WITH IGNORE CASE operator.
static interface	QOM.StartTransaction	The START TRANSACTION statement.
static interface	QOM.StAsBinary	The ST ASBINARY function.
static interface	QOM.StAsText	The ST ASTEXT function.
static interface	QOM.StBoundary<T extends Spatial>	The ST BOUNDARY function.
static interface	QOM.StCentroid	The ST CENTROID function.
static interface	QOM.StContains<T extends Spatial>	The ST CONTAINS function.
static interface	QOM.StCoveredBy<T extends Spatial>	The ST COVEREDBY function.
static interface	QOM.StCovers<T extends Spatial>	The ST COVERS function.
static interface	QOM.StCrosses	The ST CROSSES function.
static interface	QOM.StddevPop	The STDDEV POP function.
static interface	QOM.StddevSamp	The STDDEV SAMP function.
static interface	QOM.StDifference<T extends Spatial>	The ST DIFFERENCE function.
static interface	QOM.StDimension	The ST DIMENSION function.
static interface	QOM.StDisjoint<T extends Spatial>	The ST DISJOINT function.
static interface	QOM.StDistance<T extends Spatial>	The ST DISTANCE function.
static interface	QOM.StEndPoint<T extends Spatial>	The ST ENDPOINT function.
static interface	QOM.StEquals<T extends Spatial>	The ST EQUALS function.
static interface	QOM.StExteriorRing	The ST EXTERIORRING function.
static interface	QOM.StGeometryN<T extends Spatial>	The ST GEOMETRYN function.
static interface	QOM.StGeometryType	The ST GEOMETRYTYPE function.
static interface	QOM.StGeomFromText	The ST GEOMFROMTEXT function.
static interface	QOM.StGeomFromWKB	The ST GEOMFROMWKB function.
static interface	QOM.StInteriorRingN	The ST INTERIORRINGN function.
static interface	QOM.StIntersection<T extends Spatial>	The ST INTERSECTION function.
static interface	QOM.StIntersects<T extends Spatial>	The ST INTERSECTS function.
static interface	QOM.StIsClosed	The ST ISCLOSED function.
static interface	QOM.StIsEmpty	The ST ISEMPTY function.
static interface	QOM.StIsRing	The ST ISRING function.
static interface	QOM.StIsSimple	The ST ISSIMPLE function.
static interface	QOM.StIsValid	The ST ISVALID function.
static interface	QOM.StLength	The ST LENGTH function.
static interface	QOM.StNumGeometries	The ST NUMGEOMETRIES function.
static interface	QOM.StNumInteriorRings	The ST NUMINTERIORRING function.
static interface	QOM.StNumPoints	The ST NUMPOINTS function.
static interface	QOM.StOverlaps<T extends Spatial>	The ST OVERLAPS function.
static interface	QOM.StPerimeter<T extends Spatial>	The ST PERIMETER function.
static interface	QOM.StPointN<T extends Spatial>	The ST POINTN function.
static interface	QOM.StraightJoin<R extends Record>
static interface	QOM.StSrid	The ST SRID function.
static interface	QOM.StStartPoint<T extends Spatial>	The ST STARTPOINT function.
static interface	QOM.StTouches<T extends Spatial>	The ST TOUCHES function.
static interface	QOM.StTransform<T extends Spatial>	The ST TRANSFORM function.
static interface	QOM.StUnion<T extends Spatial>	The ST UNION function.
static interface	QOM.StWithin<T extends Spatial>	The ST WITHIN function.
static interface	QOM.StX	The ST X function.
static interface	QOM.StXMax	The ST XMAX function.
static interface	QOM.StXMin	The ST XMIN function.
static interface	QOM.StY	The ST Y function.
static interface	QOM.StYMax	The ST YMAX function.
static interface	QOM.StYMin	The ST YMIN function.
static interface	QOM.StZ	The ST Z function.
static interface	QOM.StZMax	The ST ZMAX function.
static interface	QOM.StZMin	The ST ZMIN function.
static interface	QOM.Sub<T>	The SUB operator.
static interface	QOM.Substring	The SUBSTRING function.
static interface	QOM.SubstringIndex	The SUBSTRING INDEX function.
static interface	QOM.Sum	The SUM function.
static interface	QOM.SysConnectByPath	The SYS CONNECT BY PATH function.
static interface	QOM.TableAlias<R extends Record>
static interface	QOM.TableAsField<R extends Record>
static interface	QOM.TableEq<R extends Record>	The EQ operator.
static interface	QOM.TableNe<R extends Record>	The NE operator.
static interface	QOM.Tan	The TAN function.
static interface	QOM.Tanh	The TANH function.
static interface	QOM.Tau	The TAU function.
static interface	QOM.TimestampDiff<T>
static interface	QOM.ToChar	The TO CHAR function.
static interface	QOM.ToDate	The TO DATE function.
static interface	QOM.ToHex	The TO HEX function.
static interface	QOM.ToTimestamp	The TO TIMESTAMP function.
static interface	QOM.Translate	The TRANSLATE function.
static interface	QOM.Trim	The TRIM function.
static interface	QOM.True	A Condition that is always TRUE.
static interface	QOM.Trunc<T extends Number>	The TRUNC function.
static interface	QOM.Truncate<R extends Record>	The TRUNCATE statement.
static interface	QOM.TryCast<T>	The TRY CAST function.
static interface	QOM.Tuple2<Q1 extends QueryPart,Q2 extends QueryPart>	A generic tuple of degree 2 for use in QOM types.
(package private) static interface	org.jooq.impl.QOM.UCommutativeOperator<Q,R extends org.jooq.impl.QOM.UCommutativeOperator<Q,R>>	A binary QOM.UOperator2 whose operands can be swapped using QOM.UCommutativeOperator.$swap() without changing the operator's semantics.
(package private) static interface	org.jooq.impl.QOM.UConvertibleOperator<Q,R extends org.jooq.impl.QOM.UConvertibleOperator<Q,R,C>,C extends org.jooq.impl.QOM.UConvertibleOperator<Q,C,R>>	A binary QOM.UOperator2 whose operands can be swapped using QOM.UConvertibleOperator.$converse() producing the converse relation.
(package private) static interface	org.jooq.impl.QOM.UEmpty
static interface	QOM.Unique	The UNIQUE function.
static interface	QOM.UniqueKey	A UNIQUE constraint.
static interface	QOM.UnmodifiableCollection<Q extends QueryPart>	An unmodifiable Collection of QueryPart elements.
static interface	QOM.UnmodifiableList<Q extends QueryPart>	An unmodifiable List of QueryPart elements.
static interface	QOM.UnmodifiableMap<K extends QueryPart,V extends QueryPart>	An unmodifiable Map of QueryPart keys and values.
(package private) static interface	org.jooq.impl.QOM.UOperator<R extends QueryPart>
(package private) static interface	org.jooq.impl.QOM.UOperator0<R extends org.jooq.impl.QOM.UOperator0<R>>
(package private) static interface	org.jooq.impl.QOM.UOperator1<Q1,R extends org.jooq.impl.QOM.UOperator1<Q1,R>>
(package private) static interface	org.jooq.impl.QOM.UOperator2<Q1,Q2,R extends org.jooq.impl.QOM.UOperator2<Q1,Q2,R>>
(package private) static interface	org.jooq.impl.QOM.UOperator3<Q1,Q2,Q3,R extends org.jooq.impl.QOM.UOperator3<Q1,Q2,Q3,R>>
(package private) static interface	org.jooq.impl.QOM.UOperator4<Q1,Q2,Q3,Q4,R extends org.jooq.impl.QOM.UOperator4<Q1,Q2,Q3,Q4,R>>
static interface	QOM.Update<R extends Record>	The UPDATE statement.
static interface	QOM.UpdateReturning<R extends Record>	An UPDATE statement with a RETURNING clause.
static interface	QOM.Updating	The UPDATING function.
static interface	QOM.Upper	The UPPER function.
(package private) static interface	org.jooq.impl.QOM.UReturnsNullOnNullInput	A marker interface for QueryPart implementations that represent functions or operators who evaluate to NULL as soon as at least one argument is NULL.
static interface	QOM.Uuid	The UUID function.
static interface	QOM.UuidToBin	The UUID TO BIN function.
static interface	QOM.Values<R extends Record>
static interface	QOM.VarPop	The VAR POP function.
static interface	QOM.VarSamp	The VAR SAMP function.
static interface	QOM.WidthBucket<T extends Number>	The WIDTH BUCKET function.
static interface	QOM.WindowFunction<T>
static interface	QOM.With	A WITH clause of a Select, QOM.Insert, QOM.Update, or QOM.Delete statement.
static interface	QOM.WithOrdinalityTable<R extends Record>	A collection derived table or table valued function with a WITH ORDINALITY clause.
static interface	QOM.WithTable<R extends Record>	A table with a T-SQL style WITH hint.
static interface	QOM.XMLAgg
static interface	QOM.XMLComment	The XMLCOMMENT function.
static interface	QOM.XMLConcat	The XMLCONCAT function.
static interface	QOM.XMLDocument	The XMLDOCUMENT function.
static interface	QOM.XMLElement
static interface	QOM.XMLExists
static interface	QOM.XMLForest	The XMLFOREST function.
static interface	QOM.XMLParse
static interface	QOM.XMLPi	The XMLPI function.
static interface	QOM.XMLQuery
static interface	QOM.XMLSerialize<T>	The XMLSERIALIZE function.
static interface	QOM.Xor	The XOR operator.

Classes in org.jooq.impl that implement QueryPart

Modifier and Type	Class	Description
class	AbstractRoutine<T>	A common base class for stored procedures
class	BuiltInDataType<T>	An internal marker subtype of DefaultDataType, to be used only by built-in data types in SQLDataType and dialect specific data type classes, such as e.g.
class	CatalogImpl	A common base class for database catalogs
class	CustomCondition	A base class for custom Condition implementations in client code.
class	CustomField<T>	A base class for custom Field implementations in client code.
class	CustomQueryPart	A base class for custom QueryPart implementations in client code.
class	CustomStatement	A base class for custom Statement implementations in client code.
class	CustomTable<R extends TableRecord<R>>	A base class for custom Table implementations in client code.
class	DefaultDataType<T>	A common base class for data types.
final class	LazyCatalog	A schema that references a lazy initialisable Catalog singleton, for use in generated code.
final class	LazySchema	A schema that references a lazy initialisable Schema singleton, for use in generated code.
class	PackageImpl	A default implementation for packages (containers of stored procedures and functions)
class	SchemaImpl	A common base class for database schemata
class	SequenceImpl<T extends Number>	A common base class for sequences
class	TableImpl<R extends Record>	A common base type for tables
class	UDTImpl<R extends UDTRecord<R>>	A common base type for UDT's
class	UDTPathFieldImpl<R extends Record,U extends UDTRecord<U>,T>	A common base type for UDT path fields.
class	UDTPathTableFieldImpl<R extends Record,U extends UDTRecord<U>,T>	A common base type for table fields that are also UDTPathField.

Methods in org.jooq.impl with type parameters of type QueryPart

Modifier and Type	Method	Description
static <Q1 extends QueryPart, QR extends QueryPart> @NotNull Lambda1<Q1,QR>	DSL.lambda(Q1 arg1, QR result)
static <Q1 extends QueryPart, QR extends QueryPart> @NotNull Lambda1<Q1,QR>	DSL.lambda(Q1 arg1, QR result)
static final <Q1 extends QueryPart, Q2 extends QueryPart> QOM.Tuple2<Q1,Q2>	QOM.tuple(Q1 q1, Q2 q2)
static final <Q1 extends QueryPart, Q2 extends QueryPart> QOM.Tuple2<Q1,Q2>	QOM.tuple(Q1 q1, Q2 q2)
static final <Q extends QueryPart> QOM.UnmodifiableList<Q>	QOM.unmodifiable(Collection<Q> collection)	Turn a Collection into an unmodifiable QOM.UnmodifiableList.
static final <Q extends QueryPart> QOM.UnmodifiableList<Q>	QOM.unmodifiable(List<Q> list)	Turn a List into an unmodifiable QOM.UnmodifiableList.
static final <K extends QueryPart, V extends QueryPart> QOM.UnmodifiableMap<K,V>	QOM.unmodifiable(Map<K,V> map)	Turn a Map into an unmodifiable QOM.UnmodifiableMap.
static final <K extends QueryPart, V extends QueryPart> QOM.UnmodifiableMap<K,V>	QOM.unmodifiable(Map<K,V> map)	Turn a Map into an unmodifiable QOM.UnmodifiableMap.
static final <Q extends QueryPart> QOM.UnmodifiableList<Q>	QOM.unmodifiable(Q[] array)	Turn an array into an unmodifiable QOM.UnmodifiableList.

Methods in org.jooq.impl that return QueryPart

Modifier and Type	Method	Description
final QueryPart	LazyCatalog.$replace(Replacer replacer)
final QueryPart	LazySchema.$replace(Replacer replacer)
final QueryPart	PackageImpl.$replace(Replacer replacer)
static @NotNull QueryPart	DSL.inlined(QueryPart part)	Inline all bind variables produced by the argument QueryPart.
static @NotNull QueryPart	DSL.list(Collection<? extends QueryPart> parts)	Compose a list of QueryParts into a new QueryPart, with individual parts being comma-separated.
static @NotNull QueryPart	DSL.list(QueryPart... parts)	Compose a list of QueryParts into a new QueryPart, with individual parts being comma-separated.

Methods in org.jooq.impl with parameters of type QueryPart

Modifier and Type	Method	Description
static @NotNull Condition	DSL.condition(String sql, QueryPart... parts)	A custom SQL clause that can render arbitrary SQL elements.
int	DefaultDSLContext.execute(String sql, QueryPart... parts)
List<Object>	DefaultDSLContext.extractBindValues(QueryPart part)
Param<?>	DefaultDSLContext.extractParam(QueryPart part, String name)
Map<String,Param<?>>	DefaultDSLContext.extractParams(QueryPart part)
Result<Record>	DefaultDSLContext.fetch(String sql, QueryPart... parts)
CompletionStage<Result<Record>>	DefaultDSLContext.fetchAsync(String sql, QueryPart... parts)
CompletionStage<Result<Record>>	DefaultDSLContext.fetchAsync(Executor executor, String sql, QueryPart... parts)
Cursor<Record>	DefaultDSLContext.fetchLazy(String sql, QueryPart... parts)
Results	DefaultDSLContext.fetchMany(String sql, QueryPart... parts)
Record	DefaultDSLContext.fetchOne(String sql, QueryPart... parts)
Optional<Record>	DefaultDSLContext.fetchOptional(String sql, QueryPart... parts)
Optional<?>	DefaultDSLContext.fetchOptionalValue(String sql, QueryPart... parts)
Record	DefaultDSLContext.fetchSingle(String sql, QueryPart... parts)
Stream<Record>	DefaultDSLContext.fetchStream(String sql, QueryPart... parts)
Object	DefaultDSLContext.fetchValue(String sql, QueryPart... parts)
List<?>	DefaultDSLContext.fetchValues(String sql, QueryPart... parts)
static <T> @NotNull Field<T>	DSL.field(String sql, Class<T> type, QueryPart... parts)	A custom SQL clause that can render arbitrary SQL elements.
static <T> @NotNull Field<T>	DSL.field(String sql, DataType<T> type, QueryPart... parts)	Create a "plain SQL" field.
static @NotNull Field<Object>	DSL.field(String sql, QueryPart... parts)	A custom SQL clause that can render arbitrary SQL elements.
static final int	Internal.hash(QueryPart part)	Return a non-negative hash code for a QueryPart, taking into account FindBugs' RV_ABSOLUTE_VALUE_OF_HASHCODE pattern
static @NotNull QueryPart	DSL.inlined(QueryPart part)	Inline all bind variables produced by the argument QueryPart.
static @NotNull QueryPart	DSL.list(QueryPart... parts)	Compose a list of QueryParts into a new QueryPart, with individual parts being comma-separated.
RowCountQuery	DefaultDSLContext.query(String sql, QueryPart... parts)
static @NotNull RowCountQuery	DSL.query(String sql, QueryPart... parts)	Create a new query holding plain SQL.
String	DefaultDSLContext.render(QueryPart part)
String	DefaultDSLContext.renderInlined(QueryPart part)
String	DefaultDSLContext.renderNamedOrInlinedParams(QueryPart part)
String	DefaultDSLContext.renderNamedParams(QueryPart part)
ResultQuery<Record>	DefaultDSLContext.resultQuery(String sql, QueryPart... parts)
static @NotNull ResultQuery<Record>	DSL.resultQuery(String sql, QueryPart... parts)	Create a new query holding plain SQL.
SelectWhereStep<Record>	DefaultDSLContext.selectFrom(String sql, QueryPart... parts)
static @NotNull SelectWhereStep<Record>	DSL.selectFrom(String sql, QueryPart... parts)	Create a new DSL select statement, projecting *.
static @NotNull SQL	DSL.sql(String sql, QueryPart... parts)	A custom SQL clause that can render arbitrary expressions.
static @NotNull Statement	DSL.statement(String sql, QueryPart... parts)	A custom procedural fragment that can render arbitrary statements.
static @NotNull Table<Record>	DSL.table(String sql, QueryPart... parts)	A custom SQL clause that can render arbitrary table expressions.
static final <Q extends QueryPart> QOM.UnmodifiableList<Q>	QOM.unmodifiable(Q[] array)	Turn an array into an unmodifiable QOM.UnmodifiableList.

Method parameters in org.jooq.impl with type arguments of type QueryPart

Modifier and Type	Method	Description
static @NotNull QueryPart	DSL.list(Collection<? extends QueryPart> parts)	Compose a list of QueryParts into a new QueryPart, with individual parts being comma-separated.