Refer to existing object inside sqlQuery

[martin.R]

I cannot remember where I first found out about it, but this post has an example:

dbplyr/dplyr filter worked fine in R 3.5.1 but fails in R 3.6.0 using %in% in database query

Given: > procedureIDs$ProcedureID [1] 8607 8608 Does anyone have any ideas about why does this filter construct worked fine in R 3.5.1 From a somewhat complicated dbplyr/dplyr statement querying an MS SQL database: … %>% filter(PROCEDURE_ID %in% procedureIDs$ProcedureID) %>% … But gives this error message in R 3.6.0? Error in UseMethod("escape") : no applicable method for 'escape' applied to an object of class "c('tbl_df', 'tbl', 'data.frame')" 36. escape(val, con = con) 35. .f(.x[[i]], ...) 34. purrr::map_chr(enexprs(...), escape_expr, con = con) 33. build_sql(x, sql(f), y) . . .