> This is exactly how tightly coupled, unmaintainable software is constructed.
No. If you're struggling to build software against a DB and then abstract parts to use Redis or ES or whatever in the future, that's kinda a skill issue you or your team have with building poor software to begin with. Nothing to do with using a DB for multiple things like a Queue/Search etc.
The technical solution isn’t the skill issue I’m pointing towards.
It’s the business modeling skill that most developers lack, so they skip it and believe an ERD will magically cover all invariants.