backend-sqlite {dbplyr} | R Documentation |
Backend: SQLite
Description
See vignette("translation-function")
and vignette("translation-verb")
for
details of overall translation technology. Key differences for this backend
are:
Uses non-standard
LOG()
functionDate-time extraction functions from lubridate
Custom median translation
Right and full joins are simulated using left joins
Use simulate_sqlite()
with lazy_frame()
to see simulated SQL without
converting to live access database.
Usage
simulate_sqlite()
Examples
library(dplyr, warn.conflicts = FALSE)
lf <- lazy_frame(a = TRUE, b = 1, c = 2, d = "z", con = simulate_sqlite())
lf %>% transmute(x = paste(c, " times"))
lf %>% transmute(x = log(b), y = log(b, base = 2))
[Package dbplyr version 2.5.0 Index]