my $rs = $schema->resultset('Events')->search(
  {},
  {
    select   => [ 'name', { max => 'event_id' } ],
    as       => [qw/ name max_event_id /],
    group_by => [qw/ name /]
  }
);