Use override to "unrequire" or remove a downstream dependency

[allen-pattern]

We can currently use overrides to make the version required of a dependency of a dependency more permissive. It would be nice to be able to blacklist one entirely.

[zanieb]

Hi!

This is a duplicate of #4422 which includes a solution using overrides to remove dependencies.