Expand description
Query statements (select, insert, update & delete).
Usage
- Query Select, see
SelectStatement - Query Insert, see
InsertStatement - Query Update, see
UpdateStatement - Query Delete, see
DeleteStatement
Macros
Macro to easily create an Condition::all.
Macro to easily create an Condition::any.
Structs
A table definition inside a WITH clause (WithClause).
Represents the value of an Condition::any or Condition::all: a set of disjunctive or conjunctive conditions.
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.
Delete existing rows from the table
Frame clause
Insert any new rows into an existing table
Join expression used in select statement
Shorthand for constructing any table query
Shorthand for constructing ReturningClause
For recursive WithQuery WithClauses the traversing order can be specified in some databases that support this functionality.
Select expression used in select statement
Select rows from an existing table
Update existing rows in the table
Window expression
A WITH clause can contain one or multiple common table expressions (CommonTableExpression).
A WITH query. A simple SQL query that has a WITH clause (WithClause).
Enums
Represents anything that can be passed to an Condition::any or Condition::all’s Condition::add method.
frame_start or frame_end clause
Frame type
List of lock behavior can be used in select statement
List of lock types that can be used in select statement
Represents ON CONFLICT (upsert) actions
Represents ON CONFLICT (upsert) targets
All available types of table query
RETURNING clause.
For recursive WithQuery WithClauses the traversing order can be specified in some databases that support this functionality.
List of distinct keywords that can be used in select statement
List of union types that can be used in union clause
Window type in SelectExpr