Syntax error column name key in SQLite

[samal-rasmussen]

This:

CREATE TABLE key_value (key TEXT PRIMARY KEY, value TEXT

Results in:

Syntax Error: Unexpected "key"
Was expecting to see: "CHECK", "CONSTRAINT", "FOREIGN", "PRIMARY", "UNIQUE", identifier, or whitespace
--> undefined:1:25
  |
1 | CREATE TABLE key_value (key TEXT PRIMARY KEY, value TEXT;
  |                         ^

[nene]

Thanks for reporting.

I used this list of keywords in SQLite documentation, assuming none of these can be used as normal identifiers (as the text on that page suggests), but apparently not all of them are actually reserved keywords.

[samal-rasmussen]

Yeah I did not look at anything at all before I just used key as a column name :D I didn't even know basic stuff like "A keyword in double-quotes is an identifier.". Thanks for linking to the keyword docs.

I was a bit surprised that a formatter would care about this, but of course the formatter uses a parser, which has more reason to care.