[R][CI] test-duckdb.R is failing on several nightly jobs

[raulcd]

Describe the bug, including details regarding any error messages, version, and platform.

There are several nightly jobs failing:

• test-r-depsource-bundled
• test-r-gcc-11
• test-r-gcc-12
• test-r-rhub-debian-gcc-release-custom-ccache
• test-r-rhub-ubuntu-gcc-release-latest
• test-r-rocker-r-ver-latest
• test-r-rstudio-r-base-4.1-opensuse153
• test-r-rstudio-r-base-4.2-centos7-devtoolset-8
• test-r-rstudio-r-base-4.2-focal
• test-r-versions

With the following error:

══ Failed tests ════════════════════════════════════════════════════════════════
── Error ('test-duckdb.R:286:5'): to_duckdb passing a connection ───────────────
Error in `unclass(unclass(table_four)$lazy_query$x)$table`: $ operator is invalid for atomic vectors

Component(s)

Continuous Integration, R

[raulcd]

cc @paleolimbot @assignUser

[paleolimbot]

I think there was a new version of duckdb ~last week (and maybe Posit Package Manager just picked up the update)...it could also be a dplyr or dbplyr update (we use non-public APIs of those to implement the duckdb connection).

[thisisnic]

Issue resolved by pull request 40710
#40710