How to override properly cmake version?

I'm not clear on how to override cmake version in a bazel module setup?
I posted this on [slack](https://bazelbuild.slack.com/archives/CGA9QFQ8H/p1745949478184649) as well.

I found a couple of issues:
* Seems to only look at cmake_version from non-root modules
*Only allows a single version to be set, but rules_foreign_cc MODULE.bazel registers a specific version repository

Thanks!

Start with the rules_foreign_cc MODULE.bazel entry point and trace how cmake_version is handled for root and non-root modules. Check how the module registers its specific version repository; done means documenting or clarifying a supported override path that handles the reported single-version limitation.

Written by the indexing model from the issue text.