Uses of Interface
org.jooq.QueryPart

Packages that use QueryPart

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

Uses of QueryPart in org.jooq

Subinterfaces of QueryPart in org.jooq

Modifier and Type	Interface and Description
interface	AggregateFunction<T> An aggregate function is a special field that is usually used in a GROUP BY context.
interface	CaseConditionStep<T> The final step in creating a case statement of the type CASE WHEN x < 1 THEN 'one' WHEN x >= 2 THEN 'two' ELSE 'three' END
interface	CaseWhenStep<V,T> The final step in creating a case statement of the type CASE x WHEN 1 THEN 'one' WHEN 2 THEN 'two' ELSE 'three' END
interface	Catalog An object representing a database catalog.
interface	Condition A condition to be used in a query's where part
interface	Delete<R extends Record> A Query that can delete data in the database.
interface	DeleteConditionStep<R extends Record> This type is used for the Delete's DSL API.
interface	DeleteFinalStep<R extends Record> This type is used for the Delete's DSL API.
interface	DeleteQuery<R extends Record> A query used for deletion of data
interface	DeleteWhereStep<R extends Record> This type is used for the Delete's DSL API.
interface	Field<T> A field used in tables and conditions Note that all fields qualify as GroupField, i.e. they can always be used in GROUP BY clauses
interface	GroupConcatOrderByStep MySQL's GROUP_CONCAT function.
interface	GroupConcatSeparatorStep MySQL's GROUP_CONCAT function.
interface	GroupField A QueryPart to be used exclusively in GROUP BY clauses
interface	Insert<R extends Record> A Query that can insert data in the database.
interface	InsertFinalStep<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> A query for data insertion
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	Keyword A SQL keyword QueryPart.
interface	Merge<R extends Record> A Query that can merge data in the database.
interface	MergeFinalStep<R extends Record> This type is used for the Merge's DSL API.
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 A SQL identifier QueryPart.
interface	Package A container for stored procedures and functions This is only supported in the SQLDialect.ORACLE dialect
interface	Param<T> A named parameter and/or bind value.
interface	Parameter<T> A parameter to a stored procedure or function.
interface	QuantifiedSelect<R extends Record> A participant of a quantified comparison predicate A QuantifiedSelect models the right hand side of a quantified comparison predicate.
interface	Query Any query
interface	QueryPartInternal Base functionality declaration for all query objects This interface is for JOOQ INTERNAL USE only.
interface	ResultQuery<R extends Record> A query that can return results.
interface	Routine<T> A routine is a callable object in your RDBMS.
interface	Row A model type for a row value expression.
interface	Row1<T1> A model type for a row value expression with degree 1.
interface	Row10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> A model type for a row value expression with degree 10.
interface	Row11<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11> A model type for a row value expression with degree 11.
interface	Row12<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12> A model type for a row value expression with degree 12.
interface	Row13<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13> A model type for a row value expression with degree 13.
interface	Row14<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14> A model type for a row value expression with degree 14.
interface	Row15<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15> A model type for a row value expression with degree 15.
interface	Row16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> A model type for a row value expression with degree 16.
interface	Row17<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17> A model type for a row value expression with degree 17.
interface	Row18<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18> A model type for a row value expression with degree 18.
interface	Row19<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19> A model type for a row value expression with degree 19.
interface	Row2<T1,T2> A model type for a row value expression with degree 2.
interface	Row20<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20> A model type for a row value expression with degree 20.
interface	Row21<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16,T17,T18,T19,T20,T21> A model type for a row value expression with degree 21.
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 model type for a row value expression with degree 22.
interface	Row3<T1,T2,T3> A model type for a row value expression with degree 3.
interface	Row4<T1,T2,T3,T4> A model type for a row value expression with degree 4.
interface	Row5<T1,T2,T3,T4,T5> A model type for a row value expression with degree 5.
interface	Row6<T1,T2,T3,T4,T5,T6> A model type for a row value expression with degree 6.
interface	Row7<T1,T2,T3,T4,T5,T6,T7> A model type for a row value expression with degree 7.
interface	Row8<T1,T2,T3,T4,T5,T6,T7,T8> A model type for a row value expression with degree 8.
interface	Row9<T1,T2,T3,T4,T5,T6,T7,T8,T9> A model type for a row value expression with degree 9.
interface	RowN A model type for a row value expression with degree N > 22.
interface	Schema An object representing a database schema
interface	Select<R extends Record> A Query that can provide a Result after execution
interface	SelectConditionStep<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	SelectFinalStep<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	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	SelectJoinStep<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	SelectQuery<R extends Record> A query for data selection
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	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	SortField<T> A wrapper for a Field and a SortField
interface	StoreQuery<R extends Record> A query storing objects to the database.
interface	Table<R extends Record> A table to be used in queries
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 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 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	Truncate<R extends Record> A Query that can truncate a table in the database.
interface	TruncateCascadeStep<R extends Record> A Query that can truncate a table in the database.
interface	TruncateFinalStep<R extends Record> A Query that can truncate a table in the database.
interface	TruncateIdentityStep<R extends Record> A Query that can truncate a table in the database.
interface	UDT<R extends UDTRecord<R>> UDT definition
interface	UDTField<R extends UDTRecord<R>,T> A field contained in a UDT
interface	Update<R extends Record> A Query that can update data in the database.
interface	UpdateConditionStep<R extends Record> This type is used for the Update's DSL API.
interface	UpdateFinalStep<R extends Record> This type is used for the Update's DSL API.
interface	UpdateFromStep<R extends Record> This type is used for the Update's DSL API.
interface	UpdateQuery<R extends Record> A query for data updating
interface	UpdateResultStep<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	WindowBeforeOverStep<T> This type is used for the window function DSL API.
interface	WindowDefinition A window definition.
interface	WindowFinalStep<T> This type is used for the window function DSL API.
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	WindowSpecificationFinalStep An intermediate step in the construction of a WindowSpecification.
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.

