table.convert(..., where=) and sqlite-utils convert ... --where=

[simonw]

For applying the conversion to a subset of rows selected using the where clause.

Should also take optional arguments, as seen in db["dogs"].delete_where("age < ?", [3]).

Follows #302 and #251. This was originally simonw/sqlite-transform#9

[simonw]

For the command-line version this can duplicate the --param option to allow named parameters in the where clause:

sqlite-utils/sqlite_utils/cli.py

Lines 1096 to 1102 in c7e8d72

	@click.option(
	"-p",
	"--param",
	multiple=True,
	type=(str, str),
	help="Named :parameters for SQL query",
	)

[simonw]

For the Python function, the args will be where=None, where_args=None.

[simonw]

Documented here:

• https://sqlite-utils.datasette.io/en/latest/python-api.html#converting-data-in-columns
• https://sqlite-utils.datasette.io/en/latest/cli.html#converting-data-in-columns