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.  case class GroupBy(key: Expr[_], select: () => Select[_, _], having: Seq[Expr[_]]) extends Product with Serializable

   Models a SQL GROUP BY clause

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

   A SQL INSERT query

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

   A SQL INSERT VALUES query

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

   A SQL INSERT SELECT query

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

    Models a SQL JOIN clause

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

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

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

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

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

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

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

    Models a SQL ORDER BY clause

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

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

    A query with a RETURNING clause

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

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

24.  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
25.  class SubqueryRef extends From

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

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

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

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

    Models a SQL FROM clause

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

    A SQL UPDATE query

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

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

    A SQL WITH clause

32.  class WithCteRef extends From