With the exception of data.table (which has a painful API), anything else in R will be much slower. https://duckdblabs.github.io/db-benchmark/