my $sth = $dbh->prepare($query);

$sth->execute();
my $records = $sth->fetchall_arrayref({});
#        notice an empty hashref here ^