Skip to content

Latest commit

 

History

History
29 lines (19 loc) · 544 Bytes

README.md

File metadata and controls

29 lines (19 loc) · 544 Bytes

csvql

yet another cli tool to query a csv w/ sql

Example queries

Select all columns from a csv file

./bin/csvql csvql 'select * from file.csv'

Select single / multiple specific columns

./bin/csvql csvql 'select col1, col2 from file.csv'

Conditions

./bin/csvql csvql 'select * from file.csv where col1 + col2 = 2'

TODO

  • support column aggregations - count, sum
  • support multiply, divide on int
  • support lesser than, greater than, and respective equals conditions for int