Module sea_query::query

Query statements (select, insert, update & delete).

Usage

• Query Select, see SelectStatement
• Query Insert, see InsertStatement
• Query Update, see UpdateStatement
• Query Delete, see DeleteStatement

Macros

• all
  Macro to easily create an Condition::all.
• any
  Macro to easily create an Condition::any.

Structs

• CaseStatement
• CommonTableExpression
  A table definition inside a WITH clause (WithClause).
• Condition
  Represents the value of an Condition::any or Condition::all: a set of disjunctive or conjunctive conditions.
• ConditionHolder
• Cycle
  For recursive WithQuery WithClauses the CYCLE sql clause can be specified to avoid creating an infinite traversals that loops on graph cycles indefinitely. You specify an expression that identifies a node in the graph and that will be used to determine during the iteration of the execution of the query when appending of new values whether the new values are distinct new nodes or are already visited and therefore they should be added again into the result.
• DeleteStatement
  Delete existing rows from the table
• FrameClause
  Frame clause
• InsertStatement
  Insert any new rows into an existing table
• JoinExpr
  Join expression used in select statement
• LockClause
• OnConflict
• Query
  Shorthand for constructing any table query
• Returning
  Shorthand for constructing ReturningClause
• Search
  For recursive WithQuery WithClauses the traversing order can be specified in some databases that support this functionality.
• SelectExpr
  Select expression used in select statement
• SelectStatement
  Select rows from an existing table
• UpdateStatement
  Update existing rows in the table
• WindowStatement
  Window expression
• WithClause
  A WITH clause can contain one or multiple common table expressions (CommonTableExpression).
• WithQuery
  A WITH query. A simple SQL query that has a WITH clause (WithClause).

Enums

• ConditionExpression
  Represents anything that can be passed to an Condition::any or Condition::all’s Condition::add method.
• ConditionHolderContents
• ConditionType
• Frame
  frame_start or frame_end clause
• FrameType
  Frame type
• LockBehavior
  List of lock behavior can be used in select statement
• LockType
  List of lock types that can be used in select statement
• OnConflictAction
  Represents ON CONFLICT (upsert) actions
• OnConflictTarget
  Represents ON CONFLICT (upsert) targets
• OnConflictUpdate
  Represents strategies to update column in ON CONFLICT (upsert) actions
• QueryStatement
  All available types of table query
• ReturningClause
  RETURNING clause.
• SearchOrder
  For recursive WithQuery WithClauses the traversing order can be specified in some databases that support this functionality.
• SelectDistinct
  List of distinct keywords that can be used in select statement
• SubQueryStatement
• UnionType
  List of union types that can be used in union clause
• WindowSelectType
  Window type in SelectExpr

Traits

• ConditionalStatement
• IntoCondition
• OrderedStatement
• OverStatement
• QueryStatementBuilder
• QueryStatementWriter

Type Aliases

• Cond