Using qualified functions inside filter or arrange results in 'object not found' error for SQL

[janusvm]

For an SQL backend, using desc() or between() inside an arrange or filter, respectively, returns an error if the functions are qualified.

library(dplyr, warn.conflicts = FALSE)
library(dbplyr, warn.conflicts = FALSE)
lf <- dbplyr::lazy_frame(x = 1, y = 1, 
                         src = dbplyr::simulate_dbi())

# Works
lf %>% 
  arrange(desc(y)) %>% 
  show_query()
#> <SQL> SELECT *
#> FROM "df"
#> ORDER BY "y" DESC
lf %>% 
  filter(between(y, 0, 1)) %>% 
  show_query()
#> <SQL> SELECT *
#> FROM "df"
#> WHERE ("y" BETWEEN 0.0 AND 1.0)

# Doesn't work
lf %>% 
  dplyr::arrange(dplyr::desc(y)) %>% 
  dplyr::show_query()
#> Error in dplyr::desc(y): object 'y' not found
lf %>% 
  dplyr::filter(dplyr::between(y, 0, 1)) %>% 
  dplyr::show_query()
#> Error in dplyr::between(y, 0, 1): object 'y' not found

[ghost]

This issue was moved by batpigandme to tidyverse/dbplyr/issues/107.

[lock]

This old issue has been automatically locked. If you believe you have found a related problem, please file a new issue (with reprex) and link to this issue. https://reprex.tidyverse.org/