in reply to How to use the 'in' of SQL using Class::DBI

Class::DBI::AbstractSearch and Class::DBI::Sweet should let you use -in, as in this untested bit: 
    MyClass->search_where({ col1 => { -in => \@items }})

[download]
Hope this helps.

In Section Seekers of Perl Wisdom