Yup, that's it. So, just for everyone else... this is what the modified code would look like. Much more concise, which is exactly what I was looking for. Thanks!
my $query = qq~
SELECT *
FROM my_table
~;
my $res = $dbh->selectall_arrayref($query, { Slice => {} } );