You might also want to check the DBIx::Recordset module. Shortly, the good thing with it is that you don't have to have so much SQL code in your scripts when accessing recordsets. You can find the doc
here and look it up on CPAN. The module was a good help for my mySQL + Perl work.