org.jooq/jooq/3.14.7 : org/jooq/Name.java

Name
http://www.jooq.org/jooq: jOOQ effectively combines complex SQL, typesafety, source code generation, active records, stored procedures, advanced data types, and Java in a fluent, intuitive DSL.
Apache License, Version 2.0
/*
 * Licensed under the Apache License, Version 2.0 (the "License");
 * you may not use this file except in compliance with the License.
 * You may obtain a copy of the License at
 *
 *  http://www.apache.org/licenses/LICENSE-2.0
 *
 * Unless required by applicable law or agreed to in writing, software
 * distributed under the License is distributed on an "AS IS" BASIS,
 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 * See the License for the specific language governing permissions and
 * limitations under the License.
 *
 * Other licenses:
 * -----------------------------------------------------------------------------
 * Commercial licenses for this work are available. These replace the above
 * ASL 2.0 and offer limited warranties, support, maintenance, and commercial
 * database integrations.
 *
 * For more information, please visit: http://www.jooq.org/licenses
 *
 *
 *
 *
 *
 *
 *
 *
 *
 *
 *
 *
 *
 *
 *
 *
 */
package org.jooq;

// ...
// ...
import static org.jooq.SQLDialect.CUBRID;
// ...
import static org.jooq.SQLDialect.FIREBIRD;
// ...
import static org.jooq.SQLDialect.H2;
// ...
import static org.jooq.SQLDialect.HSQLDB;
// ...
import static org.jooq.SQLDialect.MARIADB;
// ...
import static org.jooq.SQLDialect.MYSQL;
// ...
import static org.jooq.SQLDialect.POSTGRES;
// ...
import static org.jooq.SQLDialect.SQLITE;
// ...
// ...
// ...
// ...

import java.util.function.BiFunction;
import java.util.function.Function;

import org.jooq.conf.RenderQuotedNames;
import org.jooq.conf.Settings;
import org.jooq.impl.DSL;

import org.jetbrains.annotations.NotNull;
import org.jetbrains.annotations.Nullable;

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/**
 * An identifier.
 * <p>
 * A <code>Name</code> or identifier is a {@link QueryPart} that renders a SQL
 * identifier according to the settings specified in
 * {@link Settings#getRenderQuotedNames()} and
 * {@link Settings#getRenderNameCase()}.
 * <p>
 * <strong>Example:</strong>
 * <p>
 * <code><pre>
 * // 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();
 * </pre></code>
 * <p>
 * Instances can be created using {@link DSL#name(String)} and overloads.
 *
 * @author Lukas Eder
 */
public interface Name extends QueryPart, Comparable<Name> {

    A flag indicating whether the name is quoted or not.
 Quoting of names can be overridden by Settings.getRenderQuotedNames(). 
Author: Lukas Eder/**
     * A flag indicating whether the name is quoted or not.
     * <p>
     * Quoting of names can be overridden by
     * {@link Settings#getRenderQuotedNames()}.
     *
     * @author Lukas Eder
     */
    enum Quoted {

        The name is explicitly quoted.
/**
         * The name is explicitly quoted.
         */
        QUOTED,

        The name is explicitly not quoted.
/**
         * The name is explicitly not quoted.
         */
        UNQUOTED,

