SQL query command: turbocsv query "SELECT ..."

[bytebrujo]

Proposal

A SQL interface over CSV files (à la q / DuckDB), backed by the Zig DataFrame ops:

turbocsv query "SELECT name, AVG(salary) FROM data.csv GROUP BY dept WHERE age > 30"

This would be a flagship differentiator and a top reason users reach for CSV CLIs.

Scope (incremental)

• Phase A: SELECT / WHERE / ORDER BY / LIMIT single-file
• Phase B: GROUP BY + aggregates
• Phase C: JOIN across multiple files

Open questions

• Embed a tiny SQL parser vs. map a constrained subset to DataFrame ops
• File aliasing in FROM

Acceptance

• Parse + execute a SELECT/WHERE/ORDER/LIMIT query end-to-end
• Tests for each clause