Procedural SQL allows developers to create reusable recipes with multiple instructions to manipulate, transform, read, and write data. This language is implemented by various database servers and virtualization software, including CData Virtuality, Oracle, and MS SQL. Stored procedures can be used to automate tasks such as onboarding new clients, creating requests using Adobe Analytics, updating data lakes, converting data to HTML tables, and implementing functions from other SQL dialects. They can accept parameters, return data, and be used in queries as if they were tables. With their ability to create temporary tables, control logic, and perform various operations, stored procedures are a powerful tool for harnessing the power of data virtualization.