SQLite Forum

index question
This point is orthogonal to Keith's response.

You will likely learn, if you keep programming, not to use keywords as identifiers.  In SQL, an identifier can be quoted, with surrounding doublequote characters, to make it act only as an identifier rather than being parsed as a keyword if it happens to be one. If you insist on using keywords as identifiers, you should be quoting them. The fact that SQLite's parser happens to tolerate unquoted keywords in some places where an identifier can be used is one you should not rely upon unless you plan to write SQL only for SQLite.

Potential parser errors aside, you will be doing a favor for anybody who has to read your SQL if you keep keywords and identifiers distinct from each other.