Comment on Q – Run SQL Directly on CSV or TSV FilesComments−fdik11yOn Windoze, ADO lets you use SQL directly on any data source for many years now, including CSV, TSV, Exchange Microsoft, and many more.Here's a sample how this can be done: http://fdik.org/ado.zipSuch database middleware is missing on many other platforms. Could be an option to think about it.−CHY87211yPostgres can do it. https://wiki.postgresql.org/wiki/Foreign_data_wrappers
Comments
On Windoze, ADO lets you use SQL directly on any data source for many years now, including CSV, TSV, Exchange Microsoft, and many more.
Here's a sample how this can be done: http://fdik.org/ado.zip
Such database middleware is missing on many other platforms. Could be an option to think about it.
Postgres can do it. https://wiki.postgresql.org/wiki/Foreign_data_wrappers