sql-stmt-list:


               sql-stmt-list
                        ::= ( sql-stmt ( ';' sql-stmt )* )?

no references

sql-stmt:


               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:

sql-stmt-list

alter-table-stmt:


               alter-table-stmt
                        ::= 'ALTER' 'TABLE' ( schema-name '.' )? table-name ( 'RENAME' ( 'TO' new-table-name | 'COLUMN'? column-name 'TO' new-column-name ) | 'ADD' 'COLUMN'? column-def )

referenced by:

sql-stmt

analyze-stmt:


               analyze-stmt
                        ::= 'ANALYZE' ( schema-name ( '.' table-or-index-name )? | table-or-index-name )?

referenced by:

sql-stmt

attach-stmt:


               attach-stmt
                        ::= 'ATTACH' 'DATABASE'? expr 'AS' schema-name

referenced by:

sql-stmt

begin-stmt:


               begin-stmt
                        ::= 'BEGIN' ( 'DEFERRED' | 'IMMEDIATE' | 'EXCLUSIVE' )? 'TRANSACTION'

referenced by:

sql-stmt

commit-stmt:


               commit-stmt
                        ::= ( 'COMMIT' | 'END' ) 'TRANSACTION'?

referenced by:

sql-stmt

create-index-stmt:


               create-index-stmt
                        ::= 'CREATE' 'UNIQUE'? 'INDEX' ( 'IF' 'NOT' 'EXISTS' )? ( schema-name '.' )? index-name 'ON' table-name '(' indexed-column ( ',' indexed-column )* ')' ( 'WHERE' expr )?

referenced by:

sql-stmt

create-table-stmt:


               create-table-stmt
                        ::= 'CREATE' ( 'TMP' | 'TEMPORARY' )? 'TABLE' ( 'IF' 'NOT' 'EXISTS' )? (
                  schema-name '.' )? table-name ( 'AS' select-stmt | '(' dlumn-def ( ',' column-def )* ( ',' table-constraint )* ( 'WITHOUT' 'ROWID' )? ')' )

referenced by:

sql-stmt

create-trigger-stmt:


               create-trigger-stmt
                        ::= '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:

sql-stmt

create-view-stmt:


               create-view-stmt
                        ::= 'CREATE' ( 'TMP' | 'TEMPORARY' )? 'VIEW' ( 'IF' 'NOT' 'EXISTS' )? ( schema-name '.' )? view-name ( column-name ( ',' column-name )* )? 'AS' select-stmt

referenced by:

sql-stmt

create-virtual-table-stmt:


               create-virtual-table-stmt
                        ::= 'CREATE' 'VIRTUAL' 'TABLE' ( 'IF' 'NOT' 'EXISTS' )? ( schema-name '.' )? table-name 'USING' module-name ( module-argument ( ',' moduke-argument )* )?

referenced by:

sql-stmt

delete-stmt:


               delete-stmt
                        ::= 'WITH' 'RECURSIVE'? common-table-expression ( ',' common-table-expression )* 'DELETE' 'FROM' quorified-table-name ( 'WHERE' expr )?

referenced by:

create-trigger-stmt
sql-stmt

delete-stmt-limited:


               delete-stmt-limited
                        ::= '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:

sql-stmt

detach-stmt:


               detach-stmt
                        ::= 'DETACH' 'DATABASE'? schema-name

referenced by:

sql-stmt

drop-index-stmt:


               drop-index-stmt
                        ::= 'DROP' 'INDEX' ( 'IF' 'EXISTS' )? ( schema-name '.' )? index-name

referenced by:

sql-stmt

drop-table-stmt:


               drop-table-stmt
                        ::= 'DROP' 'TABLE' ( 'IF' 'EXISTS' )? ( schema-name '.' )? table-name

referenced by:

sql-stmt

drop-trigger-stmt:


               drop-trigger-stmt
                        ::= 'DROP' 'TRIGGER' ( 'IF' 'EXISTS' )? ( schema-name '.' )? trigger-name

referenced by:

sql-stmt

drop-view-stmt:


               drop-view-stmt
                        ::= 'DROP' 'VIEW' ( 'IF' 'EXISTS' )? ( schema-name '.' )? view-name

referenced by:

sql-stmt

