I am currently using the fst r package to read and write data, it is fast and memory-economical. I was wondering if DBI::dbWriteTable could support reading local fst format data. That would be very convenient for working with large local data.
I haven't gone through the DBI documentation/repo carefully to see if this has already discussed anywhere, but (if you don't get feedback here) you might consider submitting this as a feature request in the DBI GitHub repo.