These functions are useful for testing SQL generation without having to
have an active database connection. See simulate_dbi()
for a list
available database simulations.
Examples
library(dplyr)
df <- data.frame(x = 1, y = 2)
df_sqlite <- tbl_lazy(df, con = simulate_sqlite())
df_sqlite %>% summarise(x = sd(x, na.rm = TRUE)) %>% show_query()
#> <SQL>
#> SELECT STDEV(`x`) AS `x`
#> FROM `df`