Bottom line: Portability ... Not all DBMS support stored Procs ... and when they do, it's in a different manner.
SProcs need to be managed and maintain some where - and then the scripts need to be executed for any updates.
Builders ... it's self contained and you just have to upload the new file for changes. It also makes it trivial to move from one db to another, or from one dbms to another ...