With Class::DBI, you can fetch an entire table using the retrieve_all method. In scalar context, it will give you an iterator which basically does what the DBI "fetchrow_*" methods do. For example:

my $iterator = Class->retrieve_all;
while(my $item = $iterator->next) { 
    print $item->some_field, "\n";
}
[download]

Update: Added newline to print.