my @items = qw(ABC1 EFG2 IJK3);
my $cond  = join ' OR ', ('item_id = ?') x scalar @items;
$dbh->selectall_arrayref( # or whatever
  "SELECT * FROM catalog WHERE $cond",
  undef,
  @items);