Module org.jooq
Package org.jooq

Interface TableLike<R extends Record>

Type Parameters:
R - The record type
All Superinterfaces:
Fields, QueryPart, Serializable
All Known Subinterfaces:
CommonTableExpression<R>, JSONTableColumnPathStep, JSONTableColumnsStep, Select<R>, SelectConditionStep<R>, SelectConnectByAfterStartWithConditionStep<R>, SelectConnectByConditionStep<R>, SelectConnectByStep<R>, SelectCorrelatedSubqueryStep<R>, SelectDistinctOnStep<R>, SelectFinalStep<R>, SelectForJSONCommonDirectivesStep<R>, SelectForStep<R>, SelectForUpdateOfStep<R>, SelectForUpdateStep<R>, SelectForUpdateWaitStep<R>, SelectForXMLCommonDirectivesStep<R>, SelectForXMLPathDirectivesStep<R>, SelectForXMLRawDirectivesStep<R>, SelectFromStep<R>, SelectGroupByStep<R>, SelectHavingConditionStep<R>, SelectHavingStep<R>, SelectIntoStep<R>, SelectJoinStep<R>, SelectLimitAfterOffsetStep<R>, SelectLimitPercentAfterOffsetStep<R>, SelectLimitPercentStep<R>, SelectLimitStep<R>, SelectOffsetStep<R>, SelectOnConditionStep<R>, SelectOptionalOnStep<R>, SelectOptionStep<R>, SelectOrderByStep<R>, SelectQualifyConditionStep<R>, SelectQualifyStep<R>, SelectQuery<R>, SelectSeekLimitStep<R>, SelectSeekStep1<R,​T1>, SelectSeekStep10<R,​T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10>, SelectSeekStep11<R,​T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11>, SelectSeekStep12<R,​T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12>, SelectSeekStep13<R,​T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13>, SelectSeekStep14<R,​T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13,​T14>, SelectSeekStep15<R,​T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13,​T14,​T15>, SelectSeekStep16<R,​T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13,​T14,​T15,​T16>, SelectSeekStep17<R,​T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13,​T14,​T15,​T16,​T17>, SelectSeekStep18<R,​T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13,​T14,​T15,​T16,​T17,​T18>, SelectSeekStep19<R,​T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13,​T14,​T15,​T16,​T17,​T18,​T19>, SelectSeekStep2<R,​T1,​T2>, SelectSeekStep20<R,​T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13,​T14,​T15,​T16,​T17,​T18,​T19,​T20>, SelectSeekStep21<R,​T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13,​T14,​T15,​T16,​T17,​T18,​T19,​T20,​T21>, SelectSeekStep22<R,​T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13,​T14,​T15,​T16,​T17,​T18,​T19,​T20,​T21,​T22>, SelectSeekStep3<R,​T1,​T2,​T3>, SelectSeekStep4<R,​T1,​T2,​T3,​T4>, SelectSeekStep5<R,​T1,​T2,​T3,​T4,​T5>, SelectSeekStep6<R,​T1,​T2,​T3,​T4,​T5,​T6>, SelectSeekStep7<R,​T1,​T2,​T3,​T4,​T5,​T6,​T7>, SelectSeekStep8<R,​T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8>, SelectSeekStep9<R,​T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9>, SelectSeekStepN<R>, SelectSelectStep<R>, SelectStartWithStep<R>, SelectUnionStep<R>, SelectWhereStep<R>, SelectWindowStep<R>, SelectWithTiesAfterOffsetStep<R>, SelectWithTiesStep<R>, Table<R>, TableOnConditionStep<R>, TableOptionalOnStep<R>, XMLTableColumnPathStep, XMLTableColumnsStep
All Known Implementing Classes:
CustomTable, TableImpl

public interface TableLike<R extends Record> extends Fields, QueryPart
An object that can behave like a table (a table-like object).

Instances of this type cannot be created directly, only of its subtypes.

Author:
Lukas Eder
  • Method Details

    • asTable

      @NotNull @Support @NotNull Table<R> asTable()
      The underlying table representation of this object.

      This method is useful for things like SELECT * FROM (SELECT * FROM x WHERE x.a = '1') WHERE ...

    • asTable

      @NotNull @Support @NotNull Table<R> asTable(String alias)
      The underlying aliased table representation of this object.
      See Also:
      Table.as(String)
    • asTable

      @NotNull @Support @NotNull Table<R> asTable(String alias, String... fieldAliases)
      The underlying aliased table representation of this object.
      See Also:
      Table.as(String, String...)
    • asTable

      @NotNull @Support @NotNull Table<R> asTable(Name alias)
      The underlying aliased table representation of this object.
      See Also:
      Table.as(Name)
    • asTable

      @NotNull @Support @NotNull Table<R> asTable(Name alias, Name... fieldAliases)
      The underlying aliased table representation of this object.
      See Also:
      Table.as(String, String...)
    • asTable

      @NotNull @Support @NotNull Table<R> asTable(Table<?> alias)
      The underlying aliased table representation of this object.
      See Also:
      Table.as(Name)
    • asTable

      @NotNull @Support @NotNull Table<R> asTable(Table<?> alias, Field<?>... fieldAliases)
      The underlying aliased table representation of this object.
      See Also:
      Table.as(String, String...)
    • asTable

      @Deprecated(forRemoval=true, since="3.14") @NotNull @Support @NotNull Table<R> asTable(String alias, Function<? super Field<?>,​? extends String> aliasFunction)
      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.
      The underlying aliased table representation of this object.
      See Also:
      Table.as(String, Function)
    • asTable

      @Deprecated(forRemoval=true, since="3.14") @NotNull @Support @NotNull Table<R> asTable(String alias, BiFunction<? super Field<?>,​? super Integer,​? extends String> aliasFunction)
      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.
      The underlying aliased table representation of this object.
      See Also:
      Table.as(String, BiFunction)