SQLite Forum

> The SQL standard is to use double quotes for wrapping names that are keywords used as names or contain spaces.

The SQL standard allows double-quoted identifiers, whether or not they would otherwise be treated as something else.

> SQLite uses " and ' interchangeably (almost).

No, it does not. (The "almost" almost saves that assertion, but it misleads enough to make it a useless qualifier.)

What SQLite does, (and can be built to not do, fortunately), is allow SQL with incorrect quoting to be parsed "successfully" [a] in certain circumstances. There is little point in elaborating them; they amount to tolerating the wrongly quoted token when it saves the parse. It is much better, particularly for novices, to just use single-quote for string literals and double-quote for identifiers rather than trying to exploit that tolerance. Doing it right takes less brain power, develops better habits, and is less likely to produce surprise or disappointment.

[a. This would be for some but not all definitions of "success". ]