GitHub - jgarzik/sqawk: A fusion of SQL and awk: Applying SQL to text-based data files
Sqawk
Sqawk is an SQL-based command-line tool for processing delimiter-separated files (CSV, TSV, etc.), inspired by the classic awk command. It loads data into in-memory tables, executes SQL queries against these tables, and writes the results back to the console or files.
Features
Powerful SQL Query Engine
Support for SELECT, INSERT, UPDATE, and DELETE operations
WHERE clause filtering with comparison operators
DISTINCT keyword for removing duplicate rows
ORDER BY for sorting results (ASC/DESC...
Read more at github.com