my $sql = 'SELECT * FROM table WHERE column IN (' . '?' . (',?' x $#array) . ')';