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
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
Insert any new rows into an existing table
Join expression used in select statement
Shorthand for constructing any table query
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
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.
List of lock types that can be used in select statement
All available types of table query
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