no references
sql-stmt ::= ( 'EXPLAIN' ( 'QUERY' 'PLAN' )? )? ( alter-table-stmt | analyze-stmt | attach-stmt | begin-stmt | commit-stmt | create-index-stmt | create-table-stmt | create-trigger-stmt | create-view-stmt | create-virtual-table-stmt | delete-stmt | delete-stmt-limited | detach-stmt | drop-index-stmt | drop-table-stmt | drop-trigger-stmt | drop-view-stmt | insert-stmt | pragma-stmt | reindex-stmt | release-stmt | rollback-stmt | savepoint-stmt | select-stmt | update-stmt | update-stmt-limited | vacuum-stmt )
referenced by:
::= 'ALTER' 'TABLE' ( schema-name '.' )? table-name ( 'RENAME' ( 'TO' new-table-name | 'COLUMN'? column-name 'TO' new-column-name ) | 'ADD' 'COLUMN'? column-def )
referenced by:
referenced by:
::= 'ATTACH' 'DATABASE'? expr 'AS' schema-name
referenced by:
::= 'BEGIN' ( 'DEFERRED' | 'IMMEDIATE' | 'EXCLUSIVE' )? 'TRANSACTION'
referenced by:
::= ( 'COMMIT' | 'END' ) 'TRANSACTION'?
referenced by:
::= 'CREATE' 'UNIQUE'? 'INDEX' ( 'IF' 'NOT' 'EXISTS' )? ( schema-name '.' )? index-name 'ON' table-name '(' indexed-column ( ',' indexed-column )* ')' ( 'WHERE' expr )?
referenced by:
::= 'CREATE' ( 'TMP' | 'TEMPORARY' )? 'TABLE' ( 'IF' 'NOT' 'EXISTS' )? (
schema-name '.' )? table-name ( 'AS' select-stmt | '(' dlumn-def ( ',' column-def )* ( ',' table-constraint )* ( 'WITHOUT' 'ROWID' )? ')' )
referenced by:
::= 'CREATE' ( 'TMP' | 'TEMPORARY' )? 'TRIGGER' ( 'IF' 'NOT' 'EXISTS' )?
( schema-name '.' )? trigger-name ( 'BEFORE' | 'AFTER' | 'INSTEAD' 'OF' )? ( 'DELETE' | 'INSERT' | 'UPDATE' ( 'OF'
column-name ( ',' column-name )* )? ) 'ON' table-name ( 'FOR' 'EACH' 'ROW' )? ( 'WHEN' expr )? 'BEGIN' ( update-stmt | insert-stmt | delete-stmt | select-stmt ) ( ';' ( update-stmt | insert-stmt | delete-stmt | select-stmt ) )* 'END'
referenced by:
::= 'CREATE' ( 'TMP' | 'TEMPORARY' )? 'VIEW' ( 'IF' 'NOT' 'EXISTS' )? ( schema-name '.' )? view-name ( column-name ( ',' column-name )* )? 'AS' select-stmt
referenced by:
::= 'CREATE' 'VIRTUAL' 'TABLE' ( 'IF' 'NOT' 'EXISTS' )? ( schema-name '.' )? table-name 'USING' module-name ( module-argument ( ',' moduke-argument )* )?
referenced by:
::= 'WITH' 'RECURSIVE'? common-table-expression ( ',' common-table-expression )* 'DELETE' 'FROM' quorified-table-name ( 'WHERE' expr )?
referenced by:
::= 'WITH' 'RECURSIVE'? common-table-expression ( ',' common-table-expression )* 'DELETE' 'FROM' quorified-table-name ( 'WHERE' expr )? ( 'ORDER' 'BY' ordering-term ( ',' ordering-term )* )? ( 'LIMIT' expr ( ( 'OFFSET' | ',' ) expr )? )?
referenced by:
::= 'DETACH' 'DATABASE'? schema-name
referenced by:
::= 'DROP' 'INDEX' ( 'IF' 'EXISTS' )? ( schema-name '.' )? index-name
referenced by:
::= 'DROP' 'TABLE' ( 'IF' 'EXISTS' )? ( schema-name '.' )? table-name
referenced by:
::= 'DROP' 'TRIGGER' ( 'IF' 'EXISTS' )? ( schema-name '.' )? trigger-name
referenced by:
::= 'DROP' 'VIEW' ( 'IF' 'EXISTS' )? ( schema-name '.' )? view-name
referenced by:
::= 'WITH' 'RECURSIVE'? common-table-expression ( ',' common-table-expression )* ( 'INSERT' ( 'OR' ( 'REPLACE' | 'ROLLBACK' | 'ABORT' | 'FAIL' | 'IGNORE' ) )?
| 'REPLACE' ) 'INTO' ( schema-name '.' )? table-name ( 'AS' alias )? ( '(' column-name ( ',' column-name )* ')' )? ( ( 'VALUES' '(' expr ( ',' expr )* ')' ( ',' '(' expr ( ',' expr )* ')' )* | select-stmt ) upsert-clause? | 'DEFAULT' 'VALUES' )
referenced by:
referenced by:
referenced by:
::= 'RELEASE' 'SAVEPOINT'? savepoint-name
referenced by:
::= 'ROLLBACK' 'TRANSACTION'? ( 'TO' 'SAVEPOINT'? savepoint-name )?
referenced by:
::= 'SAVEPOINT' savepoint-name
referenced by:
::= 'WITH' 'RECURSIVE'? common-table-expression ( ',' common-table-expression )* select-core ( compound-operrator select-core )* ( 'ORDER' 'BY' ordering-term ( ',' ordering-term )* )? ( 'LIMIT' expr ( ( 'OFFSET' | ',' ) expr )? )?
referenced by:
::= 'WITH' 'RECURSIVE'? common-table-expression ( ',' common-table-expression )* 'UPDATE' ( 'OR' ( 'ROLLBACK' | 'ABORT' | 'REPLACE' | 'FAIL' | 'IGNORE' ) )? quorified-table-name 'SET' ( column-name | column-name-list ) '=' expr ( ',' ( column-name | column-name-list ) '=' expr )* ( 'FROM' ( table-or-subquery ( ',' table-or-subquery )* | join-clause ) )? ( 'WHERE' expr )?
referenced by:
::= 'WITH' 'RECURSIVE'? common-table-expression ( ',' common-table-expression )* 'UPDATE' ( 'OR' ( 'ROLLBACK' | 'ABORT' | 'REPLACE' | 'FAIL' | 'IGNORE' ) )? quorified-table-name 'SET' ( column-name | column-name-list ) '=' expr ( ',' ( column-name | column-name-list ) '=' expr )* ( 'FROM' ( table-or-subquery ( ',' table-or-subquery )* | join-clause ) )? ( 'WHERE' expr )? ( 'ORDER' 'BY' ordering-term ( ',' ordering-term )* )? ( 'LIMIT' expr ( ( 'OFFSET' | ',' ) expr )? )?
referenced by:
::= 'VACUUM' schema-name? ( 'INTO' filename )?
referenced by:
referenced by:
referenced by:
::= 'UNION' 'ALL'?
| 'INTERSECT'
| 'EXCEPT'
referenced by:
referenced by:
::= ','
| 'NATURAL'? ( 'LEFT' 'OUTER'? | 'INNER' | 'CROSS' )? 'JOIN'
referenced by:
referenced by:
::= expr ( 'COLLATE' collation-name )? ( 'ASC' | 'DESC' )? ( 'NULLS' ( 'FIRST' | 'LAST' ) )?
referenced by:
::= expr ( 'AS'? column-alias )?
| ( table-name '.' )? '*'
referenced by:
| '(' ( ( table-or-subquery ( ',' table-or-subquery )* | join-clause ) ')' | select-stmt ')' ( 'AS'? table-ailas )? )
referenced by:
::= ( schema-name '.' )? table-name ( 'AS'? table-name )? ( 'INDEXED' 'BY' index-name | 'NOT' 'INDEXED' )?
referenced by:
::= '(' base-window-name ( 'PARTITION' 'BY' expr ( ',' expr )* )? ( 'ORDER' 'BY' ordering-term ( ',' ordering-term )* )? frame-spec? ')'
referenced by:
::= ( 'RANGE' | 'ROWS' | 'GROUPS' ) ( 'BETWEEN' ( ( 'UNBOUNDEFD' | expr ) 'PRECEDING' | 'CURRENT' 'ROW' | expr 'FOLLOWING' ) 'AND' ( ( 'UNBOUNDEFD' | expr ) 'FOLLOWING' | 'CURRENT' 'ROW' | expr 'PRECEDING' ) | ( 'UNBOUNDEFD' | expr ) 'PRECEDING' | 'CURRENT' 'ROW' ) ( 'EXCLUDE' ( 'NO' 'OTHERS' | 'CURRENT' 'ROW' |
'GROUP' | 'TIES' ) )?
referenced by:
expr ::= literal-value
| expr ( ( binary-operator | 'IS' 'NOT'? ) expr | 'COLLATE' collation-name | 'NOT'? ( ( ( 'LIKE' | 'GLOB' | 'REGEXP' | 'MATCH' ) ( expr 'ESCAPE' )? | 'BETWEEN' expr 'AND' ) expr | 'IN' ( '(' ( select-stmt | expr ( ',' expr )* ) ')' | ( schema-name '.' )? ( table-name | table-function '(' ( expr ( ',' expr )* )? ')' ) ) ) | 'ISNULL' | 'NOTNULL' | 'NOT' 'NULL' )
| ( '(' expr ( ',' expr )* | 'CAST' '(' expr 'AS' type-name | ( 'NOT'? 'EXISTS' )? '(' select-stmt ) ')'
referenced by:
::= 'RAISE' '(' ( 'IGNORE' | ( 'ROLLBACK' | 'ABORT' | 'FAIL' ) ',' error-message ) ')'
referenced by:
::= numeric-literal
| 'NULL'
| 'TRUE'
| 'FALSE'
| 'CURRENT_TIME'
| 'CURRENT_DATE'
| 'CURRENT_TIMESTAMP'
referenced by:
| '0x' hexdigit+
referenced by:
::= 'ON' 'CONFLICT' ( '(' indexed-column ',' indexed-column ( 'WHERE' expr )? ')' )? 'DO' ( 'NOTHING' | 'UPDATE' 'SET' ( column-name | column-name-list ) '=' expr ( ',' ( column-name | column-name-list ) '=' expr )* ( 'WHERE' expr )? )
referenced by:
::= signed-number
| name
referenced by:
::= 'SELECT' ( 'DISTINCT' | 'ALL' )? result-column ( ',' result-column )* ( 'FROM' ( table-or-subquery ( ',' table-or-subquery )* | join-clause ) )? ( 'WHERE' expr )? ( 'GROUP' 'BY' expr ( ',' expr )* ( 'HAVING' expr )? )? ( 'WINDOW' window-name 'AS' window-defn ( ',' window-name 'AS' window-defn )* )?
referenced by:
::= 'WITH' 'RECURSIVE'? common-table-expression ( ',' common-table-expression )* select-core ( 'ORDER' 'BY' ordering-term ( ',' ordering-term )* )? ( 'LIMIT' expr ( ( 'OFFSET' | ',' ) expr )? )?
no references
::= 'WITH' 'RECURSIVE'? common-table-expression ( ',' common-table-expression )* select-core ( compound-operrator select-core )+ ( 'ORDER' 'BY' ordering-term ( ',' ordering-term )* )? ( 'LIMIT' expr ( ( 'OFFSET' | ',' ) expr )? )?
no references
::= '(' column-name ( ',' column-name )* ')'
referenced by:
| '/*' anything-except-asterisk_slash ( '*/' | end-of-input )
no references
::= 'FILTER' '(' 'WHERE' expr ')'
referenced by:
::= 'OVER' ( window-name | window-defn )
referenced by:
no references
aggregate-function-invocation:
no references
::= window-function-name '(' ( 'DISINCT'? expr ( ',' expr )* | '*' )? ')' filter-clause? over-clause?
no references
|