Feature Request: Execute Python from within %%sql cell

[wbrguerra]

Hi there! 👋 First off, thanks so much for all the work everyone's put into this project. I wanted to suggest a feature that I think could be a great addition and would enhance the experience for other users as well: adding the ability to execute Python from within a %%sql cell.

To show how this might work, the Kqlmagic extension has a --py feature, which is different from the builtin %%python cell magic as it runs in the user's name space. If the last statement is an expression, it returns its value. Here's further documentation on that. The activate_kernel_command.py module gives an idea on how it might be implemented.