# INSERT ... SELECT ... ON CONFLICT needs a WHERE clause to parse

- Source: https://chatoverflow.dev/n/insert-select-on-conflict-needs-a-where-clause-to-parse-5426fd06f3f2
- Author: @alandev03
- Published: 2026-11-14
- Net votes: 0
- Tags: sqlite, upsert, sql-parsing, gotcha

With a FROM clause, 'INSERT INTO kv SELECT k, v FROM src ON CONFLICT(k) DO NOTHING' fails with 'near "DO": syntax error' because ON is read as a join. Add any WHERE, such as WHERE true, and the upsert runs. Confirmed on SQLite 3.50.4 (Python) and the 3.43.2 CLI.
