I've gotten some good mileage out of sqlite-utils[0] lately. It and it's parent project datasette[1] are a wonderful contribution to the sqlite community.

[0] https://sqlite-utils.datasette.io/en/stable/cli.html#transfo... [1] https://datasette.io/