I think the devs have learnt this the hard way. it's not about what's technically correct or possible, It is more about getting 10 layers of permissions and signatures from higher ups before you can add or modify a stored procedure. Try doing that in a 2 week sprint and you will never touch stored procs again.