These functions are useful for testing SQL generation without having to have an active database connection.

simulate_dbi()

simulate_sqlite()

simulate_postgres()

simulate_mysql()

simulate_odbc(type = NULL)

simulate_impala()

simulate_mssql()

simulate_oracle()

simulate_hive()

simulate_odbc_postgresql()

simulate_teradata()

simulate_odbc_access()

tbl_lazy(df, src = NULL)

lazy_frame(..., src = NULL)

Examples

library(dplyr) df <- data.frame(x = 1, y = 2) df_sqlite <- tbl_lazy(df, src = simulate_sqlite()) df_sqlite %>% summarise(x = sd(x)) %>% show_query()
#> Warning: Missing values are always removed in SQL. #> Use `STDEV(x, na.rm = TRUE)` to silence this warning
#> <SQL> SELECT STDEV(`x`) AS `x` #> FROM `df`