Store output of %%sql cells in a dataframe either via magic command or in a standard data frame

[jatatze]

It would be amazing to be able to store the output of a %%sql cell in a dataframe to work with it in pyspark. Either it should be stored in an intermediate data frame _dfsql or %%sql should have an option to define an output dataframe like the %capture command has %capture [--no-stderr] [--no-stdout] [--no-display] [output]