my $sth = 
$dbh->prepare('select * from foo where foo = $1 and bar in ($2)');
$sth->execute(1, [1,2,3]);