Module sea_query::query

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

CommonTableExpression

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.

ConditionHolder

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

Frame clause

InsertStatement

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

SelectStatement

Select rows from an existing table

UpdateStatement

Update existing rows in the table

WindowStatement

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

ConditionExpression

Represents anything that can be passed to an Condition::any or Condition::all’s Condition::add method.

ConditionHolderContents

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

OnConflictAction

Represents ON CONFLICT (upsert) actions

OnConflictTarget

Represents ON CONFLICT (upsert) targets

All available types of table query

ReturningClause

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

SubQueryStatement

List of union types that can be used in union clause

WindowSelectType

Window type in SelectExpr

Traits

ConditionalStatement

OrderedStatement

QueryStatementBuilder

QueryStatementWriter

Type Definitions