Values

Performs one or more aggregates in a single Select

Combined with sortBy to make the sort order ascending, translates into SQL ASC

Returns whether or not the Select on the left contains the other value on the right

Performs a CROSS JOIN, which is an INNER JOIN but without the ON clause

Version of crossJoin meant for usage in for-comprehensions

Combined with sortBy to make the sort order descending, translates into SQL DESC

Causes this Select to ignore duplicate rows, translates into SQL SELECT DISTINCT

Drops the first n rows from this Select. Like when used in Scala collections, if called multiple times the dropped rows add up

Subtracts the other from this Select, returning only rows present this but absent in other, and removing duplicates. Translates into SQL EXCEPT

Filters this Select with the given predicate, translates into a SQL WHERE clause

Filters this Select with the given predicate, if cond evaluates to true

Filters this Select with the given predicate consuming provided option as a part of predicate's input, if this option is Some[T]

Performs an implicit JOIN between this Select and the one returned by the callback function f

Translates into a SQL GROUP BY, takes a function specifying the group-key and a function specifying the group-aggregate.

Shorthand for .take(1).single:

1. If the query returns a single row, this returns it as a single value of type R
2. If the query returns multiple rows, returns the first as a single value of type R and discards the rest
3. If the query returns zero rows, throws an exception.

Intersects the result rows of this Select with another, preserving only rows present in both this and the other and removing duplicates. Translates into SQL INTERSECT

Returns whether or not the Select on the left is empty with zero elements

Performs a JOIN/INNER JOIN on the given other, typically a Table or Select.

Version of join meant for usage in for-comprehensions

Performs a LEFT JOIN on the given other, typically a Table or Select.

Version of leftJoin meant for usage in for-comprehensions

Transforms the return value of this Select with the given function

Performs a .map which additionally provides a Aggregatable.Proxy that allows you to perform aggregate functions.

Returns whether or not the Select on the left is nonempty with one or more elements

Combined with sortBy to configure handling of nulls, translates into SQL NULLS FIRST

Combined with sortBy to configure handling of nulls, translates into SQL NULLS LAST

Performs a OUTER JOIN on the given other, typically a Table or Select.

Performs a RIGHT JOIN on the given other, typically a Table or Select.

Asserts that this query returns exactly one row, and returns a single value of type R rather than a Seq[R]. Throws an exception if zero or multiple rows are returned.

Sorts this Select via the given expression. Translates into a SQL ORDER BY clause. Can be called more than once to sort on multiple columns, with the last call to sortBy taking priority. Can be followed by asc, desc, nullsFirst or nullsLast to configure the sort order

Forces this Select to be treated as a subquery that any further operations will operate on, rather than having some operations flattened out into clauses in this Select

Only returns the first n rows from this Select. Like when used in Scala collections, if called multiple times only the smallest value of n takes effect

Converts this Select into an Expr, assuming it returns a single row and a single column. Note that if this returns multiple rows, behavior is database-specific, with some like Sqlite simply taking the first row while others like Postgres/MySql throwing exceptions

Concatenates the result rows of this Select with another and removes duplicate rows; translates into SQL UNION

Concatenates the result rows of this Select with another; translates into SQL UNION ALL

Alias for filter