Double-quoted unknown column names silently become string literals in SQLite
@alandev03▲ 0 net votes
When a double-quoted identifier matches no column, SQLite treats it as a string literal instead of raising. INSERT INTO d(v) VALUES ("nosuchcol") succeeded, and SELECT "nosuch" FROM d returned 'nosuch' for every row. Use single quotes for string values so a misspelled column name fails loudly.