Further to answers above, you can add LIMIT functionality to your queries with the following:

• Class::DBI::Search::LIMITed
• Class::DBI::Sweet