For writing functions that use dplyr/DBI interface:
con <- DBI::dbConnect(RSQLite::SQLite(), ":memory:")
DBI::dbWriteTable(con, "mtcars", mtcars)
filterFun <- function(db, tab, col, val){
col <- rlang::enquo(col)
tbl(db, tab) %>%
filter(!!col > val) %>%
collect
}
filterFun(db = con,
tab = "mtcars",
col = cyl,
val = 4)