Bzlmod: (feature request) `go_deps` new tag `overrides_from_file`

[tyler-french]

Currently, Uber's MODULE.bazel file has 40+ overrides, and this number will only grow. The proposal is this: allow overrides to be specified in file(s):

e.g:

go_deps.overrides_from_file(
   "//:go_deps_automatic_overrides.json",
   "//:go_deps_manual_overrides.json",
)

Currently, code reviewer ability in our codebase is based on file location. Having different overrides in different locations will allow more automation around pruning/adjusting overrides, while also spreading the responsibilities for review to different users and groups.

[fmeum]

We definitely need something like this, but I think the result would be much better if it was a universal mechanism. Could you add a comment on https://github.com/bazelbuild/bazel/issues/17880 to revive the discussion there?