Uses of Class
org.jooq.PlainSQL

Packages that use PlainSQL

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 PlainSQL in org.jooq

Classes in org.jooq with annotations of type PlainSQL

Modifier and Type	Interface and Description
interface	SQL A plain SQL QueryPart.

Methods in org.jooq with annotations of type PlainSQL

Modifier and Type	Method and Description
UpdateConditionStep<R>	UpdateConditionStep.and(SQL sql) 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<R>	TableOnConditionStep.and(SQL sql) Combine the currently assembled conditions with another one using the Operator.AND operator.
SelectOnConditionStep<R>	SelectOnConditionStep.and(SQL sql) Combine the currently assembled conditions with another one using the Operator.AND operator and proceed to the next step.
SelectHavingConditionStep<R>	SelectHavingConditionStep.and(SQL sql) Combine the currently assembled conditions with another one using the Operator.AND operator and proceed to the next step.
SelectConnectByConditionStep<R>	SelectConnectByConditionStep.and(SQL sql) Combine the currently assembled conditions with another one using the Operator.AND operator and proceed to the next step.
SelectConditionStep<R>	SelectConditionStep.and(SQL sql) Combine the currently assembled conditions with another one using the Operator.AND operator and proceed to the next step.
MergeOnConditionStep<R>	MergeOnConditionStep.and(SQL sql) Combine the currently assembled conditions with another one using the Operator.AND operator and proceed to the next step.
DivideByOnConditionStep	DivideByOnConditionStep.and(SQL sql) Combine the currently assembled conditions with another one using the Operator.AND operator.
DeleteConditionStep<R>	DeleteConditionStep.and(SQL sql) 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(SQL sql) Combine this condition with another one using the Operator.AND operator.
UpdateConditionStep<R>	UpdateConditionStep.and(String sql) 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<R>	TableOnConditionStep.and(String sql) Combine the currently assembled conditions with another one using the Operator.AND operator.
SelectOnConditionStep<R>	SelectOnConditionStep.and(String sql) 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) 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) 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) 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) Combine the currently assembled conditions with another one using the Operator.AND operator and proceed to the next step.
DivideByOnConditionStep	DivideByOnConditionStep.and(String sql) Combine the currently assembled conditions with another one using the Operator.AND operator.
DeleteConditionStep<R>	DeleteConditionStep.and(String sql) 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) Combine this condition with another one using the Operator.AND operator.
UpdateConditionStep<R>	UpdateConditionStep.and(String sql, Object... bindings) 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<R>	TableOnConditionStep.and(String sql, Object... bindings) Combine the currently assembled conditions with another one using the Operator.AND operator.
SelectOnConditionStep<R>	SelectOnConditionStep.and(String sql, Object... bindings) 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, Object... bindings) 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, Object... bindings) 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, Object... bindings) 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, Object... bindings) Combine the currently assembled conditions with another one using the Operator.AND operator and proceed to the next step.
DivideByOnConditionStep	DivideByOnConditionStep.and(String sql, Object... bindings) Combine the currently assembled conditions with another one using the Operator.AND operator.
DeleteConditionStep<R>	DeleteConditionStep.and(String sql, Object... bindings) 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, Object... bindings) Combine this condition with another one using the Operator.AND operator.
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<R>	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.
SelectConnectByConditionStep<R>	SelectConnectByStep.connectBy(SQL sql) 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.connectBy(String sql) 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.connectBy(String sql, Object... bindings) 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.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(SQL sql) Add an Oracle-specific CONNECT BY NOCYCLE clause to the query NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity.
SelectConnectByConditionStep<R>	SelectConnectByStep.connectByNoCycle(String sql) Add an Oracle-specific CONNECT BY NOCYCLE clause to the query NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity.
SelectConnectByConditionStep<R>	SelectConnectByStep.connectByNoCycle(String sql, Object... bindings) Add an Oracle-specific CONNECT BY NOCYCLE 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(SQL sql) CROSS APPLY a table to this table.
SelectJoinStep<R>	SelectJoinStep.crossApply(SQL sql) CROSS APPLY a table to this table.
Table<Record>	Table.crossApply(String sql) CROSS APPLY a table to this table.
SelectJoinStep<R>	SelectJoinStep.crossApply(String sql) CROSS APPLY a table to this table.
Table<Record>	Table.crossApply(String sql, Object... bindings) CROSS APPLY a table to this table.
SelectJoinStep<R>	SelectJoinStep.crossApply(String sql, Object... bindings) CROSS APPLY a table to this table.
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(SQL sql) CROSS JOIN a table to this table.
SelectJoinStep<R>	SelectJoinStep.crossJoin(SQL sql) Convenience method to CROSS JOIN a table to the last table added to the FROM clause using Table.crossJoin(String) If this syntax is unavailable, it is emulated with a regular INNER JOIN.
Table<Record>	Table.crossJoin(String sql) CROSS JOIN a table to this table.
SelectJoinStep<R>	SelectJoinStep.crossJoin(String sql) Convenience method to CROSS JOIN a table to the last table added to the FROM clause using Table.crossJoin(String) If this syntax is unavailable, it is emulated with a regular INNER JOIN.
Table<Record>	Table.crossJoin(String sql, Object... bindings) CROSS JOIN a table to this table.
SelectJoinStep<R>	SelectJoinStep.crossJoin(String sql, Object... bindings) Convenience method to CROSS JOIN a table to the last table added to the FROM clause using Table.crossJoin(String, Object...)
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(SQL sql) Execute a query holding plain SQL.
int	DSLContext.execute(String sql) Execute a query holding plain SQL.
int	DSLContext.execute(String sql, Object... bindings) Execute a new query holding plain SQL.
int	DSLContext.execute(String sql, QueryPart... parts) Execute a new query holding plain SQL.
Result<Record>	DSLContext.fetch(SQL sql) Execute a new query holding plain SQL.
Result<Record>	DSLContext.fetch(String sql) Execute a new query holding plain SQL.
Result<Record>	DSLContext.fetch(String sql, Object... bindings) Execute a new query holding plain SQL.
Result<Record>	DSLContext.fetch(String sql, QueryPart... parts) Execute a new query holding plain SQL.
CompletionStage<Result<Record>>	DSLContext.fetchAsync(Executor executor, SQL sql) Fetch results in a new CompletionStage that is asynchronously completed by a task running in the given executor.
CompletionStage<Result<Record>>	DSLContext.fetchAsync(Executor executor, String sql) Fetch results in a new CompletionStage that is asynchronously completed by a task running in the given executor.
CompletionStage<Result<Record>>	DSLContext.fetchAsync(Executor executor, String sql, Object... bindings) Fetch results in a new CompletionStage that is asynchronously completed by a task running in the given executor.
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.
CompletionStage<Result<Record>>	DSLContext.fetchAsync(SQL sql) Fetch results in a new CompletionStage.
CompletionStage<Result<Record>>	DSLContext.fetchAsync(String sql) Fetch results in a new CompletionStage.
CompletionStage<Result<Record>>	DSLContext.fetchAsync(String sql, Object... bindings) Fetch results in a new CompletionStage.
CompletionStage<Result<Record>>	DSLContext.fetchAsync(String sql, QueryPart... parts) Fetch results in a new CompletionStage.
Cursor<Record>	DSLContext.fetchLazy(SQL sql) Execute a new query holding plain SQL and "lazily" return the generated result.
Cursor<Record>	DSLContext.fetchLazy(String sql) Execute a new query holding plain SQL and "lazily" return the generated result.
Cursor<Record>	DSLContext.fetchLazy(String sql, Object... bindings) Execute a new query holding plain SQL and "lazily" return the generated result.
Cursor<Record>	DSLContext.fetchLazy(String sql, QueryPart... parts) Execute a new query holding plain SQL and "lazily" return the generated result.
Results	DSLContext.fetchMany(SQL sql) Execute a new query holding plain SQL, possibly returning several result sets.
Results	DSLContext.fetchMany(String sql) Execute a new query holding plain SQL, possibly returning several result sets.
Results	DSLContext.fetchMany(String sql, Object... bindings) Execute a new query holding plain SQL, possibly returning several result sets.
Results	DSLContext.fetchMany(String sql, QueryPart... parts) Execute a new query holding plain SQL, possibly returning several result sets.
Record	DSLContext.fetchOne(SQL sql) Execute a new query holding plain SQL.
Record	DSLContext.fetchOne(String sql) Execute a new query holding plain SQL.
Record	DSLContext.fetchOne(String sql, Object... bindings) Execute a new query holding plain SQL.
Record	DSLContext.fetchOne(String sql, QueryPart... parts) Execute a new query holding plain SQL.
Optional<Record>	DSLContext.fetchOptional(SQL sql) Execute a new query holding plain SQL.
Optional<Record>	DSLContext.fetchOptional(String sql) Execute a new query holding plain SQL.
Optional<Record>	DSLContext.fetchOptional(String sql, Object... bindings) Execute a new query holding plain SQL.
Optional<Record>	DSLContext.fetchOptional(String sql, QueryPart... parts) Execute a new query holding plain SQL.
Optional<?>	DSLContext.fetchOptionalValue(SQL sql) Execute a new query holding plain SQL.
Optional<?>	DSLContext.fetchOptionalValue(String sql) Execute a new query holding plain SQL.
Optional<?>	DSLContext.fetchOptionalValue(String sql, Object... bindings) Execute a new query holding plain SQL.
Optional<?>	DSLContext.fetchOptionalValue(String sql, QueryPart... parts) Execute a new query holding plain SQL.
java.util.stream.Stream<Record>	DSLContext.fetchStream(SQL sql) Execute a new query holding plain SQL and "lazily" return the generated result.
java.util.stream.Stream<Record>	DSLContext.fetchStream(String sql) Execute a new query holding plain SQL and "lazily" return the generated result.
java.util.stream.Stream<Record>	DSLContext.fetchStream(String sql, Object... bindings) Execute a new query holding plain SQL and "lazily" return the generated result.
java.util.stream.Stream<Record>	DSLContext.fetchStream(String sql, QueryPart... parts) Execute a new query holding plain SQL and "lazily" return the generated result.
Object	DSLContext.fetchValue(SQL sql) Execute a new query holding plain SQL.
Object	DSLContext.fetchValue(String sql) Execute a new query holding plain SQL.
Object	DSLContext.fetchValue(String sql, Object... bindings) Execute a new query holding plain SQL.
Object	DSLContext.fetchValue(String sql, QueryPart... parts) Execute a new query holding plain SQL.
List<?>	DSLContext.fetchValues(SQL sql) Execute a new query holding plain SQL.
List<?>	DSLContext.fetchValues(String sql) Execute a new query holding plain SQL.
List<?>	DSLContext.fetchValues(String sql, Object... bindings) Execute a new query holding plain SQL.
List<?>	DSLContext.fetchValues(String sql, QueryPart... parts) Execute a new query holding plain SQL.
WindowBeforeOverStep<T>	AggregateFilterStep.filterWhere(SQL sql) Add a FILTER clause to the aggregate function.
WindowBeforeOverStep<T>	AggregateFilterStep.filterWhere(String sql) Add a FILTER clause to the aggregate function.
WindowBeforeOverStep<T>	AggregateFilterStep.filterWhere(String sql, Object... bindings) Add a FILTER clause to the aggregate function.
WindowBeforeOverStep<T>	AggregateFilterStep.filterWhere(String sql, QueryPart... parts) Add a FILTER clause to the aggregate function.
UpdateWhereStep<R>	UpdateFromStep.from(SQL sql) Add a FROM clause to the query.
SelectJoinStep<R>	SelectFromStep.from(SQL sql) Add a FROM clause to the query.
UpdateWhereStep<R>	UpdateFromStep.from(String sql) Add a FROM clause to the query.
SelectJoinStep<R>	SelectFromStep.from(String sql) Add a FROM clause to the query.
UpdateWhereStep<R>	UpdateFromStep.from(String sql, Object... bindings) Add a FROM clause to the query.
SelectJoinStep<R>	SelectFromStep.from(String sql, Object... bindings) Add a FROM clause to the query.
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<Record>	Table.fullOuterJoin(SQL sql) FULL OUTER JOIN a table to this table.
SelectOnStep<R>	SelectJoinStep.fullOuterJoin(SQL sql) Convenience method to FULL OUTER JOIN a table to the last table added to the FROM clause using Table.fullOuterJoin(String) This is only possible where the underlying RDBMS supports it NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity.
TableOnStep<Record>	Table.fullOuterJoin(String sql) FULL OUTER JOIN a table to this table.
SelectOnStep<R>	SelectJoinStep.fullOuterJoin(String sql) Convenience method to FULL OUTER JOIN a table to the last table added to the FROM clause using Table.fullOuterJoin(String) This is only possible where the underlying RDBMS supports it NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity.
TableOnStep<Record>	Table.fullOuterJoin(String sql, Object... bindings) FULL OUTER JOIN a table to this table.
SelectOnStep<R>	SelectJoinStep.fullOuterJoin(String sql, Object... bindings) Convenience method to FULL OUTER JOIN a tableto the last table added to the FROM clause using Table.fullOuterJoin(String, Object...)
TableOnStep<Record>	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(SQL sql) Add a HAVING clause to the query.
SelectHavingConditionStep<R>	SelectHavingStep.having(String sql) Add a HAVING clause to the query.
SelectHavingConditionStep<R>	SelectHavingStep.having(String sql, Object... bindings) Add a HAVING clause to the query.
SelectHavingConditionStep<R>	SelectHavingStep.having(String sql, QueryPart... parts) Add a HAVING clause to the query.
TableOnStep<Record>	Table.innerJoin(SQL sql) INNER JOIN a table to this table.
SelectOnStep<R>	SelectJoinStep.innerJoin(SQL sql) Convenience method to INNER JOIN a table to the last table added to the FROM clause using Table.join(String).
TableOnStep<Record>	Table.innerJoin(String sql) INNER JOIN a table to this table.
SelectOnStep<R>	SelectJoinStep.innerJoin(String sql) Convenience method to INNER JOIN a table to the last table added to the FROM clause using Table.join(String).
TableOnStep<Record>	Table.innerJoin(String sql, Object... bindings) INNER JOIN a table to this table.
SelectOnStep<R>	SelectJoinStep.innerJoin(String sql, Object... bindings) Convenience method to INNER JOIN a table to the last table added to the FROM clause using Table.join(String, Object...).
TableOnStep<Record>	Table.innerJoin(String sql, QueryPart... parts) INNER JOIN a table to this table.
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...).
TableOnStep<Record>	Table.join(Name name) INNER JOIN a table to this table.
SelectOnStep<R>	SelectJoinStep.join(Name name) Convenience method to INNER JOIN a table to the last table added to the FROM clause using Table.join(Name).
TableOnStep<Record>	Table.join(SQL sql) INNER JOIN a table to this table.
SelectOnStep<R>	SelectJoinStep.join(SQL sql) Convenience method to INNER JOIN a table to the last table added to the FROM clause using Table.join(String).
TableOnStep<Record>	Table.join(String sql) INNER JOIN a table to this table.
SelectOnStep<R>	SelectJoinStep.join(String sql) Convenience method to INNER JOIN a table to the last table added to the FROM clause using Table.join(String).
TableOnStep<Record>	Table.join(String sql, Object... bindings) INNER JOIN a table to this table.
SelectOnStep<R>	SelectJoinStep.join(String sql, Object... bindings) Convenience method to INNER JOIN a table to the last table added to the FROM clause using Table.join(String, Object...).
TableOnStep<Record>	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<Record>	Table.leftJoin(SQL sql) LEFT OUTER JOIN a table to this table.
SelectJoinPartitionByStep<R>	SelectJoinStep.leftJoin(SQL sql) Convenience method to LEFT OUTER JOIN a table to the last table added to the FROM clause using Table.leftOuterJoin(String).
TablePartitionByStep<Record>	Table.leftJoin(String sql) LEFT OUTER JOIN a table to this table.
SelectJoinPartitionByStep<R>	SelectJoinStep.leftJoin(String sql) Convenience method to LEFT OUTER JOIN a table to the last table added to the FROM clause using Table.leftOuterJoin(String).
TablePartitionByStep<Record>	Table.leftJoin(String sql, Object... bindings) LEFT OUTER JOIN a table to this table.
SelectJoinPartitionByStep<R>	SelectJoinStep.leftJoin(String sql, Object... bindings) Convenience method to LEFT OUTER JOIN a table to the last table added to the FROM clause using Table.leftOuterJoin(String, Object...).
TablePartitionByStep<Record>	Table.leftJoin(String sql, QueryPart... parts) LEFT OUTER JOIN a table to this table.
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...).
TablePartitionByStep<Record>	Table.leftOuterJoin(SQL sql) LEFT OUTER JOIN a table to this table.
SelectJoinPartitionByStep<R>	SelectJoinStep.leftOuterJoin(SQL sql) Convenience method to LEFT OUTER JOIN a table to the last table added to the FROM clause using Table.leftOuterJoin(String) NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity.
TablePartitionByStep<Record>	Table.leftOuterJoin(String sql) LEFT OUTER JOIN a table to this table.
SelectJoinPartitionByStep<R>	SelectJoinStep.leftOuterJoin(String sql) Convenience method to LEFT OUTER JOIN a table to the last table added to the FROM clause using Table.leftOuterJoin(String) NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity.
TablePartitionByStep<Record>	Table.leftOuterJoin(String sql, Object... bindings) LEFT OUTER JOIN a table to this table.
SelectJoinPartitionByStep<R>	SelectJoinStep.leftOuterJoin(String sql, Object... bindings) Convenience method to LEFT OUTER JOIN a table to the last table added to the FROM clause using Table.leftOuterJoin(String, Object...)
TablePartitionByStep<Record>	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(SQL sql) NATURAL JOIN a table to this table.
SelectJoinStep<R>	SelectJoinStep.naturalJoin(SQL sql) Convenience method to NATURAL JOIN a table to the last table added to the FROM clause using Table.naturalJoin(String) Natural joins are supported by most RDBMS.
Table<Record>	Table.naturalJoin(String sql) NATURAL JOIN a table to this table.
SelectJoinStep<R>	SelectJoinStep.naturalJoin(String sql) Convenience method to NATURAL JOIN a table to the last table added to the FROM clause using Table.naturalJoin(String) Natural joins are supported by most RDBMS.
Table<Record>	Table.naturalJoin(String sql, Object... bindings) NATURAL JOIN a table to this table.
SelectJoinStep<R>	SelectJoinStep.naturalJoin(String sql, Object... bindings) Convenience method to NATURAL JOIN a table to the last table added to the FROM clause using Table.naturalJoin(String, Object...)
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(Name name) NATURAL LEFT OUTER JOIN a table to this table.
Table<Record>	Table.naturalLeftOuterJoin(SQL sql) NATURAL LEFT OUTER JOIN a table to this table.
SelectJoinStep<R>	SelectJoinStep.naturalLeftOuterJoin(SQL sql) Convenience method to NATURAL LEFT OUTER JOIN a table to the last table added to the FROM clause using Table.naturalLeftOuterJoin(String) Natural joins are supported by most RDBMS.
Table<Record>	Table.naturalLeftOuterJoin(String sql) NATURAL LEFT OUTER JOIN a table to this table.
SelectJoinStep<R>	SelectJoinStep.naturalLeftOuterJoin(String sql) Convenience method to NATURAL LEFT OUTER JOIN a table to the last table added to the FROM clause using Table.naturalLeftOuterJoin(String) Natural joins are supported by most RDBMS.
Table<Record>	Table.naturalLeftOuterJoin(String sql, Object... bindings) NATURAL LEFT OUTER JOIN a table to this table.
SelectJoinStep<R>	SelectJoinStep.naturalLeftOuterJoin(String sql, Object... bindings) Convenience method to NATURAL LEFT OUTER JOIN a table to the last table added to the FROM clause using Table.naturalLeftOuterJoin(String, Object...)
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(SQL sql) NATURAL RIGHT OUTER JOIN a table to this table.
SelectJoinStep<R>	SelectJoinStep.naturalRightOuterJoin(SQL sql) Convenience method to NATURAL RIGHT OUTER JOIN a table to the last table added to the FROM clause using Table.naturalRightOuterJoin(String) Natural joins are supported by most RDBMS.
Table<Record>	Table.naturalRightOuterJoin(String sql) NATURAL RIGHT OUTER JOIN a table to this table.
SelectJoinStep<R>	SelectJoinStep.naturalRightOuterJoin(String sql) Convenience method to NATURAL RIGHT OUTER JOIN a table to the last table added to the FROM clause using Table.naturalRightOuterJoin(String) Natural joins are supported by most RDBMS.
Table<Record>	Table.naturalRightOuterJoin(String sql, Object... bindings) NATURAL RIGHT OUTER JOIN a table to this table.
SelectJoinStep<R>	SelectJoinStep.naturalRightOuterJoin(String sql, Object... bindings) Convenience method to NATURAL RIGHT OUTER JOIN a table to the last table added to the FROM clause using Table.naturalRightOuterJoin(String, Object...)
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<R>	TableOnStep.on(SQL sql) Add an ON clause to the JOIN.
SelectOnConditionStep<R>	SelectOnStep.on(SQL sql) Add an ON clause to the previous JOIN.
MergeOnConditionStep<R>	MergeOnStep.on(SQL sql) 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(SQL sql) Add a division condition to the DIVIDE BY clause NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity.
TableOnConditionStep<R>	TableOnStep.on(String sql) Add an ON clause to the JOIN.
SelectOnConditionStep<R>	SelectOnStep.on(String sql) Add an ON clause to the previous JOIN.
MergeOnConditionStep<R>	MergeOnStep.on(String sql) 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) Add a division condition to the DIVIDE BY clause NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity.
TableOnConditionStep<R>	TableOnStep.on(String sql, Object... bindings) Add an ON clause to the JOIN.
SelectOnConditionStep<R>	SelectOnStep.on(String sql, Object... bindings) Add an ON clause to the previous JOIN.
MergeOnConditionStep<R>	MergeOnStep.on(String sql, Object... bindings) 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, Object... bindings) Add a division condition to the DIVIDE BY clause NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity.
TableOnConditionStep<R>	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(SQL sql) 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<R>	TableOnConditionStep.or(SQL sql) Combine the currently assembled conditions with another one using the Operator.OR operator.
SelectOnConditionStep<R>	SelectOnConditionStep.or(SQL sql) Combine the currently assembled conditions with another one using the Operator.OR operator and proceed to the next step.
SelectHavingConditionStep<R>	SelectHavingConditionStep.or(SQL sql) Combine the currently assembled conditions with another one using the Operator.OR operator and proceed to the next step.
SelectConditionStep<R>	SelectConditionStep.or(SQL sql) Combine the currently assembled conditions with another one using the Operator.OR operator and proceed to the next step.
MergeOnConditionStep<R>	MergeOnConditionStep.or(SQL sql) Combine the currently assembled conditions with another one using the Operator.OR operator and proceed to the next step.
DivideByOnConditionStep	DivideByOnConditionStep.or(SQL sql) Combine the currently assembled conditions with another one using the Operator.OR operator.
DeleteConditionStep<R>	DeleteConditionStep.or(SQL sql) 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(SQL sql) Combine this condition with another one using the Operator.OR operator.
UpdateConditionStep<R>	UpdateConditionStep.or(String sql) 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<R>	TableOnConditionStep.or(String sql) Combine the currently assembled conditions with another one using the Operator.OR operator.
SelectOnConditionStep<R>	SelectOnConditionStep.or(String sql) 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) 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) 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) Combine the currently assembled conditions with another one using the Operator.OR operator and proceed to the next step.
DivideByOnConditionStep	DivideByOnConditionStep.or(String sql) Combine the currently assembled conditions with another one using the Operator.OR operator.
DeleteConditionStep<R>	DeleteConditionStep.or(String sql) 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) Combine this condition with another one using the Operator.OR operator.
UpdateConditionStep<R>	UpdateConditionStep.or(String sql, Object... bindings) 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<R>	TableOnConditionStep.or(String sql, Object... bindings) Combine the currently assembled conditions with another one using the Operator.OR operator.
SelectOnConditionStep<R>	SelectOnConditionStep.or(String sql, Object... bindings) 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, Object... bindings) 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, Object... bindings) 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, Object... bindings) Combine the currently assembled conditions with another one using the Operator.OR operator and proceed to the next step.
DivideByOnConditionStep	DivideByOnConditionStep.or(String sql, Object... bindings) Combine the currently assembled conditions with another one using the Operator.OR operator.
DeleteConditionStep<R>	DeleteConditionStep.or(String sql, Object... bindings) 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, Object... bindings) Combine this condition with another one using the Operator.OR operator.
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<R>	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(SQL sql) OUTER APPLY a table to this table.
SelectJoinStep<R>	SelectJoinStep.outerApply(SQL sql) OUTER APPLY a table to this table.
Table<Record>	Table.outerApply(String sql) OUTER APPLY a table to this table.
SelectJoinStep<R>	SelectJoinStep.outerApply(String sql) OUTER APPLY a table to this table.
Table<Record>	Table.outerApply(String sql, Object... bindings) OUTER APPLY a table to this table.
SelectJoinStep<R>	SelectJoinStep.outerApply(String sql, Object... bindings) OUTER APPLY a table to this table.
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(SQL sql) Create a new query holding plain SQL.
Query	DSLContext.query(String sql) Create a new query holding plain SQL.
Query	DSLContext.query(String sql, Object... bindings) Create a new query holding plain SQL.
Query	DSLContext.query(String sql, QueryPart... parts) Create a new query holding plain SQL.
ResultQuery<Record>	DSLContext.resultQuery(SQL sql) Create a new query holding plain SQL.
ResultQuery<Record>	DSLContext.resultQuery(String sql) Create a new query holding plain SQL.
ResultQuery<Record>	DSLContext.resultQuery(String sql, Object... bindings) Create a new query holding plain SQL.
ResultQuery<Record>	DSLContext.resultQuery(String sql, QueryPart... parts) Create a new query holding plain SQL.
TablePartitionByStep<Record>	Table.rightJoin(SQL sql) RIGHT OUTER JOIN a table to this table.
SelectJoinPartitionByStep<R>	SelectJoinStep.rightJoin(SQL sql) Convenience method to RIGHT OUTER JOIN a table to the last table added to the FROM clause using Table.rightOuterJoin(String).
TablePartitionByStep<Record>	Table.rightJoin(String sql) RIGHT OUTER JOIN a table to this table.
SelectJoinPartitionByStep<R>	SelectJoinStep.rightJoin(String sql) Convenience method to RIGHT OUTER JOIN a table to the last table added to the FROM clause using Table.rightOuterJoin(String).
TablePartitionByStep<Record>	Table.rightJoin(String sql, Object... bindings) RIGHT OUTER JOIN a table to this table.
SelectJoinPartitionByStep<R>	SelectJoinStep.rightJoin(String sql, Object... bindings) Convenience method to RIGHT OUTER JOIN a table to the last table added to the FROM clause using Table.rightOuterJoin(String, Object...).
TablePartitionByStep<Record>	Table.rightJoin(String sql, QueryPart... parts) RIGHT OUTER JOIN a table to this table.
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...).
TablePartitionByStep<Record>	Table.rightOuterJoin(SQL sql) RIGHT OUTER JOIN a table to this table.
SelectJoinPartitionByStep<R>	SelectJoinStep.rightOuterJoin(SQL sql) Convenience method to RIGHT OUTER JOIN a table to the last table added to the FROM clause using Table.rightOuterJoin(String) This is only possible where the underlying RDBMS supports it NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity.
TablePartitionByStep<Record>	Table.rightOuterJoin(String sql) RIGHT OUTER JOIN a table to this table.
SelectJoinPartitionByStep<R>	SelectJoinStep.rightOuterJoin(String sql) Convenience method to RIGHT OUTER JOIN a table to the last table added to the FROM clause using Table.rightOuterJoin(String) This is only possible where the underlying RDBMS supports it NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity.
TablePartitionByStep<Record>	Table.rightOuterJoin(String sql, Object... bindings) RIGHT OUTER JOIN a table to this table.
SelectJoinPartitionByStep<R>	SelectJoinStep.rightOuterJoin(String sql, Object... bindings) Convenience method to RIGHT OUTER JOIN a table to the last table added to the FROM clause using Table.rightOuterJoin(String, Object...)
TablePartitionByStep<Record>	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...)
SelectGroupByStep<R>	SelectStartWithStep.startWith(SQL sql) Add an Oracle-specific START WITH clause to the query's CONNECT BY clause.
SelectGroupByStep<R>	SelectStartWithStep.startWith(String sql) Add an Oracle-specific START WITH clause to the query's CONNECT BY clause.
SelectGroupByStep<R>	SelectStartWithStep.startWith(String sql, Object... bindings) Add an Oracle-specific START WITH clause to the query's CONNECT BY clause.
SelectGroupByStep<R>	SelectStartWithStep.startWith(String sql, QueryPart... parts) Add an Oracle-specific START WITH clause to the query's CONNECT BY clause.
TableOnStep<Record>	Table.straightJoin(Name name) STRAIGHT_JOIN a table to this table.
TableOnStep<Record>	Table.straightJoin(SQL sql) STRAIGHT_JOIN a table to this table.
SelectOnStep<R>	SelectJoinStep.straightJoin(SQL sql) STRAIGHT_JOIN a table to this table.
TableOnStep<Record>	Table.straightJoin(String sql) STRAIGHT_JOIN a table to this table.
SelectOnStep<R>	SelectJoinStep.straightJoin(String sql) STRAIGHT_JOIN a table to this table.
TableOnStep<Record>	Table.straightJoin(String sql, Object... bindings) STRAIGHT_JOIN a table to this table.
SelectOnStep<R>	SelectJoinStep.straightJoin(String sql, Object... bindings) STRAIGHT_JOIN a table to this table.
TableOnStep<Record>	Table.straightJoin(String sql, QueryPart... parts) STRAIGHT_JOIN a table to this table.
SelectOnStep<R>	SelectJoinStep.straightJoin(String sql, QueryPart... parts) STRAIGHT_JOIN a table to this table.
UpdateConditionStep<R>	UpdateWhereStep.where(SQL sql) Add conditions to the query NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity.
SelectConditionStep<R>	SelectWhereStep.where(SQL sql) Add a WHERE clause to the query.
DeleteConditionStep<R>	DeleteWhereStep.where(SQL sql) Add conditions to the query.
UpdateConditionStep<R>	UpdateWhereStep.where(String sql) Add conditions to the query NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity.
SelectConditionStep<R>	SelectWhereStep.where(String sql) Add a WHERE clause to the query.
DeleteConditionStep<R>	DeleteWhereStep.where(String sql) Add conditions to the query.
UpdateConditionStep<R>	UpdateWhereStep.where(String sql, Object... bindings) Add conditions to the query NOTE: When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity.
SelectConditionStep<R>	SelectWhereStep.where(String sql, Object... bindings) Add a WHERE clause to the query.
DeleteConditionStep<R>	DeleteWhereStep.where(String sql, Object... bindings) Add conditions to the query.
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.

