Allow running multiple statements in single cell about xeus-sql HOT 1 OPEN

Hey @emredjan, thanks for opening the issue!
Addressing your second issue:
xeus-sql depends on the chain of the sql command being valid for it to run. The only distinction we have on the xeus-sql side for sql code is if it has a rich display output (tables and graphs) or not. So, I'm not very knowledgeable in sql sorry, but I'd say this is not a valid command to put up in a chain and that's why it's not working. I don't think there's a super easy way to fix this since it's coming from upstream SOCI. Unless there's only a few use cases where something like this happens, then we could maybe create an if and treat it differently.
Regarding your first issue... I think it falls into the same category of it's not a "chainable" command and that's why it doesn't run. But since this use case doesn't work at all, it'd be good if we could find a solution, but none of the things I'm thinking now are simple to do.
Maybe we could have a kind of cache tool... to store variable values. But I think the retrieving system for these would be very complicated.
Maybe the best solution would be transforming everything that stores values in to magic commands? The CRTP syntax parser logic for the xvega stuff could be easily reused for this. I can expand on this if folks are interested in contributing, in the moment I can't really spend so much time on this project.
Other than that, I really don't know how this could be fixed.
Everyone is welcome to chime in! With ideas or code! I will gladly review PRs and help as much as I can :)

from xeus-sql.