In addition to other methods suggested, I'm also working on DBIx::Pretty, a way to move non-abstracted SQL statements to a single location in a large piece of code. It is by no means a finished product, but you get the idea for cleaning DBI up. (The idea came out of the recent Leashing DBI thread, if you are interested for more). DBIx::Pretty is similar in nature to what you have (a hash of SQL), with some additional benefits (cleaner calls, additional variable replacement abilities above/beyond what DBI offers).

---

Dr. Michael K. Neylon - mneylon-pm@masemware.com || "You've left the lens cap of your mind on again, Pinky" - The Brain