go/adbc: macOS builds need to link libresolv

[lidavidm]

https://github.com/golang/go/issues/58159, https://github.com/golang/go/issues/58416

Only affects macOS, Go 1.20+. It looks like our R CI jobs don't explicitly install Go and so just pick up Go from the base image, so that would explain it (our other jobs explicitly install Go 1.18).

Causes issues like this:

❯ checking dependencies in R code ... NOTE
  Error: unable to load shared object '/Users/runner/work/arrow-adbc/arrow-adbc/r/adbcsnowflake/check/adbcsnowflake.Rcheck/adbcsnowflake/libs/adbcsnowflake.so':
    dlopen(/Users/runner/work/arrow-adbc/arrow-adbc/r/adbcsnowflake/check/adbcsnowflake.Rcheck/adbcsnowflake/libs/adbcsnowflake.so, 0x0006): symbol not found in flat namespace (_res_9_nclose)
  Call sequence:
  3: dyn.load(file, DLLpath = DLLpath, ...)
  2: library.dynam(lib, package, package.lib)
  1: loadNamespace(package, lib.loc)
  Execution halted

[paleolimbot]

I ran into this when building documentation using docker compose run docs on Ubuntu, so it may not be specific to MacOS. This was updated/maybe fixed in the R documentation PR ( https://github.com/apache/arrow-adbc/pull/977/files#diff-fdf92781420c6b0ea091d62c80657009e21923c0651955f0aa4c7f4636495640 ) but I'm surprised that it was an issue on MacOS so perhaps there is something else going on.

[lidavidm]

The linked issues show that it's related to a Go-side change, and not all our pipelines pinned the Go version, so I think that explains it.