# based on the usual DBIC example tables
my @ids = (1..4);
my $rs = $schema->resultset('Cd')
  ->search({ cd_id => \@ids });
warn "query: ", ${$rs->as_query()}->[0], "\n";

$rs = $schema->resultset('Cd')
  ->search({ cd_id => { in => \@ids } });
warn "query: ", ${$rs->as_query()}->[0], "\n";

__END__
query: (SELECT me.cdid, me.artistid, me.title, me.year FROM cd me WHERE ( ( cd_id = ? OR cd_id = ? OR cd_id = ? OR cd_id = ? ) ))
query: (SELECT me.cdid, me.artistid, me.title, me.year FROM cd me WHERE ( cd_id IN ( ?, ?, ?, ? ) ))