Exploring options and directions for SQLite

Proposed SQLite Procedural Language

STATEMENT

The execution part of a block is built up from statements. Statements can be procedural statements, such as assignments, branches and loops, or sql statements that operate on the database, such as insert and delete.

SYNTAX

statement-list ::=	statement ; [statement ;]*
statement ::=	stmt-assign \| stmt-block \| stmt-call \| stmt-case \| stmt-exit \| stmt-for \| stmt-loop \| stmt-null \| stmt-raise \| stmt-return \| stmt-while\| stmt-SQL
stmt-SQL ::=	stmt-select \| stmt-insert \| stmt-update \| stmt-delete

DISCUSSION

Statements are terminated, not separated by a semi-colon. In this sense, SQLite/PL is like C or Java, and not like Pascal or PL/SQL.

The various statements are discussed in more detail on individual pages:

assignment
block
procedure call
CASE statement
EXIT statement
expressions

IF statement
FOR statement
LOOP statement
NULL statement
RAISE statement
RETURN statement

WHILE statement
SELECT INTO statement
INSERT statement
UPDATE statement
DELETE statement

Version August 2008