Research: handle gzipped CSV directly

[simonw]

Would it be worthwhile for the sqlite-utils command-line tool to grow features to efficiently directly interact with gzipped CSV data?

Maybe add --gz options to both insert and to the various commands that output query results.

[simonw]

Something like this then:

sqlite-utils file.db "select * from t" --csv --gz > t.csv.gz

Maybe add a -o t.csv.gz option too so you don't have to use a >.

[simonw]

Some questions:

• Should this support compression formats other than gzip?
• Should memory learn to auto-detect gzipped data?