Interesting tool. Haven't had a need for it yet, but I might. You never know.

q - Text as Data

Anyway, here is the blurb from their site:

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.

I can see where this could be very handy.

To install, for MacOs, do this:

brew install q

For others, look at their website.