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.
simulate_dbi()
tbl_lazy(df, con = simulate_dbi(), src = NULL)lazy_frame(..., con = simulate_dbi(), src = NULL)
lazy_frame(..., con = simulate_dbi(), src = NULL)
# NOT RUN { 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() # }
Run the code above in your browser using DataCamp Workspace