Expand description
SQL Abstract Syntax Tree (AST) types
Structs§
- Alter
Table - ALTER TABLE
- Analyze
- Assert
ASSERT <condition> [AS <message>]- Assignment
- SQL assignment
foo = expras used in SQLUpdate - Between
<expr> [ NOT ] BETWEEN <low> AND <high>- Binary
Op - Binary operation e.g.
1 + 1orfoo > bar - Case
CASE [<operand>] WHEN <condition> THEN <result> ... [ELSE <result>] END- Cast
- CAST an expression to a different data type e.g.
CAST(foo AS VARCHAR(123)) - Check
[ CONSTRAINT <name> ] CHECK (<expr>)- Collate
expr COLLATE collation- Column
Def - SQL column definition
- Column
Option Def - An optionally-named
ColumnOption:[ CONSTRAINT <name> ] <column-option>. - Commit
COMMIT [ TRANSACTION | WORK ] [ AND [ NO ] CHAIN ]- Copy
- Create
Database - CREATE DATABASE
- Create
Index - CREATE INDEX
- Create
Schema - CREATE SCHEMA
- Create
Table - CREATE TABLE
- Create
View - CREATE VIEW
- Create
Virtual Table - SQLite’s
CREATE VIRTUAL TABLE .. USING <module_name> (<module_args>) - Cte
- A single CTE (used after
WITH):alias [(col1, col2, ...)] AS ( query )The names in the column list beforeAS, 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
DEALLOCATE [ PREPARE ] { name | ALL }- Delete
- DELETE
- Directory
- Drop
- DROP
- Execute
EXECUTE name [ ( parameter [, ...] ) ]- Explain
- EXPLAIN
- Extract
- EXTRACT(DateTimeField FROM
) - Fetch
- Foreign
Key - A referential integrity constraint (
[ CONSTRAINT <name> ] FOREIGN KEY (<columns>) REFERENCES <foreign_table> (<referred_columns>) { [ON DELETE <referential_action>] [ON UPDATE <referential_action>] | [ON UPDATE <referential_action>] [ON DELETE <referential_action>] }). - Function
- A function call
- Hive
Format - Ident
- An identifier, decomposed into its value or character data and the quote style.
- InList
[ NOT ] IN (val1, val2, ...)- InSubquery
[ NOT ] IN (SELECT ...)- Insert
- Join
- Lateral
View - A hive LATERAL VIEW with potential column aliases
- ListAgg
- A
LISTAGGinvocationLISTAGG( [ DISTINCT ] <expr>[, <separator> ] [ON OVERFLOW <on_overflow>] ) ) [ WITHIN GROUP (ORDER BY <within_group1>[, ...] ) ] - MapAccess
- Msck
- Msck (Hive)
- Object
Name - A name of a table, view, custom type, etc., possibly multi-part, i.e. db.schema.obj
- Offset
- Order
ByExpr - An
ORDER BYexpression - Prepare
PREPARE name [ ( data_type [, ...] ) ] AS statement- Query
- The most complete variant of a
SELECTquery expression, optionally includingWITH,UNION/ other set operations, andORDER BY. - Rollback
ROLLBACK [ TRANSACTION | WORK ] [ AND [ NO ] CHAIN ]- Select
- A restricted variant of
SELECT(without CTEs/ORDER BY), which may appear either as the only body item of anSQLQuery, or as an operand to a set operation likeUNION. - SetTransaction
SET TRANSACTION ...- SetVariable
- SET
- Show
Columns - SHOW COLUMNS
- Show
Create - SHOW CREATE TABLE
- Show
Variable - SHOW
- SqlOption
- Start
Transaction { BEGIN [ TRANSACTION | WORK ] | START TRANSACTION } ...- Substring
- SUBSTRING(
[FROM ] [FOR ]) - Table
Alias - Table
With Joins - Top
- Trim
- TRIM([BOTH | LEADING | TRAILING]
[FROM ])
Or
TRIM() - Truncate
- Truncate (Hive)
- TryCast
- TRY_CAST an expression to a different data type e.g.
TRY_CAST(foo AS VARCHAR(123)) - Typed
String - A constant of form
<data_type> 'value'. This can represent ANSI SQLDATE,TIME, andTIMESTAMPliterals (such asDATE '2020-01-01'), as well as constants of other types (a non-standard PostgreSQL extension). - UnaryOp
- Unary operation e.g.
NOT foo - Unique
[ CONSTRAINT <name> ] { PRIMARY KEY | UNIQUE } (<columns>)- Update
- UPDATE
- Values
- Window
Frame - Specifies the data processed by a window function, e.g.
RANGE UNBOUNDED PRECEDINGorROWS BETWEEN 5 PRECEDING AND CURRENT ROW. - Window
Spec - A window specification (i.e.
OVER (PARTITION BY .. ORDER BY .. etc.)) - With
Enums§
- AddDrop
Sync - Alter
Table Operation - An
ALTER TABLE(Statement::AlterTable) operation - Binary
Operator - Binary operators
- Column
Option ColumnOptions are modifiers that follow a column definition in aCREATE TABLEstatement.- Data
Type - SQL data types
- Date
Time Field - Expr
- An SQL expression of any type.
- File
Format - External table’s available file format
- Function
Arg - Hive
Distribution Style - HiveIO
Format - Hive
RowFormat - Join
Constraint - Join
Operator - List
AggOn Overflow - The
ON OVERFLOWclause of a LISTAGG invocation - Object
Type - Offset
Rows - Stores the keyword after
OFFSET <number> - Referential
Action <referential_action> = { RESTRICT | CASCADE | SET NULL | NO ACTION | SET DEFAULT }- Select
Item - One item of the comma-separated list following
SELECT - SetExpr
- A node in a tree, representing a “query body” expression, roughly:
SELECT ... [ {UNION|EXCEPT|INTERSECT} SELECT ...] - SetOperator
- SetVariable
Value - Show
Create Object - Show
Statement Filter - Sqlite
OnConflict - Sqlite specific syntax
- Statement
- A top-level statement (SELECT, INSERT, CREATE, etc.)
- Table
Constraint - A table-level constraint, specified in a
CREATE TABLEor anALTER TABLE ADD <constraint>statement. - Table
Factor - A table name or a parenthesized subquery with an optional alias
- Transaction
Access Mode - Transaction
Isolation Level - Transaction
Mode - Trim
Where Field - Unary
Operator - Unary operators
- Value
- Primitive SQL values such as number and string
- Window
Frame Bound - Specifies WindowFrame’s
start_boundandend_bound - Window
Frame Units