ply

A tool for running SQL queries on CSVs

Installation

git clone https://github.com/amcknight/ply.git
cd ply
stack build
stack install

I put ~/.local/bin in my PATH to make it available in my shell after install.

With a CSV that has headers 'name' and 'age' in "my/dir/" you could, for example, run:

ply "SELECT name, "Mc" ++ name ++ "face" AS mcname FROM my/dir/people WHERE age < 30"