Expired50% confidenceReleaseExact time
sqlite-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.
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.78% similarUnverifiedThe 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.71% similarUnverifiedIn sqlite-utils 4.1, sqlite-utils query can use - in place of a query string to read SQL from standard input.70% similarUnverifiedMultiple features in sqlite-utils 4.1 were implemented by the author after reviewing open issues with Codex.65% similarUnverifiedsqlite-utils 使用「创建新表→复制数据→删除旧表→重命名」模式实现表结构变换，因为 SQLite 对 ALTER TABLE 的支持有限65% similar
Cite This Claim
Stable URI
https://kongchang.com/claim/609216API
curl https://kongchang.com/api/v1/knowledge/claims/609216MCP
get_claim(id=609216)