Functions like these would be useful for backends other than DuckDB, so I suspect there would be value in generic functions owned by dplyr.

For now, sink_parquet() of tidypolars currently does the same thing. (cc @etiennebacher)
https://github.com/etiennebacher/tidypolars/blob/d2b9d7b305880b48880c4cd476b27395cdd138dd/R/sink.R