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