In WinVector/rquery: Relational Query Generator for Data Manipulation at Scale

library("dplyr")
my_db <- DBI::dbConnect(RSQLite::SQLite(),
                        ":memory:")
dLocal <- data.frame(x = c(1,2))
dRemote <- dplyr::copy_to(my_db, dLocal, "dRemote")


dRemote %>% mutate(x = x + 1) %>% compute() %>% show_query()

dRemote %>% mutate(x = x + 1) %>% compute() %>% dbplyr::remote_query()


DBI::dbDisconnect(my_db)

WinVector/rquery documentation built on Aug. 24, 2023, 11:12 a.m.