All Superinterfaces:: Comparable<Name>, QueryPart, Serializable

public interface Name extends QueryPart, Comparable<Name>

An identifier.

A Name or identifier is a QueryPart that renders a SQL identifier according to the settings specified in Settings.getRenderQuotedNames() and Settings.getRenderNameCase().

Example:

// Assuming import static org.jooq.impl.DSL.*;

using(configuration)
   .select(
        field(name("FIRST_NAME"), SQLDataType.VARCHAR),
        field(name("LAST_NAME"), SQLDataType.VARCHAR))
   .from(table(name("ACTOR")))
   .fetch();

Instances can be created using DSL.name(String) and overloads.

Author:: Lukas Eder

Nested Class Summary

Nested Classes

Modifier and Type

Interface

Description

static enum

Name.Quoted

A flag indicating whether the name is quoted or not.
Method Summary

Modifier and Type

Method

Description

@NotNull Name

append(String name)

Appends name to this name.

@NotNull Name

append(Name name)

Appends name (all of its parts()) to this name.

@NotNull WindowDefinition

as()

Create an empty WindowDefinition from this name.

<R extends Record> @NotNull CommonTableExpression<R>

as(ResultQuery<R> query)

Specify a subselect to refer to by the Name to form a common table expression.

@NotNull WindowDefinition

as(WindowSpecification window)

Create a WindowDefinition from this name.

<R extends Record> @NotNull CommonTableExpression<R>

asMaterialized(ResultQuery<R> query)

Specify a materialized subselect to refer to by the Name to form a common table expression.

<R extends Record> @NotNull CommonTableExpression<R>

asNotMaterialized(ResultQuery<R> query)

Specify a non-materialized subselect to refer to by the Name to form a common table expression.

int

compareTo(Name o)

Compare two unquotedName() by their qualified string versions.

boolean

empty()

Whether this is the empty name.

boolean

equals(Object other)

Check whether this QueryPart can be considered equal to another QueryPart.

boolean

equalsIgnoreCase(Name other)

Compare this name with another one ignoring case.

@NotNull DerivedColumnList1

fields(String fieldName1)

Add a list of fields to this name to make this name a DerivedColumnList.

@NotNull DerivedColumnList

fields(String... fieldNames)

Add a list of fields to this name to make this name a DerivedColumnList.

@NotNull DerivedColumnList2

fields(String fieldName1, String fieldName2)

Add a list of fields to this name to make this name a DerivedColumnList.

@NotNull DerivedColumnList3

fields(String fieldName1, String fieldName2, String fieldName3)

Add a list of fields to this name to make this name a DerivedColumnList.

@NotNull DerivedColumnList4

fields(String fieldName1, String fieldName2, String fieldName3, String fieldName4)

Add a list of fields to this name to make this name a DerivedColumnList.

@NotNull DerivedColumnList5

fields(String fieldName1, String fieldName2, String fieldName3, String fieldName4, String fieldName5)

Add a list of fields to this name to make this name a DerivedColumnList.

@NotNull DerivedColumnList6

fields(String fieldName1, String fieldName2, String fieldName3, String fieldName4, String fieldName5, String fieldName6)

Add a list of fields to this name to make this name a DerivedColumnList.

@NotNull DerivedColumnList7

fields(String fieldName1, String fieldName2, String fieldName3, String fieldName4, String fieldName5, String fieldName6, String fieldName7)

Add a list of fields to this name to make this name a DerivedColumnList.

@NotNull DerivedColumnList8

fields(String fieldName1, String fieldName2, String fieldName3, String fieldName4, String fieldName5, String fieldName6, String fieldName7, String fieldName8)

Add a list of fields to this name to make this name a DerivedColumnList.

@NotNull DerivedColumnList9

fields(String fieldName1, String fieldName2, String fieldName3, String fieldName4, String fieldName5, String fieldName6, String fieldName7, String fieldName8, String fieldName9)

Add a list of fields to this name to make this name a DerivedColumnList.

@NotNull DerivedColumnList10

fields(String fieldName1, String fieldName2, String fieldName3, String fieldName4, String fieldName5, String fieldName6, String fieldName7, String fieldName8, String fieldName9, String fieldName10)

Add a list of fields to this name to make this name a DerivedColumnList.

@NotNull DerivedColumnList11

fields(String fieldName1, String fieldName2, String fieldName3, String fieldName4, String fieldName5, String fieldName6, String fieldName7, String fieldName8, String fieldName9, String fieldName10, String fieldName11)

Add a list of fields to this name to make this name a DerivedColumnList.

@NotNull DerivedColumnList12

fields(String fieldName1, String fieldName2, String fieldName3, String fieldName4, String fieldName5, String fieldName6, String fieldName7, String fieldName8, String fieldName9, String fieldName10, String fieldName11, String fieldName12)

Add a list of fields to this name to make this name a DerivedColumnList.

@NotNull DerivedColumnList13

fields(String fieldName1, String fieldName2, String fieldName3, String fieldName4, String fieldName5, String fieldName6, String fieldName7, String fieldName8, String fieldName9, String fieldName10, String fieldName11, String fieldName12, String fieldName13)

Add a list of fields to this name to make this name a DerivedColumnList.

@NotNull DerivedColumnList14

fields(String fieldName1, String fieldName2, String fieldName3, String fieldName4, String fieldName5, String fieldName6, String fieldName7, String fieldName8, String fieldName9, String fieldName10, String fieldName11, String fieldName12, String fieldName13, String fieldName14)

Add a list of fields to this name to make this name a DerivedColumnList.

@NotNull DerivedColumnList15

fields(String fieldName1, String fieldName2, String fieldName3, String fieldName4, String fieldName5, String fieldName6, String fieldName7, String fieldName8, String fieldName9, String fieldName10, String fieldName11, String fieldName12, String fieldName13, String fieldName14, String fieldName15)

Add a list of fields to this name to make this name a DerivedColumnList.

@NotNull DerivedColumnList16

