SQLite Forum

Beginner: keep getting ...>
Login
Note that this applies to other "identifier quotes" which must occur in opening and closing pairs, such as square brackets `[]` and tick-quotes (grave accent marks) ``

Note that this does not apply to syntactic elements such as parenthesis (), which only must appear in pairs to create a syntactically valid statement but do not need to appear in proper-syntax-pairs to form a statement.

That is, quotes are semantic elements and must be closed in order for the statement to be complete.  Semantic quotes are single-quote, double-quote, square brackets, and tick-quotes (grave accent symbol).