my $sql = 'SELECT * FROM table WHERE column IN (' . ( join ',', map { "'$_'" } @array ) . ')';