fields(String fieldName1, String fieldName2, String fieldName3, String fieldName4, String fieldName5, String fieldName6, String fieldName7, String fieldName8, String fieldName9, String fieldName10, String fieldName11, String fieldName12, String fieldName13, String fieldName14, String fieldName15, String fieldName16)

Add a list of fields to this name to make this name a DerivedColumnList.

@NotNull DerivedColumnList17

fields(String fieldName1, String fieldName2, String fieldName3, String fieldName4, String fieldName5, String fieldName6, String fieldName7, String fieldName8, String fieldName9, String fieldName10, String fieldName11, String fieldName12, String fieldName13, String fieldName14, String fieldName15, String fieldName16, String fieldName17)

Add a list of fields to this name to make this name a DerivedColumnList.

@NotNull DerivedColumnList18

fields(String fieldName1, String fieldName2, String fieldName3, String fieldName4, String fieldName5, String fieldName6, String fieldName7, String fieldName8, String fieldName9, String fieldName10, String fieldName11, String fieldName12, String fieldName13, String fieldName14, String fieldName15, String fieldName16, String fieldName17, String fieldName18)

Add a list of fields to this name to make this name a DerivedColumnList.

@NotNull DerivedColumnList19

fields(String fieldName1, String fieldName2, String fieldName3, String fieldName4, String fieldName5, String fieldName6, String fieldName7, String fieldName8, String fieldName9, String fieldName10, String fieldName11, String fieldName12, String fieldName13, String fieldName14, String fieldName15, String fieldName16, String fieldName17, String fieldName18, String fieldName19)

Add a list of fields to this name to make this name a DerivedColumnList.

@NotNull DerivedColumnList20

fields(String fieldName1, String fieldName2, String fieldName3, String fieldName4, String fieldName5, String fieldName6, String fieldName7, String fieldName8, String fieldName9, String fieldName10, String fieldName11, String fieldName12, String fieldName13, String fieldName14, String fieldName15, String fieldName16, String fieldName17, String fieldName18, String fieldName19, String fieldName20)

Add a list of fields to this name to make this name a DerivedColumnList.

@NotNull DerivedColumnList21

fields(String fieldName1, String fieldName2, String fieldName3, String fieldName4, String fieldName5, String fieldName6, String fieldName7, String fieldName8, String fieldName9, String fieldName10, String fieldName11, String fieldName12, String fieldName13, String fieldName14, String fieldName15, String fieldName16, String fieldName17, String fieldName18, String fieldName19, String fieldName20, String fieldName21)

Add a list of fields to this name to make this name a DerivedColumnList.

@NotNull DerivedColumnList22

fields(String fieldName1, String fieldName2, String fieldName3, String fieldName4, String fieldName5, String fieldName6, String fieldName7, String fieldName8, String fieldName9, String fieldName10, String fieldName11, String fieldName12, String fieldName13, String fieldName14, String fieldName15, String fieldName16, String fieldName17, String fieldName18, String fieldName19, String fieldName20, String fieldName21, String fieldName22)

Add a list of fields to this name to make this name a DerivedColumnList.

@NotNull DerivedColumnList

fields(BiFunction<? super Field<?>, ? super Integer, ? extends String> fieldNameFunction)

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.

@NotNull DerivedColumnList

fields(Function<? super Field<?>, ? extends String> fieldNameFunction)

Deprecated, for removal: This API element is subject to removal in a future version.
- 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.

@NotNull DerivedColumnList1

fields(Name fieldName1)

Add a list of fields to this name to make this name a DerivedColumnList.

@NotNull DerivedColumnList

fields(Name... fieldNames)

Add a list of fields to this name to make this name a DerivedColumnList.

@NotNull DerivedColumnList2

fields(Name fieldName1, Name fieldName2)

Add a list of fields to this name to make this name a DerivedColumnList.

@NotNull DerivedColumnList3

fields(Name fieldName1, Name fieldName2, Name fieldName3)

Add a list of fields to this name to make this name a DerivedColumnList.

@NotNull DerivedColumnList4

fields(Name fieldName1, Name fieldName2, Name fieldName3, Name fieldName4)

Add a list of fields to this name to make this name a DerivedColumnList.

@NotNull DerivedColumnList5

fields(Name fieldName1, Name fieldName2, Name fieldName3, Name fieldName4, Name fieldName5)

Add a list of fields to this name to make this name a DerivedColumnList.

@NotNull DerivedColumnList6

fields(Name fieldName1, Name fieldName2, Name fieldName3, Name fieldName4, Name fieldName5, Name fieldName6)

Add a list of fields to this name to make this name a DerivedColumnList.

@NotNull DerivedColumnList7

fields(Name fieldName1, Name fieldName2, Name fieldName3, Name fieldName4, Name fieldName5, Name fieldName6, Name fieldName7)

Add a list of fields to this name to make this name a DerivedColumnList.

@NotNull DerivedColumnList8

fields(Name fieldName1, Name fieldName2, Name fieldName3, Name fieldName4, Name fieldName5, Name fieldName6, Name fieldName7, Name fieldName8)

Add a list of fields to this name to make this name a DerivedColumnList.

@NotNull DerivedColumnList9

fields(Name fieldName1, Name fieldName2, Name fieldName3, Name fieldName4, Name fieldName5, Name fieldName6, Name fieldName7, Name fieldName8, Name fieldName9)

Add a list of fields to this name to make this name a DerivedColumnList.

@NotNull DerivedColumnList10

fields(Name fieldName1, Name fieldName2, Name fieldName3, Name fieldName4, Name fieldName5, Name fieldName6, Name fieldName7, Name fieldName8, Name fieldName9, Name fieldName10)

Add a list of fields to this name to make this name a DerivedColumnList.

@NotNull DerivedColumnList11

fields(Name fieldName1, Name fieldName2, Name fieldName3, Name fieldName4, Name fieldName5, Name fieldName6, Name fieldName7, Name fieldName8, Name fieldName9, Name fieldName10, Name fieldName11)

Add a list of fields to this name to make this name a DerivedColumnList.

@NotNull DerivedColumnList12