Uses of PlainSQL in org.jooq.impl

Methods in org.jooq.impl with annotations of type PlainSQL

Modifier and Type	Method and Description
static Condition	DSL.condition(SQL sql) Create a new condition holding plain SQL.
static Condition	DSL.condition(String sql) Create a new condition holding plain SQL.
static Condition	DSL.condition(String sql, Object... bindings) Create a new condition holding plain SQL.
static Condition	DSL.condition(String sql, QueryPart... parts) A custom SQL clause that can render arbitrary SQL elements.
static Field<Object>	DSL.field(SQL sql) Create a "plain SQL" field.
static <T> Field<T>	DSL.field(SQL sql, Class<T> type) Create a "plain SQL" field.
static <T> Field<T>	DSL.field(SQL sql, DataType<T> type) Create a "plain SQL" field.
static Field<Object>	DSL.field(String sql) Create a "plain SQL" field.
static <T> Field<T>	DSL.field(String sql, Class<T> type) Create a "plain SQL" field.
static <T> Field<T>	DSL.field(String sql, Class<T> type, Object... bindings) Create a "plain SQL" field.
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) Create a "plain SQL" field.
static <T> Field<T>	DSL.field(String sql, DataType<T> type, Object... bindings) Create a "plain SQL" field.
static <T> Field<T>	DSL.field(String sql, DataType<T> type, QueryPart... parts) Create a "plain SQL" field.
static Field<Object>	DSL.field(String sql, Object... bindings) Create a "plain SQL" field.
static Field<Object>	DSL.field(String sql, QueryPart... parts) A custom SQL clause that can render arbitrary SQL elements.
static <T> Field<T>	DSL.function(String name, Class<T> type, Field<?>... arguments) function() can be used to access native or user-defined functions that are not yet or insufficiently supported by jOOQ.
static <T> Field<T>	DSL.function(String name, DataType<T> type, Field<?>... arguments) function() can be used to access native or user-defined functions that are not yet or insufficiently supported by jOOQ.
static Query	DSL.query(SQL sql) Create a new query holding plain SQL.
static Query	DSL.query(String sql) Create a new query holding plain SQL.
static Query	DSL.query(String sql, Object... bindings) Create a new query holding plain SQL.
static Query	DSL.query(String sql, QueryPart... parts) Create a new query holding plain SQL.
static QueryPart	DSL.queryPart(String sql) Deprecated. - 3.6.0 - [#3854] - Use DSL.sql(String) instead
static QueryPart	DSL.queryPart(String sql, Object... bindings) Deprecated. - 3.6.0 - [#3854] - Use DSL.sql(String, Object...) instead
static QueryPart	DSL.queryPart(String sql, QueryPart... parts) Deprecated. - 3.6.0 - [#3854] - Use DSL.sql(String, QueryPart...) instead
static ResultQuery<Record>	DSL.resultQuery(SQL sql) Create a new query holding plain SQL.
static ResultQuery<Record>	DSL.resultQuery(String sql) Create a new query holding plain SQL.
static ResultQuery<Record>	DSL.resultQuery(String sql, Object... bindings) Create a new query holding plain SQL.
static ResultQuery<Record>	DSL.resultQuery(String sql, QueryPart... parts) Create a new query holding plain SQL.
static Sequence<BigInteger>	DSL.sequence(String sql) Create a "plain SQL" sequence.
static <T extends Number> Sequence<T>	DSL.sequence(String sql, Class<T> type) Create a "plain SQL" sequence.
static <T extends Number> Sequence<T>	DSL.sequence(String sql, DataType<T> type) Create a "plain SQL" sequence.
static SQL	DSL.sql(String sql) A custom SQL clause that can render arbitrary expressions.
static SQL	DSL.sql(String sql, Object... bindings) A custom SQL clause that can render arbitrary expressions.
static SQL	DSL.sql(String sql, QueryPart... parts) A custom SQL clause that can render arbitrary expressions.
static Table<Record>	DSL.table(SQL sql) A custom SQL clause that can render arbitrary table expressions.
static Table<Record>	DSL.table(String sql) A custom SQL clause that can render arbitrary table expressions.
static Table<Record>	DSL.table(String sql, Object... bindings) A custom SQL clause that can render arbitrary table expressions.
static Table<Record>	DSL.table(String sql, QueryPart... parts) A custom SQL clause that can render arbitrary table expressions.