I'm really glad I found Table Tool (). which I've made my default CSV app. It is the fastest way for me to peek at csv files.
I'd really love for it to have simple query mechanism by automatically creating an sqlite table in-memory for every csv improrted.