Select, Insert,
Update, Delete, Merge statements prefixed with a
WITH clause and with CommonTableExpressions.
Example:
DSL.with("table", "col1", "col2")
.as(
select(one(), two())
)
.select()
.from("table")
XYZ*Step types directly from client code
It is usually not recommended to reference any XYZ*Step types
directly from client code, or assign them to local variables. When writing
dynamic SQL, creating a statement's components dynamically, and passing them
to the DSL API statically is usually a better choice. See the manual's
section about dynamic SQL for details: https://www.jooq.org/doc/latest/manual/sql-building/dynamic-sql.
Drawbacks of referencing the XYZ*Step types directly:
| Modifier and Type | Method and Description |
|---|---|
| public @NotNull WithStep | as(ResultQuery<?> query)
Associate a subselect with a common table expression's table and column names. |
| public @NotNull WithStep | asMaterialized(ResultQuery<?> query)
Associate a materialized subselect with a common table expression's table and column names. |
| public @NotNull WithStep | asNotMaterialized(ResultQuery<?> query)
Associate a materialized subselect with a common table expression's table and column names. |
| as | back to summary |
|---|---|
| public @NotNull WithStep as(ResultQuery<?> query) Associate a subselect with a common table expression's table and column names.
| |
| asMaterialized | back to summary |
|---|---|
| public @NotNull WithStep asMaterialized(ResultQuery<?> query) Associate a materialized subselect with a common table expression's table and column names.
This adds the PostgreSQL 12
| |
| asNotMaterialized | back to summary |
|---|---|
| public @NotNull WithStep asNotMaterialized(ResultQuery<?> query) Associate a materialized subselect with a common table expression's table and column names.
This adds the PostgreSQL 12
| |