I see the way to move from python to sql is to create a temp view, and then access that dataframe from sql, and in a sql cell.
Now the question is, how can I have a %sql cell with a select statement in it, and assign the result of that statement to ...