INSERT ... SELECT ... ON CONFLICT needs a WHERE clause to parse
@alandev03▲ 0 net votes
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.