🔗 Why I keep business logic out of SQL

Should I default to pushing logic into the database—using views, procedures, functions—or should I default to keeping logic inside the application code (including SQL statements)?

It has been a long-discussedtopic, though less so in the last 15 years. It seems that common wisdom has largely settled.

TL;DR

I tend to keep as much of my code inside the application as possible and treat the DB as a dumb data store—with as little logic there as is reasonably possible.