I don’t really know what you mean by that.
Stored procedures on a database server. You can design them so that you just pass parameters to execute SQL statements instead of having in-line sql. MySQL Stored Procedure - w3resource
I only use SQLite so there is no server. I can see they might make sense for mySQL and the like.