Stored procedures have been a staple of RDBMS for ages, predating the cloud era and dedicated transformation tools. They have played a crucial role in building data pipelines and automating databases.