You can persuade selectall_arrayref to return an arrayref of hashrefs using the { Slice => {} } trick as described in the DBI manual.

(edit) selectall_arrayref returns an arrayref, not an array :)