Consider disabling double-quoted strings by default
As per https://www.sqlite.org/quirks.html#double_quoted_string_literals_are_accepted, you may want to consider having the default for modernc.org/sqlite to reject double-quoted string literals. There are two ways to do this:
- Compile with
-DSQLITE_DQS=0. This will change the behavior for any user ofmodernc.org/sqlite/lib. - Use
sqlite3_db_configon connections created throughmodernc.org/sqlite. This preserves the behavior inmodernc.org/sqlite/lib, but gives a better default experience for users of thedatabase/sqldriver.
I'm using sqlite3_db_config in zombiezen.com/go/sqlite: https://github.com/zombiezen/go-sqlite/commit/ed99db83671cdf65aeb34b1bcd490ba66d712e97
Edited by Roxy Light