Обсуждение: stored procedures

Depends on the script but possibly a matter of copy-paste for the simplest.

Advantages: The script is on the server, can require permissions, has a name (I suppose a script file does too...).  Easier to deal with input parameters.  Fewer components involved.  Usable by components that can't issue SQL directly - e.g., GraphQL mutations.

Disadvantages: Changing the script is now a formal migration for the database instead of an application update.

David J.