Export DuckDB
MarkyMan4 opened this issue · 1 comments
filequery loads files and creates an in-memory DuckDB database. There is also nothing stopping users from creating their own objects within this database since there are no restrictions on the SQL they can execute. Provide a way for the in memory database to be written out to a file so users can save it for later use.
Once a database has been created in memory, it is not possible to export it as a single duckdb file. The export statement in duckdb creates SQL and data files that can be used to reconstruct the database, but this is not the functionality I want here.
Instead, I may allow users to pass an argument to inform filequery that it should create the database as a persistent file right away instead of creating it in memory.