q is a command line tool that allows direct execution of SQL-like queries on CSVs/TSVs (and any other tabular text files).

q treats ordinary files as database tables, and supports all SQL constructs, such as WHERE, GROUP BY, JOINs etc. It supports automatic column name and column type detection, and provides full support for multiple encodings.

	q "SELECT COUNT(*) FROM ./clicks_file.csv WHERE c3 > 32.3"

	ps -ef | q -H "SELECT UID,COUNT(*) cnt FROM - GROUP BY UID ORDER BY cnt DESC LIMIT 3"

Look at the examples page for some more examples, or just download the tool using the links above or in the installation page and play with it.