It's only avoidable to the degree that your software architecture and company architecture allow you to make the more efficient decision to move the logic upstr

It's only avoidable to the degree that your software architecture and company architecture allow you to make the more efficient decision to move the logic upstream. The cases where this pattern emerges are invariably because someone without insufficient access to the DB and its configuration bites the bullet and instead builds whatever they need to do it in the environment they have complete access to. I've similar problems lead to dead cycles in processor design where the impact is critical. These problems aren't software technology problems. They're people coordination problems.