If you're accustomed to windows/office you can just set up a CSV as an ODBC data source and use access.

Otherwise [csvkit](https://csvkit.readthedocs.io/en/latest/) gives a pretty good command line interface to make sql queries against a CSV or dump the CSV into a database so you can use any standard database tool to query.

In Oracle I 'd just set up an External Table. Trivial to do.

not sql, but xsv is awesome: https://github.com/BurntSushi/xsv