I work as data engineer and won't advise using stored procedures.

It's pain to debug and document.