http://www.perlmonks.org?node_id=31753

eak has asked for the wisdom of the Perl Monks concerning the following question:

Perl Monks,
I am running into the problem of copying and pasting sql statements throughout different scripts I am writing. I could just put each of these statements into a module and call them as methods, which would solve the problem of repeating code all over the place, but I don't like that approach much. What I am interested in is, how do most of you deal with a RDBMS. Do you try to create an object oriented wrapper to the DB? Do you just squirrel away SQL throughout your code? Ideally I would like to be able to create a create class from which I could request a number of columns and just forget about any of the joins that may have to occur. I have heard of Tangram and some of the other object persistence work done on CPAN, but I haven't heard much about their implementation. So, any thoughts, suggestions, or comments are welcome.

thanks,
eric