CSV Query
This is based on the idea of rows but I want to limit it only to a fast CSV parser with the embeded sqlite query.
This is still is not fully done
Installing
Homebrew
brew install jaysonsantos/tools/csv-query
From source
Assuming you already have cargo just run this:
cargo install --git https://github.com/jaysonsantos/csv-query-rs
When the project is mature enough it will be sent to crates.io.
Usage
Save these two example files.
user.csv
user_id;name
1;User 1
2;User 2
3;User 3
credits.csv
user_id;credit
1;5
1;30
2;3
1;4
3;1
and you should be able to run this query over it
;;
;;
;;