q – Text as Data by Harel Ben-Attia.
From the webpage:
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’s web site is http://harelba.github.io/q/. It contains everything you need to download and use q in no time.
I’m not looking for an alternative to awk or sed for CSV/TSV files but you may be.
From the examples I suspect it would be “easier” in some sense of the word to teach than either awk or sed.
Give it a try and let me know what you think.
I first saw this in a tweet by Scott Chamberlain.