fields(Name fieldName1, Name fieldName2, Name fieldName3, Name fieldName4, Name fieldName5, Name fieldName6, Name fieldName7, Name fieldName8, Name fieldName9, Name fieldName10, Name fieldName11, Name fieldName12)

Add a list of fields to this name to make this name a DerivedColumnList.

@NotNull DerivedColumnList13

fields(Name fieldName1, Name fieldName2, Name fieldName3, Name fieldName4, Name fieldName5, Name fieldName6, Name fieldName7, Name fieldName8, Name fieldName9, Name fieldName10, Name fieldName11, Name fieldName12, Name fieldName13)

Add a list of fields to this name to make this name a DerivedColumnList.

@NotNull DerivedColumnList14

fields(Name fieldName1, Name fieldName2, Name fieldName3, Name fieldName4, Name fieldName5, Name fieldName6, Name fieldName7, Name fieldName8, Name fieldName9, Name fieldName10, Name fieldName11, Name fieldName12, Name fieldName13, Name fieldName14)

Add a list of fields to this name to make this name a DerivedColumnList.

@NotNull DerivedColumnList15

fields(Name fieldName1, Name fieldName2, Name fieldName3, Name fieldName4, Name fieldName5, Name fieldName6, Name fieldName7, Name fieldName8, Name fieldName9, Name fieldName10, Name fieldName11, Name fieldName12, Name fieldName13, Name fieldName14, Name fieldName15)

Add a list of fields to this name to make this name a DerivedColumnList.

@NotNull DerivedColumnList16

fields(Name fieldName1, Name fieldName2, Name fieldName3, Name fieldName4, Name fieldName5, Name fieldName6, Name fieldName7, Name fieldName8, Name fieldName9, Name fieldName10, Name fieldName11, Name fieldName12, Name fieldName13, Name fieldName14, Name fieldName15, Name fieldName16)

Add a list of fields to this name to make this name a DerivedColumnList.

@NotNull DerivedColumnList17

fields(Name fieldName1, Name fieldName2, Name fieldName3, Name fieldName4, Name fieldName5, Name fieldName6, Name fieldName7, Name fieldName8, Name fieldName9, Name fieldName10, Name fieldName11, Name fieldName12, Name fieldName13, Name fieldName14, Name fieldName15, Name fieldName16, Name fieldName17)

Add a list of fields to this name to make this name a DerivedColumnList.

@NotNull DerivedColumnList18

fields(Name fieldName1, Name fieldName2, Name fieldName3, Name fieldName4, Name fieldName5, Name fieldName6, Name fieldName7, Name fieldName8, Name fieldName9, Name fieldName10, Name fieldName11, Name fieldName12, Name fieldName13, Name fieldName14, Name fieldName15, Name fieldName16, Name fieldName17, Name fieldName18)

Add a list of fields to this name to make this name a DerivedColumnList.

@NotNull DerivedColumnList19

fields(Name fieldName1, Name fieldName2, Name fieldName3, Name fieldName4, Name fieldName5, Name fieldName6, Name fieldName7, Name fieldName8, Name fieldName9, Name fieldName10, Name fieldName11, Name fieldName12, Name fieldName13, Name fieldName14, Name fieldName15, Name fieldName16, Name fieldName17, Name fieldName18, Name fieldName19)

Add a list of fields to this name to make this name a DerivedColumnList.

@NotNull DerivedColumnList20

fields(Name fieldName1, Name fieldName2, Name fieldName3, Name fieldName4, Name fieldName5, Name fieldName6, Name fieldName7, Name fieldName8, Name fieldName9, Name fieldName10, Name fieldName11, Name fieldName12, Name fieldName13, Name fieldName14, Name fieldName15, Name fieldName16, Name fieldName17, Name fieldName18, Name fieldName19, Name fieldName20)

Add a list of fields to this name to make this name a DerivedColumnList.

@NotNull DerivedColumnList21

fields(Name fieldName1, Name fieldName2, Name fieldName3, Name fieldName4, Name fieldName5, Name fieldName6, Name fieldName7, Name fieldName8, Name fieldName9, Name fieldName10, Name fieldName11, Name fieldName12, Name fieldName13, Name fieldName14, Name fieldName15, Name fieldName16, Name fieldName17, Name fieldName18, Name fieldName19, Name fieldName20, Name fieldName21)

Add a list of fields to this name to make this name a DerivedColumnList.

@NotNull DerivedColumnList22

fields(Name fieldName1, Name fieldName2, Name fieldName3, Name fieldName4, Name fieldName5, Name fieldName6, Name fieldName7, Name fieldName8, Name fieldName9, Name fieldName10, Name fieldName11, Name fieldName12, Name fieldName13, Name fieldName14, Name fieldName15, Name fieldName16, Name fieldName17, Name fieldName18, Name fieldName19, Name fieldName20, Name fieldName21, Name fieldName22)

Add a list of fields to this name to make this name a DerivedColumnList.

@Nullable String

first()

Get the first segment of the qualified name (usually a Catalog or Schema name).

@NotNull String @NotNull []

getName()

The qualified name of this SQL identifier.

@Nullable String

last()

Get the last segment of the qualified name (usually a Table, Field, or Parameter name).

@NotNull Name @NotNull []

parts()

Get the individual, unqualified name parts of this name.

boolean

qualified()

Whether this is a qualified name.

@Nullable Name

qualifier()

This name's qualifier (if it is qualified()), or null.

boolean

qualifierQualified()

Whether this is a qualified name and the qualifier() is also a qualified name.

@NotNull Name.Quoted

quoted()

Whether this is a quoted name.

@NotNull Name

quotedName()

This name, quoted.

@NotNull Name

unqualifiedName()

This name, unqualified.

@NotNull Name

unquotedName()

This name, unquoted.

Methods inherited from interface QueryPart
$replace, $replace, $traverse, $traverse, hashCode, toString

Method Details
- first
  
  @Nullable @Nullable String first()
  
  Get the first segment of the qualified name (usually a Catalog or Schema name).
- last
  
  @Nullable @Nullable String last()
  
  Get the last segment of the qualified name (usually a Table, Field, or Parameter name).
