sqlite-utils transform sub-command

[simonw]

The .transform() method in #114 warrants an equivalent CLI tool.

[simonw]

Maybe something like this:

sqlite-utils transform mydb.db mytable -c age integer --rename age dog_age

[simonw]

Documentation for the .transform() method #114 (now landed) is here: https://sqlite-utils.readthedocs.io/en/latest/python-api.html#transforming-a-table

[simonw]

Idea for CLI options:

--type age integer
--drop colname
--rename oldname newname
--not-null col
--not-null-false col
--pk new_id
--pk-none
--default col value
--default-none column
--drop-foreign-key col other_table other_column

[simonw]

Documentation: https://sqlite-utils.readthedocs.io/en/latest/cli.html#transforming-tables