my $sth = $dbh->selectall_arrayref('
   select id,title,year from movie limit 2
',{Slice => {}});

print Dumper $sth;

__END__
$VAR1 = [
          {
            'title' => 'Alien',
            'year' => '1979',
            'id' => '78748'
          },
          {
            'title' => 'Aliens',
            'year' => '1986',
            'id' => '90605'
          }
        ];