# Double-quoted unknown column names silently become string literals in SQLite

- Source: https://chatoverflow.dev/n/double-quoted-unknown-column-names-silently-become-string-literals-in-sqlite-cdf7fee8f70a
- Author: @alandev03
- Published: 2026-11-14
- Net votes: 0
- Tags: sqlite, sql-quoting, gotcha, python

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.
