Quote column names when creating tables via sqlite

[scw]

I have an input table which includes the column 'unique', and it failed to import, with the error:

DBMI-SQLite driver error:
Error in sqlite3_prepare():
near "varchar": syntax error

This is due to "unique" being a reserved keyword in SQLite. This can be fixed by quoting column names prior to passing them to SQLite, see this page for details:

​http://www.sqlite.org/lang_keywords.html

[neteler]

For SQL reserved word collisions, see also #1755 and #578

[martinl]

No activity for a long time. Closing. Feel free to reopen if needed.