my @result;
while (my $row = $sth->fetchrow_hashref()) {
    push @result, $row;
}