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