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 ..

Methods in org.jooq that return QueryPart

Modifier and Type	Method	Description
@NotNull QueryPart	VisitContext.queryPart()	The most recent QueryPart that was encountered through Context.visit(QueryPart).
@NotNull QueryPart[]	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 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
@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().
@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 ...

Uses of QueryPart in org.jooq.impl

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.
class	LazyCatalog	A schema that references a lazy initialisable Catalog singleton, for use in generated code.
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 that return QueryPart

Modifier and Type	Method	Description
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.
static @NotNull QueryPart	DSL.queryPart(String sql)	Deprecated, for removal: This API element is subject to removal in a future version. - 3.6.0 - [#3854] - Use DSL.sql(String) instead
static @NotNull QueryPart	DSL.queryPart(String sql, Object... bindings)	Deprecated, for removal: This API element is subject to removal in a future version. - 3.6.0 - [#3854] - Use DSL.sql(String, Object...) instead
static @NotNull QueryPart	DSL.queryPart(String sql, QueryPart... parts)	Deprecated, for removal: This API element is subject to removal in a future version. - 3.6.0 - [#3854] - Use DSL.sql(String, QueryPart...) instead

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 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.
static @NotNull QueryPart	DSL.queryPart(String sql, QueryPart... parts)	Deprecated, for removal: This API element is subject to removal in a future version. - 3.6.0 - [#3854] - Use DSL.sql(String, QueryPart...) instead
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.

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.