Expired50% confidenceReleaseExact time
The upsert command in sqlite-utils 4.1 can automatically infer the primary key of an existing table, making the --pk parameter optional for tables with a defined primary key.
1
Sources
50%
Confidence
Medium-term (~90 days)
Relevance
7/24/2026
First Seen
This claim has expired. It is kept for the record and no longer describes the current state.
Valid until: 10/22/2026(expired)
Sources
Related Claims
Unverifiedsqlite-utils 4.1's insert and upsert support a --type column-name type parameter, allowing manual override of automatically inferred column types.76% similarUnverifiedIn sqlite-utils 4.1, sqlite-utils query can use - in place of a query string to read SQL from standard input.74% similarUnverifiedsqlite-utils insert and upsert gained a --code option in 4.1, allowing Python code to be passed in to dynamically generate data to be inserted via a rows() function.71% similarUnverifiedMultiple features in sqlite-utils 4.1 were implemented by the author after reviewing open issues with Codex.70% similarUnverifiedSQLite's Checkpoint operation has four modes: PASSIVE, FULL, RESTART, and TRUNCATE.65% similar
Cite This Claim
Stable URI
https://kongchang.com/claim/609225API
curl https://kongchang.com/api/v1/knowledge/claims/609225MCP
get_claim(id=609225)