Another vote for Stored Procedures. There are times when the SQL is dynamic enough to be done "better" from another tier, but when the parameters and output are known and consistent, Procedures are always my choice. My personal preference (I think this is also what you hinted, jpipes) is to keep the source procedure code in files maintained by a source code control system and NOT edit them directly through EM.

Guarddata-