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) Column aliases with the AS keyword Aggregate functions (COUNT, SUM, AVG, MIN, MAX) GROUP BY for data aggregation Multi-Table Operations Cross joins between tables INNER JOIN with ON conditions for precise join criteria Support for joining multiple tables Table-qualified column names Smart Data Handling Automatic type inference (Integer, Float, Boolean, String) Type coercion for comparisons Null value support File Format Support Process CSV, TSV, and custom-delimited files Custom field se ... Read full article.