Embed Notice

@evan I have been in a situation where stored procedures were established by the DBA and consumers of the database used them like an API, so in that case, or if I was intending to provide this kind of "API", then yes. But if I'm developing software and I'm in control of the database, then no.

I find it's a bad code smell if a particular query occurs in more than one place in your app. So using this metric, stored procedures are an unnecessary level of indirection that can lead to obfuscation.