Return a new query containing the elements from both operands.
Return a new query containing the elements from both operands. Duplicate elements are preserved.
Get the "raw" table row that represents the table itself, as opposed to a Path for a variable of the table's type.
Get the "raw" table row that represents the table itself, as opposed to a Path for a variable of the table's type. This method should generally not be called from user code.
The number of distinct elements of the query.
The number of distinct elements of the query.
Select all elements except the first num ones.
Select all elements except the first num ones.
Select all elements except the first num ones.
Select all elements except the first num ones.
Select all elements except the first num ones.
Select all elements except the first num ones.
Encode a reference into this Rep
Test whether this query is non-empty.
Test whether this query is non-empty.
Select all elements of this query which satisfy a predicate.
Select all elements of this query which satisfy a predicate. Unlike
withFilter, this method only allows Column-valued predicates, so it
guards against the accidental use use plain Booleans.
Build a new query by applying a function to all elements of this query and using the elements of the resulting queries.
Build a new query by applying a function to all elements of this query and using the elements of the resulting queries. This corresponds to an implicit inner join in SQL.
Partition this query into a query of pairs of a key and a nested query containing the elements for the key, according to some discriminator function.
Partition this query into a query of pairs of a key and a nested query containing the elements for the key, according to some discriminator function.
Join two collections with an inner join.
Join two collections with an inner join.
An optional join predicate can be specified later by calling on.
Join two collections.
Join two collections.
An optional join predicate can be specified later by calling on.
Join two collections with a left outer join.
Join two collections with a left outer join.
An optional join predicate can be specified later by calling on.
The total number of elements (i.
The total number of elements (i.e. rows).
Build a new query by applying a function to all elements of this query.
Build a new query by applying a function to all elements of this query.
Join two collections with a full outer join.
Join two collections with a full outer join.
An optional join predicate can be specified later by calling on.
Join two collections with a right outer join.
Join two collections with a right outer join.
An optional join predicate can be specified later by calling on.
The total number of elements (i.
The total number of elements (i.e. rows).
Sort this query according to a function which extracts the ordering criteria from the query's elements.
Sort this query according to a function which extracts the ordering criteria from the query's elements.
Sort this query according to a the ordering of its elements.
Sort this query according to a the ordering of its elements.
Select the first num elements.
Select the first num elements.
Select the first num elements.
Select the first num elements.
Select the first num elements.
Select the first num elements.
Return a new query containing the elements from both operands.
Return a new query containing the elements from both operands. Duplicate elements are eliminated from the result.
Return a new query containing the elements from both operands.
Return a new query containing the elements from both operands. Duplicate elements are preserved.
Select all elements of this query which satisfy a predicate.
Select all elements of this query which satisfy a predicate. This method
is used when desugaring for-comprehensions over queries. There is no
reason to call it directly because it is the same as filter.
Return a query formed from this query and another query by combining corresponding elements in pairs.
Return a query formed from this query and another query by combining corresponding elements in pairs.
Return a query formed from this query and another query by combining corresponding elements with the specified function.
Return a query formed from this query and another query by combining corresponding elements with the specified function.
Zip this query with its indices (starting at 0).
Zip this query with its indices (starting at 0).
(tableQuery: StringAdd).self
(tableQuery: StringFormat).self
Select all elements of this query which satisfy a predicate.
Select all elements of this query which satisfy a predicate. Unlike
withilter, this method only allows Column-valued predicates, so it
guards against the accidental use use plain Booleans.
(Since version 2.1) Use filter instead of where
(tableQuery: ArrowAssoc[TableQuery[E]]).x
(Since version 2.10.0) Use leftOfArrow instead
(tableQuery: Ensuring[TableQuery[E]]).x
(Since version 2.10.0) Use resultOfEnsuring instead
Represents a database table. Profiles add extension methods to TableQuery for operations that can be performed on tables but not on arbitrary queries, e.g. getting the table DDL.