[R]: add support to the new dplyr verb filter_out

[larry77]

Describe the enhancement requested

Dplyr 1.2 introduced a new filter_out verb

https://dplyr.tidyverse.org/reference/filter.html

It would be excellent to have it among the list of support verbs in the R package, see https://arrow.apache.org/docs/r/reference/acero.html#dplyr-verbs

Component(s)

R

[thisisnic]

Hi @larry77, would you be interested in submitting a PR?

[larry77]

I may give it a try. Nothing against it in principle, but I doubt my R and C++ are up to the task

[thisisnic]

I may give it a try. Nothing against it in principle, but I doubt my R and C++ are up to the task

Thanks! No pressure, and happy to help anywhere I can, just tag me on a draft PR if you need. You won't need any C++ - it will mostly likely just be doable in R. I'll find links to places in the code, but if it seems like a pain, absolutely no worries either!

[thisisnic]

It'll require additions to these files:

• https://github.com/apache/arrow/blob/main/r/R/dplyr-filter.R
• https://github.com/apache/arrow/blob/main/r/tests/testthat/test-dplyr-filter.R

My first guess would be to update set_filters() to have another argument, something like exclude with a default value of FALSE, and then if it's set to TRUE, change how new_filter is defined.

[larry77]

Hello,
See

#49256