Type Members

1.  class Aggregate[Q, R] extends DelegateQueryable[Q, R]
2.  sealed trait AscDesc extends AnyRef
3.  class Column[T] extends Expr[T]

   A variant of Expr representing a raw table column; allows assignment in updates and inserts

4.  class CompoundSelect[Q, R] extends Proxy[Q, R]

   A SQL SELECT query, with ORDER BY, LIMIT, OFFSET, or UNION clauses

5.  trait Delete[Q] extends ExecuteUpdate[Int] with Base[Q]

   A SQL DELETE query

6.  trait GetGeneratedKeys[Q, R] extends Query[Seq[R]]

   Represents an Insert query that you want to call JdbcStatement.getGeneratedKeys on to retrieve any auto-generated primary key values from the results

7.  case class GroupBy(keys: Seq[Expr[_]], select: () => Select[_, _], having: Seq[Expr[_]]) extends Product with Serializable

   Models a SQL GROUP BY clause

8.  trait Insert[V[_[_]], R] extends WithSqlExpr[V[Column]] with generated.Insert[V, R]

   A SQL INSERT query

9.  trait InsertColumns[V[_[_]], R] extends InsertBase[V[Column]] with ExecuteUpdate[Int]

   A SQL INSERT VALUES query

10.  trait InsertSelect[V[_[_]], C, R, R2] extends InsertBase[V[Column]] with ExecuteUpdate[Int]

    A SQL INSERT SELECT query

11.  trait InsertValues[V[_[_]], R] extends InsertBase[V[Column]] with ExecuteUpdate[Int]
12.  case class Join(prefix: String, from: Seq[From]) extends Product with Serializable

    Models a SQL JOIN clause

13.  trait JoinAppend[Q, Q2, QF, RF] extends AnyRef

    Typeclass to allow .join to append tuples, such that Query[(A, B)].join(Query[C]) returns a flat Query[(A, B, C)] rather than a nested Query[((A, B), B)].

    Typeclass to allow .join to append tuples, such that Query[(A, B)].join(Query[C]) returns a flat Query[(A, B, C)] rather than a nested Query[((A, B), B)]. Can't eliminate nesting in all cases, but eliminates nesting often enough to be useful

14.  trait JoinAppendLowPriority extends AnyRef
15.  trait JoinOps[C[_, _], Q, R] extends WithSqlExpr[Q]
16.  trait Joinable[Q, R] extends AnyRef

    Something that can be joined; typically a Select or a Table

17.  class LateralJoinOps[C[_, _], Q, R] extends AnyRef

    Wrapper class with extension methods to add support for JOIN LATERAL, which allow for JOIN clauses to access the results of earlier JOIN and FROM clauses.

    Wrapper class with extension methods to add support for JOIN LATERAL, which allow for JOIN clauses to access the results of earlier JOIN and FROM clauses. Only supported by Postgres and MySql

18.  sealed trait Nulls extends AnyRef
19.  class OnConflict[Q, R] extends AnyRef

    A query with a SQL ON CONFLICT clause, typically an INSERT or an UPDATE

20.  case class OrderBy(expr: Expr[_], ascDesc: Option[AscDesc], nulls: Option[Nulls]) extends Product with Serializable

    Models a SQL ORDER BY clause

21.  trait Query[R] extends Renderable

    A SQL Query, either a Query.Multiple that returns multiple rows, or a Query.Single that returns a single row

22.  trait Returning[Q, R] extends Query[Seq[R]] with DelegateQueryable[Q, Seq[R]]

    A query with a RETURNING clause

23.  trait Select[Q, R] extends Renderable with Aggregatable[Q] with Joinable[Q, R] with JoinOps[Select, Q, R] with Query[Seq[R]] with DelegateQueryable[Q, Seq[R]] with Wrapped

    A SQL SELECT query, possible with JOIN, WHERE, GROUP BY, ORDER BY, LIMIT, OFFSET clauses

    A SQL SELECT query, possible with JOIN, WHERE, GROUP BY, ORDER BY, LIMIT, OFFSET clauses

    Models the various components of a SQL SELECT:

    SELECT DISTINCT column, AGG_FUNC(column_or_expression), …
    FROM mytable
    JOIN another_table ON mytable.column = another_table.column
    WHERE constraint_expression
    GROUP BY column HAVING constraint_expression
    ORDER BY column ASC/DESC
    LIMIT count OFFSET COUNT;

    Good syntax reference:

    https://www.cockroachlabs.com/docs/stable/selection-queries#set-operations https://www.postgresql.org/docs/current/sql-select.html

24.  class SimpleSelect[Q, R] extends Select[Q, R]

    A SELECT query, with FROM/JOIN/WHERE/GROUP BY clauses, but without ORDER BY/LIMIT/TAKE/UNION clauses

25.  case class SqlWindow[T](e: Expr[T], partitionBy0: Option[Expr[_]], filter0: Option[Expr[Boolean]], orderBy: Seq[OrderBy], frameStart0: Option[SqlStr], frameEnd0: Option[SqlStr], exclusions: Option[SqlStr])(implicit dialect: DialectTypeMappers) extends Expr[T] with Product with Serializable
26.  class SubqueryRef extends From

    Models a subquery: a SELECT, VALUES, nested WITH, etc.

27.  abstract class Table[V[_[_]]] extends Base with LowPri[V]

    In-code representation of a SQL table, associated with a given case class V.

28.  trait TableMacros extends AnyRef
29.  class TableRef extends From

    Models a SQL FROM clause

30.  trait Update[Q, R] extends JoinOps[Update, Q, R] with Base[Q] with ExecuteUpdate[Int]

    A SQL UPDATE query

31.  class Values[Q, R] extends Proxy[Q, R] with DelegateQueryable[Q, Seq[R]]

    A SQL VALUES clause, used to treat a sequence of primitive Ts as a Select query.

32.  class WithCte[Q, R] extends Proxy[Q, R]

    A SQL WITH clause

33.  class WithCteRef extends From