I wouldn't frown upon it, and would be surprised if the vast majority of apps didn't use app level segregation.

At some level of complexity SQL gets hard to migrate, upgrade, switch vendors and even cloud providers