Top Description Methods
org.jooq

public sealed Interface TableLike<R extends org.jooq.Record>

extends Fields, QueryPart
Known Direct Subinterfaces
org.jooq.Select, org.jooq.Table
Type Parameters
<R>
The record type
Static Imports
org.jooq.SQLDialect.H2, .SQLDialect.MARIADB, .SQLDialect.MYSQL, .SQLDialect.POSTGRES, .SQLDialect.SQLITE, .SQLDialect.YUGABYTEDB
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 TypeMethod and Description
public @NotNull Field<Result<R>>
asMultiset()

Deprecated as a consequence of Field being deprecated.
Turn this TableLike expression into a DSL#multiset(TableLike).
public @NotNull Field<Result<R>>
asMultiset(String alias)

Deprecated as a consequence of Field being deprecated.
Turn this TableLike expression into a DSL#multiset(TableLike).
public @NotNull Field<Result<R>>
asMultiset(Name alias)

Deprecated as a consequence of Field being deprecated.
Turn this TableLike expression into a DSL#multiset(TableLike).
public @NotNull Field<Result<R>>
asMultiset(Field<?> alias)

Deprecated as a consequence of Field being deprecated.
Turn this TableLike expression into a DSL#multiset(TableLike).
public @NotNull Table<R>
asTable()

The underlying table representation of this object.

public @NotNull Table<R>
asTable(String alias)

The underlying aliased table representation of this object.

public @NotNull Table<R>
asTable(String alias, String... fieldAliases)

The underlying aliased table representation of this object.

public @NotNull Table<R>
asTable(String alias, Collection<? extends String> fieldAliases)

The underlying aliased table representation of this object.

public @NotNull Table<R>
asTable(Name alias)

The underlying aliased table representation of this object.

public @NotNull Table<R>
asTable(Name alias, Name... fieldAliases)

The underlying aliased table representation of this object.

public @NotNull Table<R>
asTable(Name alias, Collection<? extends Name> fieldAliases)

The underlying aliased table representation of this object.

public @NotNull Table<R>
asTable(Table<?> alias)

The underlying aliased table representation of this object.

public @NotNull Table<R>
asTable(Table<?> alias, Field<?>... fieldAliases)

Deprecated as a consequence of Field being deprecated.
The underlying aliased table representation of this object.
public @NotNull Table<R>
asTable(Table<?> alias, Collection<? extends Field<?>> fieldAliases)

The underlying aliased table representation of this object.

public @NotNull Table<R>
asTable(String alias, Function<? super Field<?>, ? extends String> aliasFunction)

Deprecated for removal since 3.14. - 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.
The underlying aliased table representation of this object.
public @NotNull Table<R>
asTable(String alias, BiFunction<? super Field<?>, ? super Integer, ? extends String> aliasFunction)

Deprecated for removal since 3.14. - 3.14.0 - [#10156] - These methods will be removed without replacement from a future jOOQ.
The underlying aliased table representation of this object.
Inherited from org.jooq.Fields:
dataTypedataTypedataTypedataTypesfieldfieldfieldfieldfieldfieldfieldfieldfieldfieldfieldsfieldsfieldsfieldsfieldsfieldsRowfieldStreamindexOfindexOfindexOftypetypetypetypes
Inherited from org.jooq.QueryPart:
equalshashCodetoString

Method Detail

asMultisetback to summary
public @NotNull Field<Result<R>> asMultiset()

Deprecated

as a consequence of Field being deprecated. See corresponding docs for further information.

Turn this TableLike expression into a DSL#multiset(TableLike).

Annotations
@NotNull
@Support:H2, MARIADB, MYSQL, POSTGRES, SQLITE, YUGABYTEDB
asMultisetback to summary
public @NotNull Field<Result<R>> asMultiset(String alias)

Deprecated

as a consequence of Field being deprecated. See corresponding docs for further information.

Turn this TableLike expression into a DSL#multiset(TableLike).

Annotations
@NotNull
@Support:H2, MARIADB, MYSQL, POSTGRES, SQLITE, YUGABYTEDB
asMultisetback to summary
public @NotNull Field<Result<R>> asMultiset(Name alias)

Deprecated

as a consequence of Field being deprecated. See corresponding docs for further information.

Turn this TableLike expression into a DSL#multiset(TableLike).

Annotations
@NotNull
@Support:H2, MARIADB, MYSQL, POSTGRES, SQLITE, YUGABYTEDB
asMultisetback to summary
public @NotNull Field<Result<R>> asMultiset(Field<?> alias)

Deprecated

as a consequence of Field being deprecated. See corresponding docs for further information.

Turn this TableLike expression into a DSL#multiset(TableLike).

Annotations
@NotNull
@Support:H2, MARIADB, MYSQL, POSTGRES, SQLITE, YUGABYTEDB
asTableback to summary
public @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 …

Annotations
@NotNull
@Support
asTableback to summary
public @NotNull Table<R> asTable(String alias)

The underlying aliased table representation of this object.

Annotations
@NotNull
@Support
See Also
Table#as(String)
asTableback to summary
public @NotNull Table<R> asTable(String alias, String... fieldAliases)

The underlying aliased table representation of this object.

Annotations
@NotNull
@Support
See Also
Table#as(String, String...)
asTableback to summary
public @NotNull Table<R> asTable(String alias, Collection<? extends String> fieldAliases)

The underlying aliased table representation of this object.

Annotations
@NotNull
@Support
See Also
Table#as(String, Collection)
asTableback to summary
public @NotNull Table<R> asTable(Name alias)

The underlying aliased table representation of this object.

Annotations
@NotNull
@Support
See Also
Table#as(Name)
asTableback to summary
public @NotNull Table<R> asTable(Name alias, Name... fieldAliases)

The underlying aliased table representation of this object.

Annotations
@NotNull
@Support
See Also
Table#as(Name, Name...)
asTableback to summary
public @NotNull Table<R> asTable(Name alias, Collection<? extends Name> fieldAliases)

The underlying aliased table representation of this object.

Annotations
@NotNull
@Support
See Also
Table#as(Name, Collection)
asTableback to summary
public @NotNull Table<R> asTable(Table<?> alias)

The underlying aliased table representation of this object.

Annotations
@NotNull
@Support
See Also
Table#as(Table)
asTableback to summary
public @NotNull Table<R> asTable(Table<?> alias, Field<?>... fieldAliases)

Deprecated

as a consequence of Field being deprecated. See corresponding docs for further information.

The underlying aliased table representation of this object.

Annotations
@NotNull
@Support
See Also
Table#as(Table, Field...)
asTableback to summary
public @NotNull Table<R> asTable(Table<?> alias, Collection<? extends Field<?>> fieldAliases)

The underlying aliased table representation of this object.

Annotations
@NotNull
@Support
See Also
Table#as(Table, Collection)
asTableback to summary
public @NotNull Table<R> asTable(String alias, Function<? super Field<?>, ? extends String> aliasFunction)

Deprecated

for removal since 3.14.

- 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.

Annotations
@Deprecated
forRemoval:true
since:3.14
@NotNull
@Support
See Also
Table#as(String, Function)
asTableback to summary
public @NotNull Table<R> asTable(String alias, BiFunction<? super Field<?>, ? super Integer, ? extends String> aliasFunction)

Deprecated

for removal since 3.14.

- 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.

Annotations
@Deprecated
forRemoval:true
since:3.14
@NotNull
@Support
See Also
Table#as(String, BiFunction)