Methods in org.jooq that return QueryPart

Modifier and Type	Method and Description
QueryPart	VisitContext.queryPart() The most recent QueryPart that was encountered through Context.visit(QueryPart).
QueryPart[]	VisitContext.queryParts() A path of QueryParts going through the visiting tree.
QueryPart	Template.transform(Object... input) Deprecated. Transform some input data into a QueryPart.

Methods in org.jooq with parameters of type QueryPart

Modifier and Type	Method and Description
UpdateConditionStep<R>	UpdateConditionStep.and(String sql, QueryPart... parts) Combine the currently assembled conditions with another one using the Operator.AND operator NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity.
TableOnConditionStep	TableOnConditionStep.and(String sql, QueryPart... parts) Combine the currently assembled conditions with another one using the Operator.AND operator.
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.
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.
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.
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.
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.
DivideByOnConditionStep	DivideByOnConditionStep.and(String sql, QueryPart... parts) Combine the currently assembled conditions with another one using the Operator.AND operator.
DeleteConditionStep<R>	DeleteConditionStep.and(String sql, QueryPart... parts) Combine the currently assembled conditions with another one using the Operator.AND operator NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity.
Condition	Condition.and(String sql, QueryPart... parts) Combine this condition with another one using the Operator.AND operator.
BindContext	BindContext.bind(QueryPart part) Deprecated. - 3.2.0 - [#2666] - Use Context.visit(QueryPart) instead
BindContext	BindContext.bind(QueryPart[] parts) Deprecated. - 3.2.0 - [#2666] - Use Context.visit(QueryPart) instead
int	DSLContext.bind(QueryPart part, PreparedStatement stmt) Deprecated. - [#2662] - 3.2.0 - Do not reuse this method. It will be removed with jOOQ 4.0
SelectConnectByConditionStep<R>	SelectConnectByStep.connectBy(String sql, QueryPart... parts) Add an Oracle-specific CONNECT BY clause to the query NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity.
SelectConnectByConditionStep<R>	SelectConnectByStep.connectByNoCycle(String sql, QueryPart... parts) Add an Oracle-specific CONNECT BY NOCYCLE clause to the query NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity.
Table<Record>	Table.crossApply(String sql, QueryPart... parts) CROSS APPLY a table to this table.
SelectJoinStep<R>	SelectJoinStep.crossApply(String sql, QueryPart... parts) CROSS APPLY a table to this table.
Table<Record>	Table.crossJoin(String sql, QueryPart... parts) CROSS JOIN a table to this table.
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...)
int	DSLContext.execute(String sql, QueryPart... parts) Execute a new query holding plain SQL.
List<Object>	DSLContext.extractBindValues(QueryPart part) Retrieve the bind values that will be bound by a given QueryPart.
Param<?>	DSLContext.extractParam(QueryPart part, String name) Get a named parameter from a QueryPart, provided its name.
Map<String,Param<?>>	DSLContext.extractParams(QueryPart part) Get a Map of named parameters.
Result<Record>	DSLContext.fetch(String sql, QueryPart... parts) Execute a new query holding plain SQL.
Cursor<Record>	DSLContext.fetchLazy(String sql, QueryPart... parts) Execute a new query holding plain SQL and "lazily" return the generated result.
List<Result<Record>>	DSLContext.fetchMany(String sql, QueryPart... parts) Execute a new query holding plain SQL, possibly returning several result sets.
Record	DSLContext.fetchOne(String sql, QueryPart... parts) Execute a new query holding plain SQL.
Object	DSLContext.fetchValue(String sql, QueryPart... parts) Execute a new query holding plain SQL.
UpdateWhereStep<R>	UpdateFromStep.from(String sql, QueryPart... parts) Add a FROM clause to the query.
SelectJoinStep<R>	SelectFromStep.from(String sql, QueryPart... parts) Add a FROM clause to the query.
TableOnStep	Table.fullOuterJoin(String sql, QueryPart... parts) FULL OUTER JOIN a table to this table.
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...)
SelectHavingConditionStep<R>	SelectHavingStep.having(String sql, QueryPart... parts) Add a HAVING clause to the query.
TableOnStep	Table.join(String sql, QueryPart... parts) INNER JOIN a table to this table.
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...)
TablePartitionByStep	Table.leftOuterJoin(String sql, QueryPart... parts) LEFT OUTER JOIN a table to this table.
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...)
Table<Record>	Table.naturalJoin(String sql, QueryPart... parts) NATURAL JOIN a table to this table.
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...)
Table<Record>	Table.naturalLeftOuterJoin(String sql, QueryPart... parts) NATURAL LEFT OUTER JOIN a table to this table.
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...)
Table<Record>	Table.naturalRightOuterJoin(String sql, QueryPart... parts) NATURAL RIGHT OUTER JOIN a table to this table.
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...)
TableOnConditionStep	TableOnStep.on(String sql, QueryPart... parts) Add an ON clause to the JOIN.
SelectOnConditionStep<R>	SelectOnStep.on(String sql, QueryPart... parts) Add an ON clause to the previous JOIN.
MergeOnConditionStep<R>	MergeOnStep.on(String sql, QueryPart... parts) Provide join conditions and proceed to the next step NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity.
DivideByOnConditionStep	DivideByOnStep.on(String sql, QueryPart... parts) Add a division condition to the DIVIDE BY clause NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity.
UpdateConditionStep<R>	UpdateConditionStep.or(String sql, QueryPart... parts) Combine the currently assembled conditions with another one using the Operator.OR operator NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity.
TableOnConditionStep	TableOnConditionStep.or(String sql, QueryPart... parts) Combine the currently assembled conditions with another one using the Operator.OR operator.
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.
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.
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.
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.
DivideByOnConditionStep	DivideByOnConditionStep.or(String sql, QueryPart... parts) Combine the currently assembled conditions with another one using the Operator.OR operator.
DeleteConditionStep<R>	DeleteConditionStep.or(String sql, QueryPart... parts) Combine the currently assembled conditions with another one using the Operator.OR operator NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity.
Condition	Condition.or(String sql, QueryPart... parts) Combine this condition with another one using the Operator.OR operator.
Table<Record>	Table.outerApply(String sql, QueryPart... parts) OUTER APPLY a table to this table.
SelectJoinStep<R>	SelectJoinStep.outerApply(String sql, QueryPart... parts) OUTER APPLY a table to this table.
Query	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).
String	RenderContext.render(QueryPart part) Render a query part in a new context derived from this one.
String	DSLContext.render(QueryPart part) Render a QueryPart in the context of this DSLContext.
String	DSLContext.renderInlined(QueryPart part) Render a QueryPart in the context of this DSLContext, inlining all bind variables.
String	DSLContext.renderNamedParams(QueryPart part) Render a QueryPart in the context of this DSLContext, rendering bind variables as named parameters.
ResultQuery<Record>	DSLContext.resultQuery(String sql, QueryPart... parts) Create a new query holding plain SQL.
TablePartitionByStep	Table.rightOuterJoin(String sql, QueryPart... parts) RIGHT OUTER JOIN a table to this table.
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...)
RenderContext	RenderContext.sql(QueryPart part) Deprecated. - 3.2.0 - [#2666] - Use Context.visit(QueryPart) instead
SelectGroupByStep<R>	SelectStartWithStep.startWith(String sql, QueryPart... parts) Add an Oracle-specific START WITH clause to the query's CONNECT BY clause.
C	Context.visit(QueryPart part) Visit a QueryPart in the current Context.
UpdateConditionStep<R>	UpdateWhereStep.where(String sql, QueryPart... parts) Add conditions to the query NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity.
SelectConditionStep<R>	SelectWhereStep.where(String sql, QueryPart... parts) Add a WHERE clause to the query.
DeleteConditionStep<R>	DeleteWhereStep.where(String sql, QueryPart... parts) Add conditions to the query.

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

Modifier and Type	Method and Description
BindContext	BindContext.bind(Collection<? extends QueryPart> parts) Deprecated. - 3.2.0 - [#2666] - Use Context.visit(QueryPart) instead

Uses of QueryPart in org.jooq.impl

Classes in org.jooq.impl that implement QueryPart

Modifier and Type	Class and Description
class	AbstractRoutine<T> A common base class for stored procedures This type is for JOOQ INTERNAL USE only.
class	CatalogImpl A common base class for database catalogs This type is for JOOQ INTERNAL USE only.
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	CustomTable<R extends TableRecord<R>> A base class for custom Table implementations in client code.
class	KeywordImpl A default Keyword implementation.
class	NullIf<T>
class	PackageImpl A default implementation for packages (containers of stored procedures and functions) Currently, this is only supported for the SQLDialect.ORACLE dialect.
class	SchemaImpl A common base class for database schemata This type is for JOOQ INTERNAL USE only.
class	TableImpl<R extends Record> A common base type for tables This type is for JOOQ INTERNAL USE only.
class	UDTImpl<R extends UDTRecord<R>> A common base type for UDT's This type is for JOOQ INTERNAL USE only.

Methods in org.jooq.impl that return QueryPart

Modifier and Type	Method and Description
static QueryPart	DSL.queryPart(String sql) A custom SQL clause that can render arbitrary expressions.
static QueryPart	DSL.queryPart(String sql, Object... bindings) A custom SQL clause that can render arbitrary expressions.
static QueryPart	DSL.queryPart(String sql, QueryPart... parts) A custom SQL clause that can render arbitrary expressions.

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

Modifier and Type	Method and Description
int	DefaultDSLContext.bind(QueryPart part, PreparedStatement stmt) Deprecated.
static 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)
Cursor<Record>	DefaultDSLContext.fetchLazy(String sql, QueryPart... parts)
List<Result<Record>>	DefaultDSLContext.fetchMany(String sql, QueryPart... parts)
Record	DefaultDSLContext.fetchOne(String sql, QueryPart... parts)
Object	DefaultDSLContext.fetchValue(String sql, QueryPart... parts)
static <T> Field<T>	DSL.field(String sql, Class<T> type, QueryPart... parts) A custom SQL clause that can render arbitrary SQL elements.
static <T> Field<T>	DSL.field(String sql, DataType<T> type, QueryPart... parts) A custom SQL clause that can render arbitrary SQL elements.
static Field<Object>	DSL.field(String sql, QueryPart... parts) A custom SQL clause that can render arbitrary SQL elements.
Query	DefaultDSLContext.query(String sql, QueryPart... parts)
static QueryPart	DSL.queryPart(String sql, QueryPart... parts) A custom SQL clause that can render arbitrary expressions.
String	DefaultDSLContext.render(QueryPart part)
String	DefaultDSLContext.renderInlined(QueryPart part)
String	DefaultDSLContext.renderNamedParams(QueryPart part)
ResultQuery<Record>	DefaultDSLContext.resultQuery(String sql, QueryPart... parts)
static Table<Record>	DSL.table(String sql, QueryPart... parts) A custom SQL clause that can render arbitrary table expressions.