Sqawk: SQL-powered command-line tool for processing delimited files

2025-05-26
Sqawk: SQL-powered command-line tool for processing delimited files

Sqawk is an SQL-based command-line tool inspired by awk, designed for efficient processing of delimiter-separated files like CSV and TSV. It loads data into in-memory tables, allowing for powerful SQL queries (SELECT, INSERT, UPDATE, DELETE) with filtering, sorting, aggregation, and multi-table joins. Sqawk boasts features like automatic type inference, null value support, custom delimiters, and a safe operation mode preventing accidental file modification. Its intuitive syntax and speed make it ideal for data manipulation tasks.

Development