Stored procedures are fine so long as they are:
1. precompiled.
2. Do not contain business rules.
From: graycat<-nathanday at 06/02/23 09:13:11 on wss://relay.damus.io
CC: #[4]
>---------------
>What about stored procedures?
Discussion
In my experience with several ORMs, it’s not always easy to predict the SQL that gets generated, and sometimes it turns out to be inefficient. Better to just ask an SQL stored procedure to do the work, especially since it’s right there where the data are located.