textql

Query CSV

$ textql -sql "[SELECT * FROM file]" [data.csv]

$ textql -header -sql "[SELECT name FROM file]" [data.csv]

$ textql -dlm=";" -sql "[query]" [data.csv]

$ textql -save-to [output.db] [data.csv]

$ textql -output-file [result.csv] -sql "[query]" [data.csv]

textql [-sql query] [-header] [-dlm delim] [options] files

textql allows running SQL queries against structured text files such as CSV and TSV. It loads files into an in-memory SQLite database, treating each file as a table, and executes standard SQL queries against them.
When -header is specified, the first row is used for column names; otherwise columns are named c0, c1, etc. Multiple files can be loaded simultaneously and joined using SQL JOIN syntax. The -save-to option persists the imported data to a SQLite database file for further analysis. Custom delimiters are supported with the -dlm flag.

-sql QUERY

SQL query.

First row is header.

Field delimiter.

Save to SQLite.

Output file.

Output delimiter.

Memory for large files. SQLite limitations. Go-based tool.

textql was created to execute SQL queries against structured text files like CSV using SQLite.

sqlite3(1), csvq(1), q(1), miller(1)