my $sql = "SELECT foo FROM Bar WHERE 1=1";
my @bind;
$sql .= " AND baz in ( " . join(',', map {'?'} @ins) . ") ";
push @bind, @ins;
$dbh->selectall_arrayref($sql, {}, @bind);