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.
sqawk -s "SELECT * FROM data" data.csvThis loads data.csv into an in-memory table called "data" and performs a SELECT query.
sqawk -s "SELECT * FROM employees WHERE salary > 50000" employees.csvsqawk -s "UPDATE data SET status = 'active' WHERE id = 5" data.csv --writeThis updates the status field to 'active' for rows with id = 5 and saves the changes back to data.csv.
sqawk -s "DELETE FROM data WHERE id = 5" data.csv --writeThis removes rows with id = 5 and saves the changes back to data.csv.
sqawk -s "UPDATE data SET status = 'inactive' WHERE last_login < '2023-01-01'" -s "DELETE FROM data WHERE status = 'inactive' AND last_login < '2022-01-01'" -s "SELECT * FROM data" data.csv --writeThis executes multiple SQL statements in sequence: first marking recent inactive accounts, then removing very old inactive accounts, and finally showing the results.
sqawk -s "SELECT * FROM users" -s "SELECT * FROM orders" users.csv orders.csv# Get unique values from a single column
sqawk -s "SELECT DISTINCT category FROM products" products.csv
# Get unique combinations of columns
sqawk -s "SELECT DISTINCT department, role FROM employees" employees.csv
# Use DISTINCT with ORDER BY for sorted unique values
sqawk -s "SELECT DISTINCT region FROM customers ORDER BY region" customers.csv# Join users and orders using INNER JOIN with ON condition
sqawk -s "SELECT users.name, orders.product_id, orders.date FROM users INNER JOIN orders ON users.id = orders.user_id" users.csv orders.csv
# Join with additional WHERE filtering
sqawk -s "SELECT users.name, orders.product_id, orders.date FROM users INNER JOIN orders ON users.id = orders.user_id WHERE orders.product_id > 100" users.csv orders.csv
# Using DISTINCT with JOINs to find unique customer-product pairs
sqawk -s "SELECT DISTINCT users.name, products.name FROM users INNER JOIN orders ON users.id = orders.user_id INNER JOIN products ON orders.product_id = products.product_id" users.csv orders.csv products.csv# Process a tab-delimited file (TSV)
sqawk -F '\t' -s "SELECT * FROM employees WHERE salary > 70000" employees.tsv
# Process a colon-delimited file
sqawk -F ':' -s "SELECT id, name, email FROM contacts" contacts.txtsqawk -s "SELECT * FROM data WHERE value > 100" data.csv -vsqawk -s "DELETE FROM data WHERE status = 'expired'" data.csv --writeBy default, sqawk doesn't modify input files. Use the --write flag to save changes back to the original files.
For more detailed information, see:
Licensed under the MIT License (LICENSE or http://opensource.org/licenses/MIT).
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.