Enable pylance in %%python3 and %%mypy cells

[Josverl]

I was able to implement this functionality using an input transformer to remove/cleanup the # before Pylance gets at it.
for reference: #13327

def load_ipython_extension(ipython: InteractiveShell):
    # register the input transformer to allow %%cell_magics in comments
    ipython.input_transformers_cleanup.append(comment_magic_transformer)

# ...
import re

re_comment_magic = r"#[ |\t|!]*%%((micropython|python|mypy|script))"
# Regex to match a comment magic, e.g. `# %%micropython
subst = r"%%\g<1>"
# replace with all but the comment & whitespace 

def comment_magic_transformer(lines: list[str]):
    """
    Transforms a cell with a commented cell magic into a cell without the comment, but with the %%celmagic.
    `# %%micropython` --> `%%micropython`
    This allows Pylance to only see python code and not the magic, 
    which would otherwise confuse it, and cause it to be disabled.
    """
    if "%%" not in lines[0]:
        return lines
    return [re.sub(re_comment_magic, subst, lines[0])] + lines[1:]

Result :

This depends-on the fact that Pylance is (currently) not smart enough to do the same , and also fixes the same problem for the %%pythonX magics