cqlite

Query a CSV file from the commandline

Installation

pipx install cqlite

Usage

In memory query:

cqlite <csv_file> <query>

e.g.

cqlite fakedata.csv "SELECT * FROM csv WHERE name LIKE '%Tommy% AND date_of_birth < '1980-01-01';"

(note filedata is loaded into a table called "csv").

Save `<csv_file>.csv as a SQLite database (<csv_file>.db):

cqlite <csv_file> --persist