Class::dbi::plugin::pager adds a pager method that can query using sql::abstract where clauses, and limit the number of rows returned to a specific subset.