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

 # Fetch rows as arrayrefs
 my $rows_as_arrayrefs = $sth->fetchall_arrayref;

 # OR fetch all rows as hashrefs
 my $rows_as_hashrefs  = $sth->fetchall_arrayref( {} );