And how many coders need access?
Sps can "hide" the complexity of the under lying table/function which in turn can be a win, allowing the "lesser" coders to have functionality that they wouldn't otherwise have. Same trade-off as centralized library functions. Blanket statements such as this points to a troubling dogma.
Bottom line: most coders should not have to think about all the ins and outs of data integrity, they simply need the job done, and a centralized access path makes it safer.
Sps can "hide" the complexity of the under lying table/function which in turn can be a win, allowing the "lesser" coders to have functionality that they wouldn't otherwise have. Same trade-off as centralized library functions. Blanket statements such as this points to a troubling dogma.
Bottom line: most coders should not have to think about all the ins and outs of data integrity, they simply need the job done, and a centralized access path makes it safer.