# BUILDING MAPS (also fetching all in one go)

my $customers =
    $db
    -> query('SELECT id, name, location FROM people')
    -> map_hashes('id');
    # $customers is { $id => { name => $name, location => $location }, ... }

my $customers =
    $db
    -> query('SELECT id, name, location FROM people')
    -> map_arrays(0);
    # $customers is { $id => [ $name, $location ], ... }

my $names =
    $db
    -> query('SELECT id, name FROM people')
    -> map;
    # $names is { $id => $name, ... }