[koirapoika]

I think you could also utilize 'Brewfile' with pinned versions, where needed, and the latest available for the rest. I manage my environment this way when migrating from one work laptop to another. Works fine so far.

Alternatively, you can create your own 'tap' to gain more control over some packages.

For databases, I'd stick to running them as containers, too.

Homebrew is not ideal, of course, but there are ways to achieve desired goals until we have something better.