sqlite-utils upsert can now infer the primary key of an existing table, so the --pk flag can be omitted when upserting into a table that already has one defined.

Upsert no longer requires explicitly specifying --pk if the target table already has a primary key, closing a gap from the 4.0 Python API improvement. ✦ AI generated

Simon Willison · Simon Willison's Weblog · 2026-07-11 · original ↗

sqlite-utils upsert can now infer the primary key of an existing table, so --pk can be omitted when upserting into a table that already has a primary key. Another Codex suggestion, an obvious missing CLI feature from a Python library improvement that shipped in the 4.0 release.

Read full article ↗excerpt · fair-use quotation