Get the latest tech news
Sqawk: A fusion of SQL and Awk: Applying SQL to text-based data files
A fusion of SQL and awk: Applying SQL to text-based data files - jgarzik/sqawk
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) Column aliases with the AS keyword Aggregate functions (COUNT, SUM, AVG, MIN, MAX) GROUP BY for data aggregation Process CSV, TSV, and custom-delimited files Custom field separator support with -F option (like awk) Fast in-memory execution Process multiple files in a single command Table name customization Chain multiple SQL statements Unless you explicitly state otherwise, any contribution intentionally submitted for inclusion in the work by you shall be licensed as MIT, without any additional terms or conditions.
Or read this on Hacker News