- Type Parameters:
R
- The record type
- All Superinterfaces:
Fields
,QueryPart
,Serializable
- All Known Subinterfaces:
CommonTableExpression<R>
,JSONTableColumnPathStep
,JSONTableColumnsStep
,Path<R>
,QOM.CrossApply<R>
,QOM.CrossJoin<R>
,QOM.DataChangeDeltaTable<R>
,QOM.DerivedTable<R>
,QOM.Dual
,QOM.FullJoin<R>
,QOM.GenerateSeries<T>
,QOM.HintedTable<R>
,QOM.Join<R>
,QOM.JoinTable<R,
,J> QOM.Lateral<R>
,QOM.LeftAntiJoin<R>
,QOM.LeftJoin<R>
,QOM.LeftSemiJoin<R>
,QOM.LinkedTable<R>
,QOM.NaturalFullJoin<R>
,QOM.NaturalJoin<R>
,QOM.NaturalLeftJoin<R>
,QOM.NaturalRightJoin<R>
,QOM.OuterApply<R>
,QOM.QualifiedJoin<R,
,J> QOM.RightJoin<R>
,QOM.RowsFrom
,QOM.StraightJoin<R>
,QOM.TableAlias<R>
,QOM.Values<R>
,QOM.WithOrdinalityTable<R>
,QOM.WithTable<R>
,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 sealed interface TableLike<R extends Record>
extends Fields, QueryPart
permits Select<R>, Table<R>, Path<R>
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 Summary
Modifier and TypeMethodDescriptionTurn thisTableLike
expression into aDSL.multiset(TableLike)
.asMultiset
(String alias) Turn thisTableLike
expression into aDSL.multiset(TableLike)
.asMultiset
(Field<?> alias) Turn thisTableLike
expression into aDSL.multiset(TableLike)
.asMultiset
(Name alias) Turn thisTableLike
expression into aDSL.multiset(TableLike)
.asTable()
The underlying table representation of this object.The underlying aliased table representation of this object.The underlying aliased table representation of this object.asTable
(String alias, Collection<? extends String> fieldAliases) The underlying aliased table representation of this object.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.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.The underlying aliased table representation of this object.asTable
(Name alias, Collection<? extends Name> fieldAliases) The underlying aliased table representation of this object.The underlying aliased table representation of this object.The underlying aliased table representation of this object.asTable
(Table<?> alias, Collection<? extends Field<?>> fieldAliases) The underlying aliased table representation of this object.The underlying aliased table representation of this object.
-
Method Details
-
asMultiset
@NotNull @Support({AURORA_POSTGRES,COCKROACHDB,DB2,H2,INFORMIX,MARIADB_10_2,MYSQL_5_7,ORACLE,POSTGRES,SQLITE,SQLSERVER,TERADATA,YUGABYTEDB}) @NotNull Field<Result<R>> asMultiset()Turn thisTableLike
expression into aDSL.multiset(TableLike)
. -
asMultiset
@NotNull @Support({AURORA_POSTGRES,COCKROACHDB,DB2,H2,INFORMIX,MARIADB_10_2,MYSQL_5_7,ORACLE,POSTGRES,SQLITE,SQLSERVER,TERADATA,YUGABYTEDB}) @NotNull Field<Result<R>> asMultiset(String alias) Turn thisTableLike
expression into aDSL.multiset(TableLike)
. -
asMultiset
@NotNull @Support({AURORA_POSTGRES,COCKROACHDB,DB2,H2,INFORMIX,MARIADB_10_2,MYSQL_5_7,ORACLE,POSTGRES,SQLITE,SQLSERVER,TERADATA,YUGABYTEDB}) @NotNull Field<Result<R>> asMultiset(Name alias) Turn thisTableLike
expression into aDSL.multiset(TableLike)
. -
asMultiset
@NotNull @Support({AURORA_POSTGRES,COCKROACHDB,DB2,H2,INFORMIX,MARIADB_10_2,MYSQL_5_7,ORACLE,POSTGRES,SQLITE,SQLSERVER,TERADATA,YUGABYTEDB}) @NotNull Field<Result<R>> asMultiset(Field<?> alias) Turn thisTableLike
expression into aDSL.multiset(TableLike)
. -
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
The underlying aliased table representation of this object.- See Also:
-
asTable
The underlying aliased table representation of this object.- See Also:
-
asTable
@NotNull @Support @NotNull Table<R> asTable(String alias, Collection<? extends String> fieldAliases) The underlying aliased table representation of this object.- See Also:
-
asTable
The underlying aliased table representation of this object.- See Also:
-
asTable
The underlying aliased table representation of this object.- See Also:
-
asTable
The underlying aliased table representation of this object.- See Also:
-
asTable
The underlying aliased table representation of this object.- See Also:
-
asTable
The underlying aliased table representation of this object.- See Also:
-
asTable
@NotNull @Support @NotNull Table<R> asTable(Table<?> alias, Collection<? extends Field<?>> fieldAliases) The underlying aliased table representation of this object.- See Also:
-
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:
-
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:
-