World: r3wp

The new(er) WAL (Write Ahead Logging) transaction mode reduces locking 
and increases concurrency -- http://sqlite.org/wal.html.

Seems that the SQL interpreter (SQL.r) do not support multi lines 
:

SQL> create table c2 [
** Syntax Error: Missing ] at end-of-script
** Near: (line 1) create table c2 [

Correct, it's just an 'ask loop (hence no semi-colon for command 
termination).