Module sql_parser::ast [−][src]
Expand description
SQL Abstract Syntax Tree (AST) types
Modules
This module houses the definitions of the structs and enums that are formally part of the AST.
Transformation of an owned AST.
Traversal of an immutable AST.
Traversal of a mutable AST.
Structs
ALTER INDEX ... {RESET, SET}
ALTER <OBJECT> ... RENAME TO
SQL assignment foo = expr
as used in SQLUpdate
CLOSE ...
SQL column definition
An optionally-named ColumnOption
: [ CONSTRAINT <name> ] <column-option>
.
COMMIT [ TRANSACTION | WORK ] [ AND [ NO ] CHAIN ]
COPY
CREATE DATABASE
CREATE INDEX
A CREATE ROLE
statement.
CREATE SCHEMA
CREATE SINK
CREATE SOURCE
CREATE TABLE
CREATE TYPE ..
CREATE VIEW
CREATE VIEWS
A single CTE (used after WITH
): alias [(col1, col2, ...)] AS ( query )
The names in the column list before AS
, when specified, replace the names
of the columns returned by the query. The parser does not validate that the
number of columns in the query matches the number of columns in the query.
DEALLOCATE ...
DECLARE ...
DELETE
EXECUTE ...
EXPLAIN ...
FETCH ...
A function call
An identifier.
INSERT
An intermediate value for Intervals, which tracks all data from the user, as well as the computed ParsedDateTime.
SQL ORDER BY expression
Information about upstream Postgres tables used for replication sources
PREPARE ...
The most complete variant of a SELECT
query expression, optionally
including WITH
, UNION
/ other set operations, and ORDER BY
.
ROLLBACK [ TRANSACTION | WORK ] [ AND [ NO ] CHAIN ]
A restricted variant of SELECT
(without CTEs/ORDER BY
), which may
appear either as the only body item of an SQLQuery
, or as an operand
to a set operation like UNION
.
SELECT
SET TRANSACTION ...
SET <variable>
SHOW COLUMNS
SHOW CREATE INDEX <index>
SHOW CREATE SINK <sink>
SHOW CREATE SOURCE <source>
SHOW CREATE TABLE <table>
SHOW CREATE VIEW <view>
SHOW DATABASES
SHOW INDEX|INDEXES|KEYS
SHOW <object>S
SHOW <variable>
{ BEGIN [ TRANSACTION | WORK ] | START TRANSACTION } ...
TAIL
A name of a table, view, custom type, etc., possibly multi-part, i.e. db.schema.obj
UPDATE
Specifies the data processed by a window function, e.g.
RANGE UNBOUNDED PRECEDING
or ROWS BETWEEN 5 PRECEDING AND CURRENT ROW
.
A window specification (i.e. OVER (PARTITION BY .. ORDER BY .. etc.)
)
Enums
ColumnOption
s are modifiers that follow a column definition in a CREATE TABLE
statement.
Options that can be attached to CreateRoleStatement
.
CREATE TYPE .. AS <TYPE>
SQL data types
Specifies what Statement::Explain is actually explaining
An SQL expression of any type.
Arguments for a function call.
A key constraint, specified in a CREATE SOURCE
.
The key sources specified in the S3 source’s DISCOVER OBJECTS
clause.
One item of the comma-separated list following SELECT
A node in a tree, representing a “query body” expression, roughly:
SELECT ... [ {UNION|EXCEPT|INTERSECT} SELECT ...]
A top-level statement (SELECT, INSERT, CREATE, etc.)
A table-level constraint, specified in a CREATE TABLE
or an
ALTER TABLE ADD <constraint>
statement.
A table name or a parenthesized subquery with an optional alias
Primitive SQL values.
Specifies WindowFrame’s start_bound
and end_bound