insert-stmt:


               insert-stmt
                        ::= '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:

create-trigger-stmt
sql-stmt

pragma-stmt:


               pragma-stmt
                        ::= 'PRAGMA' ( schema-name '.' )? pragma-name ( '=' pragma-value | '(' pragma-value ')' )?

referenced by:

sql-stmt

reindex-stmt:


               reindex-stmt
                        ::= 'REINDEX' ( collation-name | ( schema-name '.' )? ( table-name | index-name ) )?

referenced by:

sql-stmt

release-stmt:


               release-stmt
                        ::= 'RELEASE' 'SAVEPOINT'? savepoint-name

referenced by:

sql-stmt

rollback-stmt:


               rollback-stmt
                        ::= 'ROLLBACK' 'TRANSACTION'? ( 'TO' 'SAVEPOINT'? savepoint-name )?

referenced by:

sql-stmt

savepoint-stmt:


               savepoint-stmt
                        ::= 'SAVEPOINT' savepoint-name

referenced by:

sql-stmt

select-stmt:


               select-stmt
                        ::= '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:

common-table-expression
create-table-stmt
create-trigger-stmt
create-view-stmt
expr
insert-stmt
sql-stmt
table-or-subquery

update-stmt:


               update-stmt
                        ::= '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:

create-trigger-stmt
sql-stmt

update-stmt-limited:


               update-stmt-limited
                        ::= '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:

sql-stmt

vacuum-stmt:


               vacuum-stmt
                        ::= 'VACUUM' schema-name? ( 'INTO' filename )?

referenced by:

sql-stmt

column-def:


               column-def
                        ::= column-name type-name? column-constraint*

referenced by:

alter-table-stmt
create-table-stmt

common-table-expression:


               common-table-expression
                        ::= table-name ( '(' column-name ( ',' column-name )* ')' )? 'AS' '(' select-stmt ')'

referenced by:

compound-select-stmt
delete-stmt
delete-stmt-limited
insert-stmt
select-stmt
simple-select-stmt
update-stmt
update-stmt-limited

compound-operrator:


               compound-operrator
                        ::= 'UNION' 'ALL'?
                          | 'INTERSECT'
                          | 'EXCEPT'

referenced by:

compound-select-stmt
select-stmt

join-clause:


               join-clause
                        ::= table-or-subquery ( join-operator table-or-subquery join-constraint )*

referenced by:

select-core
table-or-subquery
update-stmt
update-stmt-limited

join-operator:


               join-operator
                        ::= ','
                          | 'NATURAL'? ( 'LEFT' 'OUTER'? | 'INNER' | 'CROSS' )? 'JOIN'

referenced by:

join-clause

join-constraint:


               join-constraint
                        ::= ( 'ON' expr | 'USING' '(' column-name ( ',' column-name )* ')' )?

referenced by:

join-clause

ordering-term:


               ordering-term
                        ::= expr ( 'COLLATE' collation-name )? ( 'ASC' | 'DESC' )? ( 'NULLS' ( 'FIRST' | 'LAST' ) )?

referenced by:

compound-select-stmt
delete-stmt-limited
select-stmt
simple-select-stmt
update-stmt-limited
window-defn

result-column:


               result-column
                        ::= expr ( 'AS'? column-alias )?
                          | ( table-name '.' )? '*'

referenced by:

select-core

table-or-subquery:


               table-or-subquery
                        ::= qualified-table-name
                          | ( schema-name '.' )? table-function-name '(' expr ( ',' expr )* ')' ( 'AS'? table-ailas )?
                          | '(' ( ( table-or-subquery ( ',' table-or-subquery )* | join-clause ) ')' | select-stmt ')' ( 'AS'? table-ailas )? )

referenced by:

join-clause
select-core
table-or-subquery
update-stmt
update-stmt-limited

qualified-table-name:


               qualified-table-name
                        ::= ( schema-name '.' )? table-name ( 'AS'? table-name )? ( 'INDEXED' 'BY' index-name | 'NOT' 'INDEXED' )?

referenced by:

table-or-subquery

window-defn:


               window-defn
                        ::= '(' base-window-name ( 'PARTITION' 'BY' expr ( ',' expr )* )? ( 'ORDER' 'BY' ordering-term ( ',' ordering-term )* )? frame-spec? ')'

