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

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	Collation	A collation.
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	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	A step in the construction of the CREATE SEQUENCE statement.
interface	CreateTableColumnStep	A Query that can create tables.
interface	CreateTableCommentStep	A Query that can create tables.
interface	CreateTableConstraintStep	A Query that can create tables.
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	CreateTableIndexStep	A Query that can create tables.
interface	CreateTableOnCommitStep	A Query that can create tables.
interface	CreateTableStorageStep	A Query that can create tables.
interface	CreateTableWithDataStep	A Query that can create tables.
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	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 Query that can drop types.
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	A common base type for Field and Constraint where DSL API accepts both types alike.
interface	FieldOrRow	A common base type for Field and Row where DSL API accepts both types alike.
interface	ForeignKey<R extends Record,O 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	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	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	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	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	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	Table<R extends Record>	A table.
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	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	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	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 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.
@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.
@Nullable QueryPart	Context.scopeMapping(QueryPart part)	Retrieve the registered mapping for a query part in the current scope, or null if no such mapping exists.

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 subtree, 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 sql, QueryPart... parts)	Add an 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 TableOnStep<Record>	Table.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 TableOnStep<Record>	Table.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.
@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.
@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.
@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 TableOnStep<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 TableOnStep<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 TableOnStep<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 TableOnStep<Record>	TableOuterJoinStep.rightOuterJoin(String sql, QueryPart... parts)	RIGHT OUTER JOIN a table to this table.
@Nullable QueryPart	Context.scopeMapping(QueryPart part)	Retrieve the registered mapping for a query part in the current scope, or null if no such mapping exists.
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).
@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 sql, QueryPart... parts)	Add vendor-specific storage clauses 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.
@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.

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<?,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 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 <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()

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.UnmodifiableCollection<Q extends QueryPart>	An unmodifiable Collection of QueryPart elements.
static interface	QOM.UnmodifiableList<Q extends QueryPart>	An unmodifiable List of QueryPart elements.

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.Add<T>	The ADD operator.
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.ArrayGet<T>	The ARRAY GET function.
static interface	QOM.ArrayQuery<T>
static interface	QOM.Ascii	The ASCII function.
static interface	QOM.Asin	The ASIN function.
static interface	QOM.Assignment<T>
static interface	QOM.Atan	The ATAN function.
static interface	QOM.Atan2	The ATAN2 function.
static interface	QOM.Avg	The AVG function.
static interface	QOM.Between<T>
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.BitLength	The BIT LENGTH function.
static interface	QOM.BitNand<T extends Number>	The BIT NAND operator.
static interface	QOM.BitNor<T extends Number>	The BIT NOR operator.
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.BitXNor<T extends Number>	The BIT X NOR operator.
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.Cast<T>
static interface	QOM.Ceil<T extends Number>	The CEIL function.
static interface	QOM.CharLength	The CHAR LENGTH function.
static interface	QOM.Check
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
static interface	QOM.CommentOn	The COMMENT ON TABLE statement.
static interface	QOM.CompareCondition<T>
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	The CREATE SEQUENCE statement.
static interface	QOM.CreateTrigger	The CREATE TRIGGER statement.
static interface	QOM.CreateType
static interface	QOM.CreateView<R extends Record>
static interface	QOM.Cube
static interface	QOM.CumeDist
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.Default<T>
static interface	QOM.Degrees	The DEGREES function.
static interface	QOM.Deleting	The DELETING function.
static interface	QOM.DenseRank
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.DropTable	The DROP TABLE statement.
static interface	QOM.DropTrigger	The DROP TRIGGER statement.
static interface	QOM.DropType
static interface	QOM.DropView	The DROP VIEW statement.
static interface	QOM.Dual
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.Euler	The E 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.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
static interface	QOM.Function<T>
static interface	QOM.Ge<T>	The GE operator.
static interface	QOM.GenerateSeries<T>
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.If
static interface	QOM.Iif<T>
static interface	QOM.In<T>	The IN operator.
static interface	QOM.Inline<T>
static interface	QOM.InList<T>
static interface	QOM.Inserting	The INSERTING function.
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.JSONArray<T>	The JSON ARRAY function.
static interface	QOM.JSONArrayAgg<J>
static interface	QOM.JSONObject<T>	The JSON OBJECT function.
static interface	QOM.JSONObjectAgg<J>
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.Level	The LEVEL function.
static interface	QOM.Like	The LIKE operator.
static interface	QOM.LikeIgnoreCase	The LIKE IGNORE CASE operator.
static interface	QOM.LinkedTable<R extends Record>
static interface	QOM.Log	The LN 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.Ltrim	The LTRIM function.
static interface	QOM.Max<T>	The MAX 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.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.Ne<T>	The NE operator.
static interface	QOM.Neg<T>
static interface	QOM.Not	The NOT operator.
static interface	QOM.NotField	The NOT operator.
static interface	QOM.NotIn<T>	The NOT IN operator.
static interface	QOM.NotInList<T>
static interface	QOM.NotLike	The NOT LIKE operator.
static interface	QOM.NotLikeIgnoreCase	The NOT LIKE IGNORE CASE operator.
static interface	QOM.NotSimilarTo	The NOT SIMILAR TO operator.
static interface	QOM.NthValue<T>
static interface	QOM.Ntile
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.Overlay	The OVERLAY function.
static interface	QOM.PercentRank
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
static interface	QOM.Prior<T>	The PRIOR function.
static interface	QOM.Product	The PRODUCT function.
static interface	QOM.QualifiedRowid	The ROWID operator.
static interface	QOM.Radians	The RADIANS function.
static interface	QOM.Rand	The RAND function.
static interface	QOM.Rank
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.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.Rollup
static interface	QOM.Round<T extends Number>	The ROUND function.
static interface	QOM.RowAssignment
static interface	QOM.RowField<R extends Record>
static interface	QOM.RowIsNotNull
static interface	QOM.RowIsNull
static interface	QOM.Rownum	The ROWNUM function.
static interface	QOM.RowNumber
static interface	QOM.RowOverlaps
static interface	QOM.RowsFrom
static interface	QOM.Rpad	The RPAD function.
static interface	QOM.Rtrim	The RTRIM function.
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.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.StAsBinary	The ST ASBINARY function.
static interface	QOM.StAsText	The ST ASTEXT function.
static interface	QOM.StCentroid	The ST CENTROID function.
static interface	QOM.StContains<T extends Spatial>	The ST CONTAINS 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.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.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.StPointN<T extends Spatial>	The ST POINTN function.
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.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.StY	The ST Y function.
static interface	QOM.StZ	The ST Z 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.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.Trunc<T extends Number>	The TRUNC function.
static interface	QOM.Truncate<R extends Record>	The TRUNCATE statement.
(package private) static interface	org.jooq.impl.QOM.UEmpty
static interface	QOM.Unique	The UNIQUE function.
static interface	QOM.UniqueKey
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.
(package private) static interface	org.jooq.impl.QOM.UOperator1<Q1,R extends QueryPart>
(package private) static interface	org.jooq.impl.QOM.UOperator2<Q1,Q2,R extends QueryPart>
(package private) static interface	org.jooq.impl.QOM.UOperator3<Q1,Q2,Q3,R extends QueryPart>
static interface	QOM.Updating	The UPDATING function.
static interface	QOM.Upper	The UPPER function.
static interface	QOM.Uuid	The UUID function.
static interface	QOM.Val<T>
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
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.

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

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

Modifier and Type	Method	Description
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 <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	CatalogImpl.$replace(Replacer replacer)
final QueryPart	LazyCatalog.$replace(Replacer replacer)
final QueryPart	LazySchema.$replace(Replacer replacer)
final QueryPart	PackageImpl.$replace(Replacer replacer)
final QueryPart	SchemaImpl.$replace(Replacer replacer)
final QueryPart	TableImpl.$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.