List of SQLite Syntax Diagrams aggregate-function-invocation alter-table-stmt analyze-stmt attach-stmt begin-stmt column-constraint column-def column-name-list comment-syntax commit-stmt common-table-expression compound-operator compound-select-stmt conflict-clause create-index ... 

Syntax Diagrams For SQLite aggregate-function-invocation: References:   expr   filter-clause   ordering-term See also:   lang_aggfunc.html   lang_expr.html#*funcinexpr alter-table-stmt: Used by:   sql-stmt References ... 

 ... The SQL language syntax is described by syntax diagrams. The following syntax documentation topics are available: aggregate functions ALTER TABLE ANALYZE ATTACH DATABASE BEGIN TRANSACTION comment COMMIT TRANSACTION core functions CREATE INDEX CREATE TABLE CREATE TRIGGER CREATE VIEW CREATE VIRTUAL ... 

 ... The "" syntax diagram above attempts to show as much of the SELECT statement syntax as possible in a single diagram, because some readers find that helpful. The following "" is an alternative syntax diagrams that expresses the same syntax but tries ... 

2. Background The following diagram illustrates the complete SQLite build process: The complete build process starts with the canonical source code files on the left side of the diagram. There are between 100 and 200 separate canonical source files (depending on the ... 

 ... UPSERT in SQLite follows the syntax established by PostgreSQL, with generalizations. An UPSERT is an ordinary INSERT statement that is followed by one or more ON CONFLICT clauses, as shown in the syntax diagram above. The syntax in between the ... 

 ... Hence, when you say column1="column1" that is equivalent to column1=column1 which is obviously always true. (25) How are the syntax diagrams (a.k.a. "railroad" diagrams) for SQLite generated? Each diagram is hand-written using the Pikchr diagramming ... 

 ... The main expression bubble diagram above shows a single syntax for all function invocations. But this is merely to simplify the expression bubble diagram. In reality, each type of function has a slightly different syntax, shown below. The function invocation ... 

 ... The "TO SAVEPOINT name" clause of the ROLLBACK command shown in the syntax diagram above is only applicable to SAVEPOINT transactions. An attempt to invoke the BEGIN command within a transaction will fail with an error, regardless of whether the ... 

 ... A nearby diagram shows the main components of SQLite and how they interoperate. The text below explains the roles of the various components. Overview SQLite works by compiling SQL text into bytecode, then running that bytecode using a virtual machine ...