[R] [CI] A crossbow job that tests against DuckDB's dev branch

[asfimport]

It would be good to test against DuckDB's dev branch to warn us if there are impending changes that break something.

While we're doing this, we should clean up some of the Currently some of our jobs do already

arrow/ci/scripts/r_deps.sh

Lines 45 to 51 in f9f6fdb

	# (Temporarily) install DuckDB from source to avoid their Unity builds
	# (though only if we haven't filtered it out of the deps above,
	# and if we can't get a binary from RSPM)
	# Remove when there is a DuckDB release > 0.3.1-1
	if [ ${R_PRUNE_DEPS} != "true" ]; then
	${R_BIN} -e "if (all(!grepl('packagemanager.rstudio', options('repos')))) { remotes::install_github('duckdb/duckdb', subdir = '/tools/rpkg', build = FALSE) }"
	fi

We should clean this up so that generally builds use the released DuckDB, but we can toggle dev DuckDB (and run a separate build that uses the dev DuckDB optionally)

Reporter: Jonathan Keane / @jonkeane
Assignee: Jonathan Keane / @jonkeane

PRs and other links:

• GitHub Pull Request #12366

_{Note: This issue was originally created as ARROW-15468. Please see the migration documentation for further details.}

[asfimport]

Jonathan Keane / @jonkeane:
Issue resolved by pull request 12366
#12366