my $result = $db->query('SELECT * FROM shop_items');
while (my $row = $result->hash) {
    ...
}

##</code><code>##

for my $row ($db->query('SELECT * FROM shop_items')->hashes) {
    ...
}