sqlite-utils 4.1 Enhances Data Insertion and Table Management

The latest release of sqlite-utils, version 4.1, introduces several minor enhancements to its command-line interface and Python library, building upon the recent 4.0 update. A significant addition is the --code option for the `insert` and `upsert` commands, allowing users to provide Python code blocks or file paths that define a `rows()` function or iterable. This offers an alternative to importing data from files, extending the existing capability of passing Python code snippets to commands like `convert`. The update also introduces a --type option for `insert` and `upsert` commands, enabling users to override the automatically inferred data type for columns. This is particularly useful for columns like ZIP codes, which may appear as integers but should be stored as TEXT to preserve leading zeros. Additionally, a new `table.drop_index(name)` method and a corresponding `drop-index` command have been added, allowing users to remove indexes by name, with an `ignore=True` option to handle missing indexes gracefully. The `query` command now supports reading SQL queries from standard input by passing a hyphen as the query argument. Further improvements include the ability for `sqlite-utils upsert` to infer the primary key of an existing table, eliminating the need for the --pk option when a primary key is already defined. Finally, `table.transform()` and `table.transform_sql()` methods, along with the `transform` command, now accept `strict=True/False` or `--strict`/`--no-strict` flags to manage a table's SQLite strict mode, inspired by recent discussions on the benefits of STRICT tables.