# ...
my @rows;
$sth->execute();

while (my $row = $sth->selectrow_hashref())
{
     push(@rows, { %$row });   # Force unique reference
}