        The name is not quoted explicitly.
 The behaviour of this name's quoting is governed by RenderQuotedNames.EXPLICIT_DEFAULT_QUOTED and RenderQuotedNames.EXPLICIT_DEFAULT_UNQUOTED. /**
         * The name is not quoted explicitly.
         * <p>
         * The behaviour of this name's quoting is governed by
         * {@link RenderQuotedNames#EXPLICIT_DEFAULT_QUOTED} and
         * {@link RenderQuotedNames#EXPLICIT_DEFAULT_UNQUOTED}.
         */
        DEFAULT,

        The Name.qualified() name has mixed values for individual Name.quoted() flags. /**
         * The {@link Name#qualified()} name has mixed values for individual
         * {@link Name#quoted()} flags.
         */
        MIXED
    }

    Get the first segment of the qualified name (usually a Catalog or Schema name). /**
     * Get the first segment of the qualified name (usually a {@link Catalog} or {@link Schema} name).
     */
    @Nullable
    String first();

    Get the last segment of the qualified name (usually a Table, Field, or Parameter name). /**
     * Get the last segment of the qualified name (usually a {@link Table}, {@link Field}, or {@link Parameter} name).
     */
    @Nullable
    String last();

    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 "".
/**
     * Whether this is the empty name.
     * <p>
     * An unnamed object will have an <code>""</code> empty string as its name.
     * If a table has no explicit schema, it will be located in the default
     * schema whose name is <code>""</code>.
     */
    boolean empty();

    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. /**
     * Whether this is a qualified name.
     * <p>
     * This is <code>true</code> as soon as {@link #getName()} has a length of
     * more than <code>1</code> and {@link #qualifier()} is not null.
     */
    boolean qualified();

    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. /**
     * Whether this is a qualified name and the {@link #qualifier()} is also a
     * qualified name.
     * <p>
     * This is <code>true</code> as soon as {@link #getName()} has a length of
     * more than <code>2</code> and {@link #qualifier()} is not null and its
     * {@link #qualified()} property is also true.
     */
    boolean qualifierQualified();

    This name's qualifier (if it is qualified()), or null.
/**
     * This name's qualifier (if it is {@link #qualified()}), or <code>null</code>.
     */
    @Nullable
    Name qualifier();

    This name, unqualified.
/**
     * This name, unqualified.
     */
    @NotNull
    Name unqualifiedName();

    Whether this is a quoted name.
/**
     * Whether this is a quoted name.
     */
    @NotNull
    Quoted quoted();

    This name, quoted.
/**
     * This name, quoted.
     */
    @NotNull
    Name quotedName();

    This name, unquoted.
/**
     * This name, unquoted.
     */
    @NotNull
    Name unquotedName();

    Get the individual, unqualified name parts of this name.
/**
     * Get the individual, unqualified name parts of this name.
     */
    @NotNull
    Name[] parts();

    Appends name to this name.
/**
     * Appends <code>name</code> to this name.
     */
    @NotNull
    Name append(String name);

    Appends name (all of its parts()) to this name. /**
     * Appends <code>name</code> (all of its {@link #parts()}) to this name.
     */
    @NotNull
    Name append(Name name);

    The qualified name of this SQL identifier.
/**
     * The qualified name of this SQL identifier.
     */
    @NotNull
    String[] getName();

    Create an empty WindowDefinition from this name. 
See Also: as(WindowSpecification)/**
     * Create an empty {@link WindowDefinition} from this name.
     *
     * @see #as(WindowSpecification)
     */
    @NotNull
    @Support({ CUBRID, FIREBIRD, H2, MARIADB, MYSQL, POSTGRES, SQLITE })
    WindowDefinition as();

    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)

/**
     * Create a {@link WindowDefinition} from this name.
     * <p>
     * This creates a window definition that can be
     * <ul>
     * <li>declared in the <code>WINDOW</code> clause (see
     * {@link SelectWindowStep#window(WindowDefinition...)}</li>
     * <li>referenced from the <code>OVER</code> clause (see
     * {@link AggregateFunction#over(WindowDefinition)}</li>
     * </ul>
     */
    @NotNull
    @Support({ CUBRID, FIREBIRD, H2, MARIADB, MYSQL, POSTGRES, SQLITE })
    WindowDefinition as(WindowSpecification window);

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

Column names are implicitly inherited from the SELECT
statement.
/**
     * Specify a subselect to refer to by the <code>Name</code> to form a common
     * table expression.
     * <p>
     * Column names are implicitly inherited from the <code>SELECT</code>
     * statement.
     */
    @NotNull
    @Support({ FIREBIRD, H2, HSQLDB, MARIADB, MYSQL, POSTGRES, SQLITE })
    <R extends Record> CommonTableExpression<R> as(Select<R> select);

    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.
/**
     * Specify a materialized subselect to refer to by the <code>Name</code> to
     * form a common table expression.
     * <p>
     * This adds the PostgreSQL 12 <code>MATERIALIZED</code> hint to the common
     * table expression definition, or silently ignores it, if the hint is not
     * supported.
     * <p>
     * Column names are implicitly inherited from the <code>SELECT</code>
     * statement.
     */
    @NotNull
    @Support({ FIREBIRD, H2, HSQLDB, MARIADB, MYSQL, POSTGRES, SQLITE })
    <R extends Record> CommonTableExpression<R> asMaterialized(Select<R> select);

    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.
/**
     * Specify a non-materialized subselect to refer to by the <code>Name</code>
     * to form a common table expression.
     * <p>
     * This adds the PostgreSQL 12 <code>NOT MATERIALIZED</code> hint to the
     * common table expression definition, or silently ignores it, if the hint
     * is not supported.
     * <p>
     * Column names are implicitly inherited from the <code>SELECT</code>
     * statement.
     */
    @NotNull
    @Support({ FIREBIRD, H2, HSQLDB, MARIADB, MYSQL, POSTGRES, SQLITE })
    <R extends Record> CommonTableExpression<R> asNotMaterialized(Select<R> select);

    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.
/**
     * Add a list of fields to this name to make this name a
     * {@link DerivedColumnList}.
     * <p>
     * The <code>DerivedColumnList</code> can then be used along with a
     * subselect to form a {@link CommonTableExpression} to be used with
     * <code>WITH</code> clauses.
     */
    @NotNull
    @Support({ FIREBIRD, H2, HSQLDB, MARIADB, MYSQL, POSTGRES, SQLITE })
    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.
/**
     * Add a list of fields to this name to make this name a
     * {@link DerivedColumnList}.
     * <p>
     * The <code>DerivedColumnList</code> can then be used along with a
     * subselect to form a {@link CommonTableExpression} to be used with
     * <code>WITH</code> clauses.
     */
    @NotNull
    @Support({ FIREBIRD, H2, HSQLDB, MARIADB, MYSQL, POSTGRES, SQLITE })
    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.
 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. 
Deprecated: - 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
     * {@link DerivedColumnList}.
     * <p>
     * The <code>DerivedColumnList</code> can then be used along with a
     * subselect to form a {@link CommonTableExpression} to be used with
     * <code>WITH</code> clauses.
     * <p>
     * This works in a similar way as {@link #fields(String...)}, except
     * that all column names are produced by a function that receives the CTE's
     * {@link Select} columns and their column indexes as input.
     *
     * @deprecated - 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.
     */
    @Deprecated
    @NotNull
    @Support({ FIREBIRD, H2, HSQLDB, MYSQL, POSTGRES, SQLITE })
    DerivedColumnList fields(Function<? super Field<?>, ? extends String> fieldNameFunction);

    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. 
Deprecated: - 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
     * {@link DerivedColumnList}.
     * <p>
     * The <code>DerivedColumnList</code> can then be used along with a
     * subselect to form a {@link CommonTableExpression} to be used with
     * <code>WITH</code> clauses.
     * <p>
     * This works in a similar way as {@link #fields(String...)}, except
     * that all column names are produced by a function that receives the CTE's
     * {@link Select} columns as input.
     *
     * @deprecated - 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.
     */
    @Deprecated
    @NotNull
    @Support({ FIREBIRD, H2, HSQLDB, MYSQL, POSTGRES, SQLITE })
    DerivedColumnList fields(BiFunction<? super Field<?>, ? super Integer, ? extends String> fieldNameFunction);




    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.
/**
     * Add a list of fields to this name to make this name a
     * {@link DerivedColumnList}.
     * <p>
     * The <code>DerivedColumnList</code> can then be used along with a
     * subselect to form a {@link CommonTableExpression} to be used with
     * <code>WITH</code> clauses.
     */
    @NotNull
    @Support({ FIREBIRD, H2, HSQLDB, MARIADB, MYSQL, POSTGRES, SQLITE })
    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.
/**
     * Add a list of fields to this name to make this name a
     * {@link DerivedColumnList}.
     * <p>
     * The <code>DerivedColumnList</code> can then be used along with a
     * subselect to form a {@link CommonTableExpression} to be used with
     * <code>WITH</code> clauses.
     */
    @NotNull
    @Support({ FIREBIRD, H2, HSQLDB, MARIADB, MYSQL, POSTGRES, SQLITE })
    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.
/**
     * Add a list of fields to this name to make this name a
     * {@link DerivedColumnList}.
     * <p>
     * The <code>DerivedColumnList</code> can then be used along with a
     * subselect to form a {@link CommonTableExpression} to be used with
     * <code>WITH</code> clauses.
     */
    @NotNull
    @Support({ FIREBIRD, H2, HSQLDB, MARIADB, MYSQL, POSTGRES, SQLITE })
    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.
/**
     * Add a list of fields to this name to make this name a
     * {@link DerivedColumnList}.
     * <p>
     * The <code>DerivedColumnList</code> can then be used along with a
     * subselect to form a {@link CommonTableExpression} to be used with
     * <code>WITH</code> clauses.
     */
    @NotNull
    @Support({ FIREBIRD, H2, HSQLDB, MARIADB, MYSQL, POSTGRES, SQLITE })
    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.
/**
     * Add a list of fields to this name to make this name a
     * {@link DerivedColumnList}.
     * <p>
     * The <code>DerivedColumnList</code> can then be used along with a
     * subselect to form a {@link CommonTableExpression} to be used with
     * <code>WITH</code> clauses.
     */
    @NotNull
    @Support({ FIREBIRD, H2, HSQLDB, MARIADB, MYSQL, POSTGRES, SQLITE })
    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.
/**
     * Add a list of fields to this name to make this name a
     * {@link DerivedColumnList}.
     * <p>
     * The <code>DerivedColumnList</code> can then be used along with a
     * subselect to form a {@link CommonTableExpression} to be used with
     * <code>WITH</code> clauses.
     */
    @NotNull
    @Support({ FIREBIRD, H2, HSQLDB, MARIADB, MYSQL, POSTGRES, SQLITE })
    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.
/**
     * Add a list of fields to this name to make this name a
     * {@link DerivedColumnList}.
     * <p>
     * The <code>DerivedColumnList</code> can then be used along with a
     * subselect to form a {@link CommonTableExpression} to be used with
     * <code>WITH</code> clauses.
     */
    @NotNull
    @Support({ FIREBIRD, H2, HSQLDB, MARIADB, MYSQL, POSTGRES, SQLITE })
    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.
/**
     * Add a list of fields to this name to make this name a
     * {@link DerivedColumnList}.
     * <p>
     * The <code>DerivedColumnList</code> can then be used along with a
     * subselect to form a {@link CommonTableExpression} to be used with
     * <code>WITH</code> clauses.
     */
    @NotNull
    @Support({ FIREBIRD, H2, HSQLDB, MARIADB, MYSQL, POSTGRES, SQLITE })
    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.
/**
     * Add a list of fields to this name to make this name a
     * {@link DerivedColumnList}.
     * <p>
     * The <code>DerivedColumnList</code> can then be used along with a
     * subselect to form a {@link CommonTableExpression} to be used with
     * <code>WITH</code> clauses.
     */
    @NotNull
    @Support({ FIREBIRD, H2, HSQLDB, MARIADB, MYSQL, POSTGRES, SQLITE })
    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.
/**
     * Add a list of fields to this name to make this name a
     * {@link DerivedColumnList}.
     * <p>
     * The <code>DerivedColumnList</code> can then be used along with a
     * subselect to form a {@link CommonTableExpression} to be used with
     * <code>WITH</code> clauses.
     */
    @NotNull
    @Support({ FIREBIRD, H2, HSQLDB, MARIADB, MYSQL, POSTGRES, SQLITE })
    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.
/**
     * Add a list of fields to this name to make this name a
     * {@link DerivedColumnList}.
     * <p>
     * The <code>DerivedColumnList</code> can then be used along with a
     * subselect to form a {@link CommonTableExpression} to be used with
     * <code>WITH</code> clauses.
     */
    @NotNull
    @Support({ FIREBIRD, H2, HSQLDB, MARIADB, MYSQL, POSTGRES, SQLITE })
    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.
/**
     * Add a list of fields to this name to make this name a
     * {@link DerivedColumnList}.
     * <p>
     * The <code>DerivedColumnList</code> can then be used along with a
     * subselect to form a {@link CommonTableExpression} to be used with
     * <code>WITH</code> clauses.
     */
    @NotNull
    @Support({ FIREBIRD, H2, HSQLDB, MARIADB, MYSQL, POSTGRES, SQLITE })
    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.
/**
     * Add a list of fields to this name to make this name a
     * {@link DerivedColumnList}.
     * <p>
     * The <code>DerivedColumnList</code> can then be used along with a
     * subselect to form a {@link CommonTableExpression} to be used with
     * <code>WITH</code> clauses.
     */
    @NotNull
    @Support({ FIREBIRD, H2, HSQLDB, MARIADB, MYSQL, POSTGRES, SQLITE })
    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.
/**
     * Add a list of fields to this name to make this name a
     * {@link DerivedColumnList}.
     * <p>
     * The <code>DerivedColumnList</code> can then be used along with a
     * subselect to form a {@link CommonTableExpression} to be used with
     * <code>WITH</code> clauses.
     */
    @NotNull
    @Support({ FIREBIRD, H2, HSQLDB, MARIADB, MYSQL, POSTGRES, SQLITE })
    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.
/**
     * Add a list of fields to this name to make this name a
     * {@link DerivedColumnList}.
     * <p>
     * The <code>DerivedColumnList</code> can then be used along with a
     * subselect to form a {@link CommonTableExpression} to be used with
     * <code>WITH</code> clauses.
     */
    @NotNull
    @Support({ FIREBIRD, H2, HSQLDB, MARIADB, MYSQL, POSTGRES, SQLITE })
    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.
/**
     * Add a list of fields to this name to make this name a
     * {@link DerivedColumnList}.
     * <p>
     * The <code>DerivedColumnList</code> can then be used along with a
     * subselect to form a {@link CommonTableExpression} to be used with
     * <code>WITH</code> clauses.
     */
    @NotNull
    @Support({ FIREBIRD, H2, HSQLDB, MARIADB, MYSQL, POSTGRES, SQLITE })
    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.
/**
     * Add a list of fields to this name to make this name a
     * {@link DerivedColumnList}.
     * <p>
     * The <code>DerivedColumnList</code> can then be used along with a
     * subselect to form a {@link CommonTableExpression} to be used with
     * <code>WITH</code> clauses.
     */
    @NotNull
    @Support({ FIREBIRD, H2, HSQLDB, MARIADB, MYSQL, POSTGRES, SQLITE })
    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.
/**
     * Add a list of fields to this name to make this name a
     * {@link DerivedColumnList}.
     * <p>
     * The <code>DerivedColumnList</code> can then be used along with a
     * subselect to form a {@link CommonTableExpression} to be used with
     * <code>WITH</code> clauses.
     */
    @NotNull
    @Support({ FIREBIRD, H2, HSQLDB, MARIADB, MYSQL, POSTGRES, SQLITE })
    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.
/**
     * Add a list of fields to this name to make this name a
     * {@link DerivedColumnList}.
     * <p>
     * The <code>DerivedColumnList</code> can then be used along with a
     * subselect to form a {@link CommonTableExpression} to be used with
     * <code>WITH</code> clauses.
     */
    @NotNull
    @Support({ FIREBIRD, H2, HSQLDB, MARIADB, MYSQL, POSTGRES, SQLITE })
    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.
/**
     * Add a list of fields to this name to make this name a
     * {@link DerivedColumnList}.
     * <p>
     * The <code>DerivedColumnList</code> can then be used along with a
     * subselect to form a {@link CommonTableExpression} to be used with
     * <code>WITH</code> clauses.
     */
    @NotNull
    @Support({ FIREBIRD, H2, HSQLDB, MARIADB, MYSQL, POSTGRES, SQLITE })
    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.
/**
     * Add a list of fields to this name to make this name a
     * {@link DerivedColumnList}.
     * <p>
     * The <code>DerivedColumnList</code> can then be used along with a
     * subselect to form a {@link CommonTableExpression} to be used with
     * <code>WITH</code> clauses.
     */
    @NotNull
    @Support({ FIREBIRD, H2, HSQLDB, MARIADB, MYSQL, POSTGRES, SQLITE })
    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.
/**
     * Add a list of fields to this name to make this name a
     * {@link DerivedColumnList}.
     * <p>
     * The <code>DerivedColumnList</code> can then be used along with a
     * subselect to form a {@link CommonTableExpression} to be used with
     * <code>WITH</code> clauses.
     */
    @NotNull
    @Support({ FIREBIRD, H2, HSQLDB, MARIADB, MYSQL, POSTGRES, SQLITE })
    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.
/**
     * Add a list of fields to this name to make this name a
     * {@link DerivedColumnList}.
     * <p>
     * The <code>DerivedColumnList</code> can then be used along with a
     * subselect to form a {@link CommonTableExpression} to be used with
     * <code>WITH</code> clauses.
     */
    @NotNull
    @Support({ FIREBIRD, H2, HSQLDB, MARIADB, MYSQL, POSTGRES, SQLITE })
    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.
/**
     * Add a list of fields to this name to make this name a
     * {@link DerivedColumnList}.
     * <p>
     * The <code>DerivedColumnList</code> can then be used along with a
     * subselect to form a {@link CommonTableExpression} to be used with
     * <code>WITH</code> clauses.
     */
    @NotNull
    @Support({ FIREBIRD, H2, HSQLDB, MARIADB, MYSQL, POSTGRES, SQLITE })
    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.
/**
     * Add a list of fields to this name to make this name a
     * {@link DerivedColumnList}.
     * <p>
     * The <code>DerivedColumnList</code> can then be used along with a
     * subselect to form a {@link CommonTableExpression} to be used with
     * <code>WITH</code> clauses.
     */
    @NotNull
    @Support({ FIREBIRD, H2, HSQLDB, MARIADB, MYSQL, POSTGRES, SQLITE })
    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.
/**
     * Add a list of fields to this name to make this name a
     * {@link DerivedColumnList}.
     * <p>
     * The <code>DerivedColumnList</code> can then be used along with a
     * subselect to form a {@link CommonTableExpression} to be used with
     * <code>WITH</code> clauses.
     */
    @NotNull
    @Support({ FIREBIRD, H2, HSQLDB, MARIADB, MYSQL, POSTGRES, SQLITE })
    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.
/**
     * Add a list of fields to this name to make this name a
     * {@link DerivedColumnList}.
     * <p>
     * The <code>DerivedColumnList</code> can then be used along with a
     * subselect to form a {@link CommonTableExpression} to be used with
     * <code>WITH</code> clauses.
     */
    @NotNull
    @Support({ FIREBIRD, H2, HSQLDB, MARIADB, MYSQL, POSTGRES, SQLITE })
    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.
/**
     * Add a list of fields to this name to make this name a
     * {@link DerivedColumnList}.
     * <p>
     * The <code>DerivedColumnList</code> can then be used along with a
     * subselect to form a {@link CommonTableExpression} to be used with
     * <code>WITH</code> clauses.
     */
    @NotNull
    @Support({ FIREBIRD, H2, HSQLDB, MARIADB, MYSQL, POSTGRES, SQLITE })
    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.
/**
     * Add a list of fields to this name to make this name a
     * {@link DerivedColumnList}.
     * <p>
     * The <code>DerivedColumnList</code> can then be used along with a
     * subselect to form a {@link CommonTableExpression} to be used with
     * <code>WITH</code> clauses.
     */
    @NotNull
    @Support({ FIREBIRD, H2, HSQLDB, MARIADB, MYSQL, POSTGRES, SQLITE })
    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.
/**
     * Add a list of fields to this name to make this name a
     * {@link DerivedColumnList}.
     * <p>
     * The <code>DerivedColumnList</code> can then be used along with a
     * subselect to form a {@link CommonTableExpression} to be used with
     * <code>WITH</code> clauses.
     */
    @NotNull
    @Support({ FIREBIRD, H2, HSQLDB, MARIADB, MYSQL, POSTGRES, SQLITE })
    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.
/**
     * Add a list of fields to this name to make this name a
     * {@link DerivedColumnList}.
     * <p>
     * The <code>DerivedColumnList</code> can then be used along with a
     * subselect to form a {@link CommonTableExpression} to be used with
     * <code>WITH</code> clauses.
     */
    @NotNull
    @Support({ FIREBIRD, H2, HSQLDB, MARIADB, MYSQL, POSTGRES, SQLITE })
    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.
/**
     * Add a list of fields to this name to make this name a
     * {@link DerivedColumnList}.
     * <p>
     * The <code>DerivedColumnList</code> can then be used along with a
     * subselect to form a {@link CommonTableExpression} to be used with
     * <code>WITH</code> clauses.
     */
    @NotNull
    @Support({ FIREBIRD, H2, HSQLDB, MARIADB, MYSQL, POSTGRES, SQLITE })
    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.
/**
     * Add a list of fields to this name to make this name a
     * {@link DerivedColumnList}.
     * <p>
     * The <code>DerivedColumnList</code> can then be used along with a
     * subselect to form a {@link CommonTableExpression} to be used with
     * <code>WITH</code> clauses.
     */
    @NotNull
    @Support({ FIREBIRD, H2, HSQLDB, MARIADB, MYSQL, POSTGRES, SQLITE })
    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.
/**
     * Add a list of fields to this name to make this name a
     * {@link DerivedColumnList}.
     * <p>
     * The <code>DerivedColumnList</code> can then be used along with a
     * subselect to form a {@link CommonTableExpression} to be used with
     * <code>WITH</code> clauses.
     */
    @NotNull
    @Support({ FIREBIRD, H2, HSQLDB, MARIADB, MYSQL, POSTGRES, SQLITE })
    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.
/**
     * Add a list of fields to this name to make this name a
     * {@link DerivedColumnList}.
     * <p>
     * The <code>DerivedColumnList</code> can then be used along with a
     * subselect to form a {@link CommonTableExpression} to be used with
     * <code>WITH</code> clauses.
     */
    @NotNull
    @Support({ FIREBIRD, H2, HSQLDB, MARIADB, MYSQL, POSTGRES, SQLITE })
    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.
/**
     * Add a list of fields to this name to make this name a
     * {@link DerivedColumnList}.
     * <p>
     * The <code>DerivedColumnList</code> can then be used along with a
     * subselect to form a {@link CommonTableExpression} to be used with
     * <code>WITH</code> clauses.
     */
    @NotNull
    @Support({ FIREBIRD, H2, HSQLDB, MARIADB, MYSQL, POSTGRES, SQLITE })
    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.
/**
     * Add a list of fields to this name to make this name a
     * {@link DerivedColumnList}.
     * <p>
     * The <code>DerivedColumnList</code> can then be used along with a
     * subselect to form a {@link CommonTableExpression} to be used with
     * <code>WITH</code> clauses.
     */
    @NotNull
    @Support({ FIREBIRD, H2, HSQLDB, MARIADB, MYSQL, POSTGRES, SQLITE })
    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.
/**
     * Add a list of fields to this name to make this name a
     * {@link DerivedColumnList}.
     * <p>
     * The <code>DerivedColumnList</code> can then be used along with a
     * subselect to form a {@link CommonTableExpression} to be used with
     * <code>WITH</code> clauses.
     */
    @NotNull
    @Support({ FIREBIRD, H2, HSQLDB, MARIADB, MYSQL, POSTGRES, SQLITE })
    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.
/**
     * Add a list of fields to this name to make this name a
     * {@link DerivedColumnList}.
     * <p>
     * The <code>DerivedColumnList</code> can then be used along with a
     * subselect to form a {@link CommonTableExpression} to be used with
     * <code>WITH</code> clauses.
     */
    @NotNull
    @Support({ FIREBIRD, H2, HSQLDB, MARIADB, MYSQL, POSTGRES, SQLITE })
    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.
/**
     * Add a list of fields to this name to make this name a
     * {@link DerivedColumnList}.
     * <p>
     * The <code>DerivedColumnList</code> can then be used along with a
     * subselect to form a {@link CommonTableExpression} to be used with
     * <code>WITH</code> clauses.
     */
    @NotNull
    @Support({ FIREBIRD, H2, HSQLDB, MARIADB, MYSQL, POSTGRES, SQLITE })
    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.
/**
     * Add a list of fields to this name to make this name a
     * {@link DerivedColumnList}.
     * <p>
     * The <code>DerivedColumnList</code> can then be used along with a
     * subselect to form a {@link CommonTableExpression} to be used with
     * <code>WITH</code> clauses.
     */
    @NotNull
    @Support({ FIREBIRD, H2, HSQLDB, MARIADB, MYSQL, POSTGRES, SQLITE })
    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.
/**
     * Add a list of fields to this name to make this name a
     * {@link DerivedColumnList}.
     * <p>
     * The <code>DerivedColumnList</code> can then be used along with a
     * subselect to form a {@link CommonTableExpression} to be used with
     * <code>WITH</code> clauses.
     */
    @NotNull
    @Support({ FIREBIRD, H2, HSQLDB, MARIADB, MYSQL, POSTGRES, SQLITE })
    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.
/**
     * Add a list of fields to this name to make this name a
     * {@link DerivedColumnList}.
     * <p>
     * The <code>DerivedColumnList</code> can then be used along with a
     * subselect to form a {@link CommonTableExpression} to be used with
     * <code>WITH</code> clauses.
     */
    @NotNull
    @Support({ FIREBIRD, H2, HSQLDB, MARIADB, MYSQL, POSTGRES, SQLITE })
    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.
/**
     * Add a list of fields to this name to make this name a
     * {@link DerivedColumnList}.
     * <p>
     * The <code>DerivedColumnList</code> can then be used along with a
     * subselect to form a {@link CommonTableExpression} to be used with
     * <code>WITH</code> clauses.
     */
    @NotNull
    @Support({ FIREBIRD, H2, HSQLDB, MARIADB, MYSQL, POSTGRES, SQLITE })
    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);



    @Override
    boolean equals(Object other);

    Compare this name with another one ignoring case.
/**
     * Compare this name with another one ignoring case.
     */
    boolean equalsIgnoreCase(Name other);

    Compare two unquotedName() by their qualified string versions. 
{@inheritDoc}
/**
     * Compare two {@link #unquotedName()} by their qualified string versions.
     * <p>
     * {@inheritDoc}
     */
    @Override
    int compareTo(Name o);
}
/

org.jooq/ jooq/ 3.14.7/ org/jooq/Name.java
