When working with large csv files, you're better off importing the file into a sqlite database if you want to perform more than one query.
Knowing the import is happening behind the scenes is useful when you hit performance problems with the tool.
Knowing the import is happening behind the scenes is useful when you hit performance problems with the tool.
But I managed to be able to "stream" results. When it didn't involve any GROUP BY, of course.
I guess that would spawn a nice side project, to rewrite it in a language to learn it ;-)