dsq

Run SQL queries against JSON, CSV, Excel, Parquet files

brewmacoslinux

Try with needOr install directly

About

CLI tool for running SQL queries against JSON, CSV, Excel, Parquet, and more

dsq

Query a JSON file to select specific fields$ dsq data.json "SELECT name, age FROM data WHERE age > 30"

Query a CSV file and output results as JSON$ dsq -o json people.csv "SELECT * FROM people LIMIT 10"

Join and aggregate data from multiple file types$ dsq data.parquet "SELECT category, COUNT(*) as count FROM data GROUP BY category"