[Feature Request] Direct exploration of CSV file.

[abdullahdevrel]

AFAIK, the way to explore a CSV file in Datasette involves an intermediate step of first converting the CSV file to an SQLite database file. For example:

csvs-to-sqlite ipinfo_nordicvm.csv ipinfo_nordicvm.db
datasette ipinfo_nordicvm.db

Even though this step seems inconsequential, I wonder if directly reading the CSV file would be an option. It would:

• Reduce the need to write one more line of code
• Reduce the need to store an additional file in storage
• Facilitate efficient querying by storing the file in memory
• Alternatively, instead of storing the file in memory, the SQLite db can be stored in a temp file that will be automatically deleted upon closing the Datasette instance.