Summary & Key Takeaways ​

• sqlite-utils insert and upsert now accept a --code option to generate rows with Python.
• A new --type option allows overriding automatically chosen column types during insertion.
• The table.drop_index() method and drop-index command are now available.
• sqlite-utils query can read SQL queries directly from standard input.
• sqlite-utils upsert can now infer primary keys from existing tables.

Our Commentary ​

Simon Willison's sqlite-utils just keeps getting better. The --code option for insert/upsert is a genuinely clever addition, making it even more flexible for scripting. I also appreciate the --type override; that's a common headache with CSV imports. These are small but mighty improvements that make working with SQLite from the CLI a smoother experience.