-
-
Method Summary
All Methods Instance Methods Abstract Methods Modifier and Type Method Description @NotNull WithStep
as(Select<? extends Record1<?>> select)
Associate a subselect with a common table expression's table and column names.@NotNull WithStep
asMaterialized(Select<? extends Record1<?>> select)
Associate a materialized subselect with a common table expression's table and column names.@NotNull WithStep
asNotMaterialized(Select<? extends Record1<?>> select)
Associate a non-materialized subselect with a common table expression's table and column names.
-
-
-
Method Detail
-
as
@NotNull @Support({AURORA_POSTGRES,COCKROACHDB,DB2,FIREBIRD,H2,HANA,HSQLDB,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA}) @NotNull WithStep as(Select<? extends Record1<?>> select)
Associate a subselect with a common table expression's table and column names.
-
asMaterialized
@NotNull @Support({AURORA_POSTGRES,COCKROACHDB,DB2,FIREBIRD,H2,HANA,HSQLDB,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA}) @NotNull WithStep asMaterialized(Select<? extends Record1<?>> select)
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.
-
asNotMaterialized
@NotNull @Support({AURORA_POSTGRES,COCKROACHDB,DB2,FIREBIRD,H2,HANA,HSQLDB,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,VERTICA}) @NotNull WithStep asNotMaterialized(Select<? extends Record1<?>> select)
Associate a non-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.
-
-