Add a db_to_parquet() function?

[iangow]

I find that I increasingly use DuckDB with dbplyr and parquet for persistence. In the development version of my R package farr, I recently added a function duckdb_to_parquet() that implements this idea (source code here).

Basically, I can pass a lazy query object to the function and it will save it as a parquet file. Very slick.

I have a little note demonstrating use of this function here (see pages 8 and 9).
Maybe something similar would make sense for the duckdb R package. (Note that the schema argument to my function may not make sense, I use this to organize my parquet files so that I can use them much like I would use a PostgreSQL database.)