Think this issue was fixed a few years ago

Not sure I agree, when I use brew it still regularly updates random unconnected crap through multiple major releases. And of course it takes ages doing so

I was referring to your postgresql example, those became rudimentary @versioned packages