SELECT foo FROM bar WHERE id IN (
  SELECT id FROM baz WHERE a = b
)

##</code><code>##

my @integers = map { int } @list;
my $sth->prepare("
  SELECT foo FROM bar 
  WHERE id IN (".join(',',@integers).")
");