You want selectall_arrayref:

$sql = "select * from table limit 10";
$rows = $db->selectall_arrayref( $sql, { Slice => {} } );

foreach my $row ( @$rows ) {
  print $row->{id}, "\n";
}
[download]