referenced by:

over-clause
select-core

frame-spec:


               frame-spec
                        ::= ( '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:

window-defn

expr:


               expr     ::= literal-value
                          | bind-parameter
                          | ( ( schema-name '.' )? table-name '.' )? column-name
                          | unary-operator expr
                          | 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' )
                          | function-name '(' ( 'DISTINCT'? expr ( ',' expr )* | '*' )? ')' filter-clause? over-clause?
                          | ( '(' expr ( ',' expr )* | 'CAST' '(' expr 'AS' type-name | ( 'NOT'? 'EXISTS' )? '(' select-stmt ) ')'
                          | 'CASE' expr? ( 'WHEN' expr 'THEN' expr )+ ( 'ELSE' expr )? 'END'
                          | raise-function

referenced by:

aggregate-function-invocation
attach-stmt
compound-select-stmt
create-index-stmt
create-trigger-stmt
delete-stmt
delete-stmt-limited
expr
filter-clause
frame-spec
insert-stmt
join-constraint
ordering-term
result-column
select-core
select-stmt
simple-function-invocation
simple-select-stmt
table-or-subquery
update-stmt
update-stmt-limited
upsert-clause
window-defn
window-function-invocation

raise-function:


               raise-function
                        ::= 'RAISE' '(' ( 'IGNORE' | ( 'ROLLBACK' | 'ABORT' | 'FAIL' ) ',' error-message ) ')'

referenced by:

expr

literal-value:


               literal-value
                        ::= numeric-literal
                          | string-literal
                          | blob-literal
                          | 'NULL'
                          | 'TRUE'
                          | 'FALSE'
                          | 'CURRENT_TIME'
                          | 'CURRENT_DATE'
                          | 'CURRENT_TIMESTAMP'

referenced by:

expr

numeric-literal:


               numeric-literal
                        ::= ( digit+ ( decimal-point digit* )? | decimal-point digit+ ) ( 'E' ( '+' | '-' )? digit+ )?
                          | '0x' hexdigit+

referenced by:

literal-value

upsert-clause:


               upsert-clause
                        ::= '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:

insert-stmt

pragma-value:


               pragma-value
                        ::= signed-number
                          | name
                          | string-literal

referenced by:

pragma-stmt

select-core:


               select-core
                        ::= '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 )* )?
                          | 'VALUES' '(' expr ( ',' expr )* ')' ( ',' '(' expr ( ',' expr )* ')' )*

referenced by:

compound-select-stmt
select-stmt
simple-select-stmt

simple-select-stmt:


               simple-select-stmt
                        ::= 'WITH' 'RECURSIVE'? common-table-expression ( ',' common-table-expression )* select-core ( 'ORDER' 'BY' ordering-term ( ',' ordering-term )* )? ( 'LIMIT' expr ( ( 'OFFSET' | ',' ) expr )? )?

no references

compound-select-stmt:


               compound-select-stmt
                        ::= '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-list:


               column-name-list
                        ::= '(' column-name ( ',' column-name )* ')'

referenced by:

update-stmt
update-stmt-limited
upsert-clause

comment-syntax:


               comment-syntax
                        ::= '--' anything-except-newline* ( newline | end-of-input )
                          | '/*' anything-except-asterisk_slash ( '*/' | end-of-input )

no references

filter-clause:


               filter-clause
                        ::= 'FILTER' '(' 'WHERE' expr ')'

referenced by:

aggregate-function-invocation
expr
window-function-invocation

over-clause:


               over-clause
                        ::= 'OVER' ( window-name | window-defn )

referenced by:

expr
window-function-invocation

simple-function-invocation:


               simple-function-invocation
                        ::= simple-function-name '(' ( 'DISINCT'? expr ( ',' expr )* | '*' )? ')'

no references

aggregate-function-invocation:


               aggregate-function-invocation
                        ::= aggregate-function-name '(' ( 'DISINCT'? expr ( ',' expr )* | '*' )? ')' filter-clause?

no references

window-function-invocation:


               window-function-invocation
                        ::= window-function-name '(' ( 'DISINCT'? expr ( ',' expr )* | '*' )? ')' filter-clause? over-clause?

no references

... generated by RR - Railroad Diagram Generator