$stmt = 'SELECT Field1, Field2 FROM Table';
$href = { map { @$_ } @{$dbh->selectall_arrayref($stmt)} };

# Returns:
# $href = {
#    Row1Field1 => Row1Field2,
#    Row2Field1 => Row2Field2,
#    ...
# };