- empty
  
  boolean empty()
  
  Whether this is the empty name.
  An unnamed object will have an "" empty string as its name. If a table has no explicit schema, it will be located in the default schema whose name is "".
- qualified
  
  boolean qualified()
  
  Whether this is a qualified name.
  This is true as soon as getName() has a length of more than 1 and qualifier() is not null.
- qualifierQualified
  
  boolean qualifierQualified()
  
  Whether this is a qualified name and the qualifier() is also a qualified name.
  This is true as soon as getName() has a length of more than 2 and qualifier() is not null and its qualified() property is also true.
- qualifier
  
  @Nullable @Nullable Name qualifier()
  
  This name's qualifier (if it is qualified()), or null.
- unqualifiedName
  
  @NotNull @NotNull Name unqualifiedName()
  
  This name, unqualified.
- quoted
  
  @NotNull @NotNull Name.Quoted quoted()
  
  Whether this is a quoted name.
- quotedName
  
  @NotNull @NotNull Name quotedName()
  
  This name, quoted.
- unquotedName
  
  @NotNull @NotNull Name unquotedName()
  
  This name, unquoted.
- parts
  
  @NotNull @NotNull Name @NotNull [] parts()
  
  Get the individual, unqualified name parts of this name.
- append
  
  @NotNull @NotNull Name append(String name)
  
  Appends name to this name.
- append
  
  @NotNull @NotNull Name append(Name name)
  
  Appends name (all of its parts()) to this name.
- getName
  
  @NotNull @NotNull String @NotNull [] getName()
  
  The qualified name of this SQL identifier.
- as
  @NotNull @Support({AURORA_POSTGRES,BIGQUERY,CLICKHOUSE,COCKROACHDB,CUBRID,DATABRICKS,DB2,DUCKDB,EXASOL,FIREBIRD_3_0,H2,HANA,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,REDSHIFT,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,TRINO,VERTICA,YUGABYTEDB}) @NotNull WindowDefinition as()
  
  Create an empty WindowDefinition from this name.
  A window definition renders itself differently, depending on Context.declareWindows(). There are two rendering modes:
  
  Declaration: The window definition renders its window name (this) along with the AS (window specification) clause. This typically happens in WINDOW clauses.
  
  Reference: The window definition renders its alias identifier. This happens everywhere else.
  
  See Also:
  
  as(WindowSpecification)
