my $query = q(select * from foo);
my $sth = $dbh->prepare_cached($query);
print Dumper $sth->fetchall_arrayref({});