Top Description Methods
org.jooq

public Interface WithAsStep

Known Direct Implementers
org.jooq.impl.WithImpl
Static Imports
org.jooq.SQLDialect.FIREBIRD, .SQLDialect.H2, .SQLDialect.HSQLDB, .SQLDialect.IGNITE, .SQLDialect.MARIADB, .SQLDialect.MYSQL, .SQLDialect.POSTGRES, .SQLDialect.SQLITE, .SQLDialect.YUGABYTEDB

This type is part of the jOOQ DSL to create 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")

Referencing 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:

Author
Lukas Eder

Method Summary

Modifier and TypeMethod 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.

Method Detail

asback to summary
public @NotNull WithStep as(ResultQuery<?> query)

Associate a subselect with a common table expression's table and column names.

Annotations
@NotNull
@CheckReturnValue
@Support
asMaterializedback 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 MATERIALIZED hint to the common table expression definition, or silently ignores it, if the hint is not supported.

Annotations
@NotNull
@CheckReturnValue
@Support
asNotMaterializedback 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 NOT MATERIALIZED hint to the common table expression definition, or silently ignores it, if the hint is not supported.

Annotations
@NotNull
@CheckReturnValue
@Support