Hi,
> In other words an API in the database.
+1. People code apps and then disappear, because once the development is over they are not available in the company any more. And each thing you hardwire in the app becomes a stopper. Meanwhile, every company will have at least one DBA, who can manage/upgrade stuff in the DB. This is especially true now that most stuff gets done for phones, and each phone family needs the same stuff to be redeveloped and maintained over and over again, with an extremely huge risk of inconsistent behaviours.
Coding in the app is simply not cost-effective.
My 2 p.
Bèrto