Properly determine SQLite reserved keywords

Open nene opened this issue 1 year ago • 0 comments

We're currently using the SQLite keywords list as the list of reserved keywords for SQLite. But not all of these keywords are actually fully reserved. Some can always be used as identifiers while others can be used in some contexts. One needs to go manually though all of them to classify them all properly.

[ ] ABORT
[ ] ACTION
[x] ADD (R)
[ ] AFTER
[x] ALL (R)
[x] ALTER (R)
[ ] ALWAYS
[ ] ANALYZE
[x] AND (R)
[x] AS (R)
[ ] ASC
[ ] ATTACH
[x] AUTOINCREMENT (R)
[ ] BEFORE
[ ] BEGIN
[ ] BETWEEN
[ ] BY
[ ] CASCADE
[ ] CASE
[ ] CAST
[ ] CHECK
[ ] COLLATE
[x] COLUMN (Can mostly be used as identifier, except in ADD COLUMN, DROP COLUMN, RENAME COLUMN)
[ ] COMMIT
[ ] CONFLICT
[ ] CONSTRAINT
[ ] CREATE
[ ] CROSS
[ ] CURRENT
[ ] CURRENT_DATE
[ ] CURRENT_TIME
[ ] CURRENT_TIMESTAMP
[ ] DATABASE
[ ] DEFAULT
[ ] DEFERRABLE
[ ] DEFERRED
[ ] DELETE
[ ] DESC
[ ] DETACH
[x] DISTINCT (R)
[ ] DO
[x] DROP (R)
[ ] EACH
[x] ELSE (R)
[ ] END
[x] ESCAPE (R)
[x] EXCEPT (R)
[ ] EXCLUDE
[ ] EXCLUSIVE
[x] EXISTS (R)
[ ] EXPLAIN
[ ] FAIL
[ ] FILTER
[ ] FIRST
[ ] FOLLOWING
[ ] FOR
[x] FOREIGN (R)
[x] FROM (R)
[ ] FULL
[ ] GENERATED
[ ] GLOB
[x] GROUP (R)
[ ] GROUPS
[x] HAVING (R)
[x] IF (R)
[ ] IGNORE
[ ] IMMEDIATE
[x] IN (R)
[x] INDEX (R)
[ ] INDEXED
[ ] INITIALLY
[ ] INNER
[x] INSERT (R)
[ ] INSTEAD
[x] INTERSECT (R)
[x] INTO (R)
[x] IS (R)
[x] ISNULL (R)
[x] JOIN (R)
[x] KEY (Can always be an identifier. Only occurs as part of PRIMARY KEY or FOREIGN KEY)
[ ] LAST
[ ] LEFT
[ ] LIKE
[x] LIMIT (R)
[ ] MATCH
[ ] MATERIALIZED
[ ] NATURAL
[ ] NO
[x] NOT (R)
[x] NOTHING (R)
[x] NOTNULL (R)
[x] NULL (R)
[ ] NULLS
[ ] OF
[ ] OFFSET
[x] ON (R)
[x] OR (R)
[x] ORDER (R)
[ ] OTHERS
[ ] OUTER
[ ] OVER
[ ] PARTITION
[ ] PLAN
[ ] PRAGMA
[ ] PRECEDING
[x] PRIMARY (R)
[ ] QUERY
[ ] RAISE
[ ] RANGE
[ ] RECURSIVE
[x] REFERENCES (R)
[ ] REGEXP
[ ] REINDEX
[ ] RELEASE
[ ] RENAME
[ ] REPLACE
[ ] RESTRICT
[x] RETURNING (R)
[ ] RIGHT
[ ] ROLLBACK
[ ] ROW
[ ] ROWS
[ ] SAVEPOINT
[x] SELECT (R)
[x] SET (R)
[x] TABLE (R)
[ ] TEMP
[ ] TEMPORARY
[x] THEN (R)
[ ] TIES
[x] TO (R)
[x] TRANSACTION (R)
[ ] TRIGGER
[ ] UNBOUNDED
[x] UNION (R)
[x] UNIQUE (R)
[x] UPDATE (R)
[x] USING (R)
[ ] VACUUM
[x] VALUES (R)
[ ] VIEW
[ ] VIRTUAL
[x] WHEN (R)
[x] WHERE (R)
[ ] WINDOW
[ ] WITH
[ ] WITHOUT

I've tested them all using CREATE TABLE <keyword> (id INT). Those that caused a syntax error I labeled with (R). But it's not the whole story.

Oct 26 '24 14:10 nene