1. A processor-implemented method for deploying a structured query language procedure comprising a procedural logic component and a database request component from a source system to a target system, the method comprising: generating a query procedure source code, a symbol table, and encapsulated optimization results upon creation of the query procedure, to regenerate run-time instructions for one or more query statements of the database request component, and to allow the query statements to function with a deployed internal representation of the procedural logic component; maintaining an association between the procedural logic component and the database request component during deployment; copying an internal representation of the procedural logic component to the target system without regeneration; regenerating the database request component to recreate the query procedure on the target system, and to maintain a consistent interface between the procedural logic component and database request component.