Is it maybe possible for you to model your data using Class::DBI derived classes? This way, you can avoid writing any SQL unless necessary, and you could just pass a couple objects to your templates.
Makeshifts last the longest.
Comment on Re^3: Tie-DBI fails tests under Perl 5.6.1 and Perl 5.8.0