The other issue, from experience, is needing to reimplement logic as well -- you end up with stored procedures that duplicate logic that also must be run either in your server or on your client. eg given the state of the system, is this mutation valid.

Then those multiple implementations inevitably suffer different bugs and drift, leading to really ugly bugs.