- as
  @NotNull @Support({AURORA_POSTGRES,BIGQUERY,CLICKHOUSE,COCKROACHDB,CUBRID,DATABRICKS,DB2,DUCKDB,EXASOL,FIREBIRD_3_0,H2,HANA,INFORMIX,MARIADB,MEMSQL,MYSQL_8_0,ORACLE,POSTGRES,REDSHIFT,SNOWFLAKE,SQLDATAWAREHOUSE,SQLITE,SQLSERVER,SYBASE,TERADATA,TRINO,VERTICA,YUGABYTEDB}) @NotNull WindowDefinition as(WindowSpecification window)
  
  Create a WindowDefinition from this name.
  This creates a window definition that can be
  
  declared in the WINDOW clause (see SelectWindowStep.window(WindowDefinition...)
  
  referenced from the OVER clause (see WindowOverStep.over(WindowDefinition)
  
  A window definition renders itself differently, depending on Context.declareWindows(). There are two rendering modes:
  
  Declaration: The window definition renders its window name (this) along with the AS (window specification) clause. This typically happens in WINDOW clauses.
  
  Reference: The window definition renders its alias identifier. This happens everywhere else.
- as
  @NotNull @Support <R extends Record> @NotNull CommonTableExpression<R> as(ResultQuery<R> query)
  
  Specify a subselect to refer to by the Name to form a common table expression.
  Column names are implicitly inherited from the SELECT statement.
  A common table expression renders itself differently, depending on Context.declareCTE(). There are two rendering modes:
  
  Declaration: The common table expression renders its CTE name (this) along with the AS (query) clause. This typically happens in WITH clauses.
  
  Reference: The common table expression renders its alias identifier. This happens everywhere else.
- asMaterialized
  @NotNull @Support <R extends Record> @NotNull CommonTableExpression<R> asMaterialized(ResultQuery<R> query)
  
  Specify a materialized subselect to refer to by the Name to form a common table expression.
  This adds the PostgreSQL 12 MATERIALIZED hint to the common table expression definition, or silently ignores it, if the hint is not supported.
  Column names are implicitly inherited from the SELECT statement.
  A common table expression renders itself differently, depending on Context.declareCTE(). There are two rendering modes:
  
  Declaration: The common table expression renders its CTE name (this) along with the AS (query) clause. This typically happens in WITH clauses.
  
  Reference: The common table expression renders its alias identifier. This happens everywhere else.
- asNotMaterialized
  @NotNull @Support <R extends Record> @NotNull CommonTableExpression<R> asNotMaterialized(ResultQuery<R> query)
  
  Specify a non-materialized subselect to refer to by the Name to form a common table expression.
  This adds the PostgreSQL 12 NOT MATERIALIZED hint to the common table expression definition, or silently ignores it, if the hint is not supported.
  Column names are implicitly inherited from the SELECT statement.
  A common table expression renders itself differently, depending on Context.declareCTE(). There are two rendering modes:
  
  Declaration: The common table expression renders its CTE name (this) along with the AS (query) clause. This typically happens in WITH clauses.
  
  Reference: The common table expression renders its alias identifier. This happens everywhere else.
- fields
  
  @NotNull @Support @NotNull DerivedColumnList fields(String... fieldNames)
  
  Add a list of fields to this name to make this name a DerivedColumnList.
  The DerivedColumnList can then be used along with a subselect to form a CommonTableExpression to be used with WITH clauses.
- fields
  
  @NotNull @Support @NotNull DerivedColumnList fields(Name... fieldNames)
  
  Add a list of fields to this name to make this name a DerivedColumnList.
  The DerivedColumnList can then be used along with a subselect to form a CommonTableExpression to be used with WITH clauses.
- fields
  
  @Deprecated(forRemoval=true, since="3.14") @NotNull @Support @NotNull DerivedColumnList fields(Function<? super Field<?>, ? extends String> fieldNameFunction)
  
  Deprecated, for removal: This API element is subject to removal in a future version.
  - 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ. They offer convenience that is unidiomatic for jOOQ's DSL, without offering functionality that would not be possible otherwise - yet they add complexity in jOOQ's internals.
  
  Add a list of fields to this name to make this name a DerivedColumnList.
  The DerivedColumnList can then be used along with a subselect to form a CommonTableExpression to be used with WITH clauses.
  This works in a similar way as fields(String...), except that all column names are produced by a function that receives the CTE's Select columns and their column indexes as input.
- fields
  
  @Deprecated(forRemoval=true, since="3.14") @NotNull @Support @NotNull DerivedColumnList fields(BiFunction<? super Field<?>, ? super Integer, ? extends String> fieldNameFunction)
  
  Deprecated, for removal: This API element is subject to removal in a future version.
  - 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ. They offer convenience that is unidiomatic for jOOQ's DSL, without offering functionality that would not be possible otherwise - yet they add complexity in jOOQ's internals.
  
  Add a list of fields to this name to make this name a DerivedColumnList.
  The DerivedColumnList can then be used along with a subselect to form a CommonTableExpression to be used with WITH clauses.
  This works in a similar way as fields(String...), except that all column names are produced by a function that receives the CTE's Select columns as input.
- fields
  
  @NotNull @Support @NotNull DerivedColumnList1 fields(String fieldName1)
  
  Add a list of fields to this name to make this name a DerivedColumnList.
  The DerivedColumnList can then be used along with a subselect to form a CommonTableExpression to be used with WITH clauses.
- fields
  
  @NotNull @Support @NotNull DerivedColumnList2 fields(String fieldName1, String fieldName2)
  
  Add a list of fields to this name to make this name a DerivedColumnList.
  The DerivedColumnList can then be used along with a subselect to form a CommonTableExpression to be used with WITH clauses.
- fields
  
  @NotNull @Support @NotNull DerivedColumnList3 fields(String fieldName1, String fieldName2, String fieldName3)
  
  Add a list of fields to this name to make this name a DerivedColumnList.
  The DerivedColumnList can then be used along with a subselect to form a CommonTableExpression to be used with WITH clauses.
- fields
  
  @NotNull @Support @NotNull DerivedColumnList4 fields(String fieldName1, String fieldName2, String fieldName3, String fieldName4)
  
  Add a list of fields to this name to make this name a DerivedColumnList.
  The DerivedColumnList can then be used along with a subselect to form a CommonTableExpression to be used with WITH clauses.
- fields
  
  @NotNull @Support @NotNull DerivedColumnList5 fields(String fieldName1, String fieldName2, String fieldName3, String fieldName4, String fieldName5)
  
  Add a list of fields to this name to make this name a DerivedColumnList.
  The DerivedColumnList can then be used along with a subselect to form a CommonTableExpression to be used with WITH clauses.
- fields
  
  @NotNull @Support @NotNull DerivedColumnList6 fields(String fieldName1, String fieldName2, String fieldName3, String fieldName4, String fieldName5, String fieldName6)
  
  Add a list of fields to this name to make this name a DerivedColumnList.
  The DerivedColumnList can then be used along with a subselect to form a CommonTableExpression to be used with WITH clauses.
- fields
  
  @NotNull @Support @NotNull DerivedColumnList7 fields(String fieldName1, String fieldName2, String fieldName3, String fieldName4, String fieldName5, String fieldName6, String fieldName7)
  
  Add a list of fields to this name to make this name a DerivedColumnList.
  The DerivedColumnList can then be used along with a subselect to form a CommonTableExpression to be used with WITH clauses.
- fields
  
  @NotNull @Support @NotNull DerivedColumnList8 fields(String fieldName1, String fieldName2, String fieldName3, String fieldName4, String fieldName5, String fieldName6, String fieldName7, String fieldName8)
  
  Add a list of fields to this name to make this name a DerivedColumnList.
  The DerivedColumnList can then be used along with a subselect to form a CommonTableExpression to be used with WITH clauses.
- fields
  
  @NotNull @Support @NotNull DerivedColumnList9 fields(String fieldName1, String fieldName2, String fieldName3, String fieldName4, String fieldName5, String fieldName6, String fieldName7, String fieldName8, String fieldName9)
  
  Add a list of fields to this name to make this name a DerivedColumnList.
  The DerivedColumnList can then be used along with a subselect to form a CommonTableExpression to be used with WITH clauses.
- fields
  
  @NotNull @Support @NotNull DerivedColumnList10 fields(String fieldName1, String fieldName2, String fieldName3, String fieldName4, String fieldName5, String fieldName6, String fieldName7, String fieldName8, String fieldName9, String fieldName10)
  
  Add a list of fields to this name to make this name a DerivedColumnList.
  The DerivedColumnList can then be used along with a subselect to form a CommonTableExpression to be used with WITH clauses.
- fields
  
  @NotNull @Support @NotNull DerivedColumnList11 fields(String fieldName1, String fieldName2, String fieldName3, String fieldName4, String fieldName5, String fieldName6, String fieldName7, String fieldName8, String fieldName9, String fieldName10, String fieldName11)
  
  Add a list of fields to this name to make this name a DerivedColumnList.
  The DerivedColumnList can then be used along with a subselect to form a CommonTableExpression to be used with WITH clauses.
- fields
  
  @NotNull @Support @NotNull DerivedColumnList12 fields(String fieldName1, String fieldName2, String fieldName3, String fieldName4, String fieldName5, String fieldName6, String fieldName7, String fieldName8, String fieldName9, String fieldName10, String fieldName11, String fieldName12)
  
  Add a list of fields to this name to make this name a DerivedColumnList.
  The DerivedColumnList can then be used along with a subselect to form a CommonTableExpression to be used with WITH clauses.
- fields
  
  @NotNull @Support @NotNull DerivedColumnList13 fields(String fieldName1, String fieldName2, String fieldName3, String fieldName4, String fieldName5, String fieldName6, String fieldName7, String fieldName8, String fieldName9, String fieldName10, String fieldName11, String fieldName12, String fieldName13)
  
  Add a list of fields to this name to make this name a DerivedColumnList.
  The DerivedColumnList can then be used along with a subselect to form a CommonTableExpression to be used with WITH clauses.
- fields
  
  @NotNull @Support @NotNull DerivedColumnList14 fields(String fieldName1, String fieldName2, String fieldName3, String fieldName4, String fieldName5, String fieldName6, String fieldName7, String fieldName8, String fieldName9, String fieldName10, String fieldName11, String fieldName12, String fieldName13, String fieldName14)
  
  Add a list of fields to this name to make this name a DerivedColumnList.
  The DerivedColumnList can then be used along with a subselect to form a CommonTableExpression to be used with WITH clauses.
- fields
  
  @NotNull @Support @NotNull DerivedColumnList15 fields(String fieldName1, String fieldName2, String fieldName3, String fieldName4, String fieldName5, String fieldName6, String fieldName7, String fieldName8, String fieldName9, String fieldName10, String fieldName11, String fieldName12, String fieldName13, String fieldName14, String fieldName15)
  
  Add a list of fields to this name to make this name a DerivedColumnList.
  The DerivedColumnList can then be used along with a subselect to form a CommonTableExpression to be used with WITH clauses.
- fields
  
  @NotNull @Support @NotNull DerivedColumnList16 fields(String fieldName1, String fieldName2, String fieldName3, String fieldName4, String fieldName5, String fieldName6, String fieldName7, String fieldName8, String fieldName9, String fieldName10, String fieldName11, String fieldName12, String fieldName13, String fieldName14, String fieldName15, String fieldName16)
  
  Add a list of fields to this name to make this name a DerivedColumnList.
  The DerivedColumnList can then be used along with a subselect to form a CommonTableExpression to be used with WITH clauses.
- fields
  
  @NotNull @Support @NotNull DerivedColumnList17 fields(String fieldName1, String fieldName2, String fieldName3, String fieldName4, String fieldName5, String fieldName6, String fieldName7, String fieldName8, String fieldName9, String fieldName10, String fieldName11, String fieldName12, String fieldName13, String fieldName14, String fieldName15, String fieldName16, String fieldName17)
  
  Add a list of fields to this name to make this name a DerivedColumnList.
  The DerivedColumnList can then be used along with a subselect to form a CommonTableExpression to be used with WITH clauses.
- fields
  
  @NotNull @Support @NotNull DerivedColumnList18 fields(String fieldName1, String fieldName2, String fieldName3, String fieldName4, String fieldName5, String fieldName6, String fieldName7, String fieldName8, String fieldName9, String fieldName10, String fieldName11, String fieldName12, String fieldName13, String fieldName14, String fieldName15, String fieldName16, String fieldName17, String fieldName18)
  
  Add a list of fields to this name to make this name a DerivedColumnList.
  The DerivedColumnList can then be used along with a subselect to form a CommonTableExpression to be used with WITH clauses.
- fields
  
  @NotNull @Support @NotNull DerivedColumnList19 fields(String fieldName1, String fieldName2, String fieldName3, String fieldName4, String fieldName5, String fieldName6, String fieldName7, String fieldName8, String fieldName9, String fieldName10, String fieldName11, String fieldName12, String fieldName13, String fieldName14, String fieldName15, String fieldName16, String fieldName17, String fieldName18, String fieldName19)
  
  Add a list of fields to this name to make this name a DerivedColumnList.
  The DerivedColumnList can then be used along with a subselect to form a CommonTableExpression to be used with WITH clauses.
- fields
  
  @NotNull @Support @NotNull DerivedColumnList20 fields(String fieldName1, String fieldName2, String fieldName3, String fieldName4, String fieldName5, String fieldName6, String fieldName7, String fieldName8, String fieldName9, String fieldName10, String fieldName11, String fieldName12, String fieldName13, String fieldName14, String fieldName15, String fieldName16, String fieldName17, String fieldName18, String fieldName19, String fieldName20)
  
  Add a list of fields to this name to make this name a DerivedColumnList.
  The DerivedColumnList can then be used along with a subselect to form a CommonTableExpression to be used with WITH clauses.
- fields
  
  @NotNull @Support @NotNull DerivedColumnList21 fields(String fieldName1, String fieldName2, String fieldName3, String fieldName4, String fieldName5, String fieldName6, String fieldName7, String fieldName8, String fieldName9, String fieldName10, String fieldName11, String fieldName12, String fieldName13, String fieldName14, String fieldName15, String fieldName16, String fieldName17, String fieldName18, String fieldName19, String fieldName20, String fieldName21)
  
  Add a list of fields to this name to make this name a DerivedColumnList.
  The DerivedColumnList can then be used along with a subselect to form a CommonTableExpression to be used with WITH clauses.
- fields
  
  @NotNull @Support @NotNull DerivedColumnList22 fields(String fieldName1, String fieldName2, String fieldName3, String fieldName4, String fieldName5, String fieldName6, String fieldName7, String fieldName8, String fieldName9, String fieldName10, String fieldName11, String fieldName12, String fieldName13, String fieldName14, String fieldName15, String fieldName16, String fieldName17, String fieldName18, String fieldName19, String fieldName20, String fieldName21, String fieldName22)
  
  Add a list of fields to this name to make this name a DerivedColumnList.
  The DerivedColumnList can then be used along with a subselect to form a CommonTableExpression to be used with WITH clauses.
- fields
  
  @NotNull @Support @NotNull DerivedColumnList1 fields(Name fieldName1)
  
  Add a list of fields to this name to make this name a DerivedColumnList.
  The DerivedColumnList can then be used along with a subselect to form a CommonTableExpression to be used with WITH clauses.
- fields
  
  @NotNull @Support @NotNull DerivedColumnList2 fields(Name fieldName1, Name fieldName2)
  
  Add a list of fields to this name to make this name a DerivedColumnList.
  The DerivedColumnList can then be used along with a subselect to form a CommonTableExpression to be used with WITH clauses.
- fields
  
  @NotNull @Support @NotNull DerivedColumnList3 fields(Name fieldName1, Name fieldName2, Name fieldName3)
  
  Add a list of fields to this name to make this name a DerivedColumnList.
  The DerivedColumnList can then be used along with a subselect to form a CommonTableExpression to be used with WITH clauses.
- fields
  
  @NotNull @Support @NotNull DerivedColumnList4 fields(Name fieldName1, Name fieldName2, Name fieldName3, Name fieldName4)
  
  Add a list of fields to this name to make this name a DerivedColumnList.
  The DerivedColumnList can then be used along with a subselect to form a CommonTableExpression to be used with WITH clauses.
- fields
  
  @NotNull @Support @NotNull DerivedColumnList5 fields(Name fieldName1, Name fieldName2, Name fieldName3, Name fieldName4, Name fieldName5)
  
  Add a list of fields to this name to make this name a DerivedColumnList.
  The DerivedColumnList can then be used along with a subselect to form a CommonTableExpression to be used with WITH clauses.
- fields
  
  @NotNull @Support @NotNull DerivedColumnList6 fields(Name fieldName1, Name fieldName2, Name fieldName3, Name fieldName4, Name fieldName5, Name fieldName6)
  
  Add a list of fields to this name to make this name a DerivedColumnList.
  The DerivedColumnList can then be used along with a subselect to form a CommonTableExpression to be used with WITH clauses.
- fields
  
  @NotNull @Support @NotNull DerivedColumnList7 fields(Name fieldName1, Name fieldName2, Name fieldName3, Name fieldName4, Name fieldName5, Name fieldName6, Name fieldName7)
  
  Add a list of fields to this name to make this name a DerivedColumnList.
  The DerivedColumnList can then be used along with a subselect to form a CommonTableExpression to be used with WITH clauses.
- fields
  
  @NotNull @Support @NotNull DerivedColumnList8 fields(Name fieldName1, Name fieldName2, Name fieldName3, Name fieldName4, Name fieldName5, Name fieldName6, Name fieldName7, Name fieldName8)
  
  Add a list of fields to this name to make this name a DerivedColumnList.
  The DerivedColumnList can then be used along with a subselect to form a CommonTableExpression to be used with WITH clauses.
- fields
  
  @NotNull @Support @NotNull DerivedColumnList9 fields(Name fieldName1, Name fieldName2, Name fieldName3, Name fieldName4, Name fieldName5, Name fieldName6, Name fieldName7, Name fieldName8, Name fieldName9)
  
  Add a list of fields to this name to make this name a DerivedColumnList.
  The DerivedColumnList can then be used along with a subselect to form a CommonTableExpression to be used with WITH clauses.
- fields
  
  @NotNull @Support @NotNull DerivedColumnList10 fields(Name fieldName1, Name fieldName2, Name fieldName3, Name fieldName4, Name fieldName5, Name fieldName6, Name fieldName7, Name fieldName8, Name fieldName9, Name fieldName10)
  
  Add a list of fields to this name to make this name a DerivedColumnList.
  The DerivedColumnList can then be used along with a subselect to form a CommonTableExpression to be used with WITH clauses.
- fields
  
  @NotNull @Support @NotNull DerivedColumnList11 fields(Name fieldName1, Name fieldName2, Name fieldName3, Name fieldName4, Name fieldName5, Name fieldName6, Name fieldName7, Name fieldName8, Name fieldName9, Name fieldName10, Name fieldName11)
  
  Add a list of fields to this name to make this name a DerivedColumnList.
  The DerivedColumnList can then be used along with a subselect to form a CommonTableExpression to be used with WITH clauses.
- fields
  
  @NotNull @Support @NotNull DerivedColumnList12 fields(Name fieldName1, Name fieldName2, Name fieldName3, Name fieldName4, Name fieldName5, Name fieldName6, Name fieldName7, Name fieldName8, Name fieldName9, Name fieldName10, Name fieldName11, Name fieldName12)
  
  Add a list of fields to this name to make this name a DerivedColumnList.
  The DerivedColumnList can then be used along with a subselect to form a CommonTableExpression to be used with WITH clauses.
- fields
  
  @NotNull @Support @NotNull DerivedColumnList13 fields(Name fieldName1, Name fieldName2, Name fieldName3, Name fieldName4, Name fieldName5, Name fieldName6, Name fieldName7, Name fieldName8, Name fieldName9, Name fieldName10, Name fieldName11, Name fieldName12, Name fieldName13)
  
  Add a list of fields to this name to make this name a DerivedColumnList.
  The DerivedColumnList can then be used along with a subselect to form a CommonTableExpression to be used with WITH clauses.
- fields
  
  @NotNull @Support @NotNull DerivedColumnList14 fields(Name fieldName1, Name fieldName2, Name fieldName3, Name fieldName4, Name fieldName5, Name fieldName6, Name fieldName7, Name fieldName8, Name fieldName9, Name fieldName10, Name fieldName11, Name fieldName12, Name fieldName13, Name fieldName14)
  
  Add a list of fields to this name to make this name a DerivedColumnList.
  The DerivedColumnList can then be used along with a subselect to form a CommonTableExpression to be used with WITH clauses.
- fields
  
  @NotNull @Support @NotNull DerivedColumnList15 fields(Name fieldName1, Name fieldName2, Name fieldName3, Name fieldName4, Name fieldName5, Name fieldName6, Name fieldName7, Name fieldName8, Name fieldName9, Name fieldName10, Name fieldName11, Name fieldName12, Name fieldName13, Name fieldName14, Name fieldName15)
  
  Add a list of fields to this name to make this name a DerivedColumnList.
  The DerivedColumnList can then be used along with a subselect to form a CommonTableExpression to be used with WITH clauses.
- fields
  
  @NotNull @Support @NotNull DerivedColumnList16 fields(Name fieldName1, Name fieldName2, Name fieldName3, Name fieldName4, Name fieldName5, Name fieldName6, Name fieldName7, Name fieldName8, Name fieldName9, Name fieldName10, Name fieldName11, Name fieldName12, Name fieldName13, Name fieldName14, Name fieldName15, Name fieldName16)
  
  Add a list of fields to this name to make this name a DerivedColumnList.
  The DerivedColumnList can then be used along with a subselect to form a CommonTableExpression to be used with WITH clauses.
- fields
  
  @NotNull @Support @NotNull DerivedColumnList17 fields(Name fieldName1, Name fieldName2, Name fieldName3, Name fieldName4, Name fieldName5, Name fieldName6, Name fieldName7, Name fieldName8, Name fieldName9, Name fieldName10, Name fieldName11, Name fieldName12, Name fieldName13, Name fieldName14, Name fieldName15, Name fieldName16, Name fieldName17)
  
  Add a list of fields to this name to make this name a DerivedColumnList.
  The DerivedColumnList can then be used along with a subselect to form a CommonTableExpression to be used with WITH clauses.
- fields
  
  @NotNull @Support @NotNull DerivedColumnList18 fields(Name fieldName1, Name fieldName2, Name fieldName3, Name fieldName4, Name fieldName5, Name fieldName6, Name fieldName7, Name fieldName8, Name fieldName9, Name fieldName10, Name fieldName11, Name fieldName12, Name fieldName13, Name fieldName14, Name fieldName15, Name fieldName16, Name fieldName17, Name fieldName18)
  
  Add a list of fields to this name to make this name a DerivedColumnList.
  The DerivedColumnList can then be used along with a subselect to form a CommonTableExpression to be used with WITH clauses.
- fields
  
  @NotNull @Support @NotNull DerivedColumnList19 fields(Name fieldName1, Name fieldName2, Name fieldName3, Name fieldName4, Name fieldName5, Name fieldName6, Name fieldName7, Name fieldName8, Name fieldName9, Name fieldName10, Name fieldName11, Name fieldName12, Name fieldName13, Name fieldName14, Name fieldName15, Name fieldName16, Name fieldName17, Name fieldName18, Name fieldName19)
  
  Add a list of fields to this name to make this name a DerivedColumnList.
  The DerivedColumnList can then be used along with a subselect to form a CommonTableExpression to be used with WITH clauses.
- fields
  
  @NotNull @Support @NotNull DerivedColumnList20 fields(Name fieldName1, Name fieldName2, Name fieldName3, Name fieldName4, Name fieldName5, Name fieldName6, Name fieldName7, Name fieldName8, Name fieldName9, Name fieldName10, Name fieldName11, Name fieldName12, Name fieldName13, Name fieldName14, Name fieldName15, Name fieldName16, Name fieldName17, Name fieldName18, Name fieldName19, Name fieldName20)
  
  Add a list of fields to this name to make this name a DerivedColumnList.
  The DerivedColumnList can then be used along with a subselect to form a CommonTableExpression to be used with WITH clauses.
- fields
  
  @NotNull @Support @NotNull DerivedColumnList21 fields(Name fieldName1, Name fieldName2, Name fieldName3, Name fieldName4, Name fieldName5, Name fieldName6, Name fieldName7, Name fieldName8, Name fieldName9, Name fieldName10, Name fieldName11, Name fieldName12, Name fieldName13, Name fieldName14, Name fieldName15, Name fieldName16, Name fieldName17, Name fieldName18, Name fieldName19, Name fieldName20, Name fieldName21)
  
  Add a list of fields to this name to make this name a DerivedColumnList.
  The DerivedColumnList can then be used along with a subselect to form a CommonTableExpression to be used with WITH clauses.
- fields
  
  @NotNull @Support @NotNull DerivedColumnList22 fields(Name fieldName1, Name fieldName2, Name fieldName3, Name fieldName4, Name fieldName5, Name fieldName6, Name fieldName7, Name fieldName8, Name fieldName9, Name fieldName10, Name fieldName11, Name fieldName12, Name fieldName13, Name fieldName14, Name fieldName15, Name fieldName16, Name fieldName17, Name fieldName18, Name fieldName19, Name fieldName20, Name fieldName21, Name fieldName22)
  
  Add a list of fields to this name to make this name a DerivedColumnList.
  The DerivedColumnList can then be used along with a subselect to form a CommonTableExpression to be used with WITH clauses.
- equals
  
  boolean equals(Object other)
  
  Description copied from interface: QueryPart
  
  Check whether this QueryPart can be considered equal to another QueryPart.
  In general, QueryPart equality is defined in terms of QueryPart.toString() equality. In other words, two query parts are considered equal if their rendered SQL (with inlined bind variables) is equal. This means that the two query parts do not necessarily have to be of the same type.
  Some QueryPart implementations may choose to override this behaviour for improved performance, as QueryPart.toString() is an expensive operation, if called many times.
  
  Specified by:
  
  equals in interface QueryPart
  
  Overrides:
  
  equals in class Object
  
  Parameters:
  
  other - The other QueryPart
  
  Returns:
  
  Whether the two query parts are equal
- equalsIgnoreCase
  
  boolean equalsIgnoreCase(Name other)
  
  Compare this name with another one ignoring case.
- compareTo
  
  int compareTo(Name o)
  
  Compare two unquotedName() by their qualified string versions.
  
  Specified by:
  
  compareTo in interface Comparable<Name>

Interface Name

Nested Class Summary

Method Summary

Methods inherited from interface QueryPart

Method Details

first

last

empty

qualified

qualifierQualified

qualifier

unqualifiedName

quoted

quotedName

unquotedName

parts

append

append

getName

as

as

as

asMaterialized

asNotMaterialized

fields

fields

fields

fields

fields

fields

fields

fields

fields

fields

fields

fields

fields

fields

fields

fields

fields

fields

fields

fields

fields

fields

fields

fields

fields

fields

fields

fields

fields

fields

fields

fields

fields

fields

fields

fields

fields

fields

fields

fields

fields

fields

fields

fields

fields

fields

fields

fields

equals

equalsIgnoreCase

compareTo