# @ins is actually calculated at runtime. 
# Defined here for demonstration.
my @ins = qw(1 2 3 4 5 6);
my $in = join ',', map { "?" } @ins;
my $sth = $dbh->prepare("SELECT foo FROM Bar WHERE baz IN ( $in )");
$sth->execute( @ins );