Allow SQLite query results to be saved and shared between cells (like for SQLServer)
First I want to say that polyglot notebooks are fantastic including all the extensions. I also love support for SQLite as it is very useful when prototyping SQL schemas and queries. It would be even more awesome if the results of a query could be saved and shared with other cells just like the SQLServer extensions does. So ideally we could write:
#!connect sqlite --kernel-name moviedb "Data Source=movies.db"
#!sql-moviedb --name movies SELECT * FROM MOVIE
#!share --from sql-moviedb movies movies
// then we could iterate over the rows from the movies variable.
You guys have too much work to do! Here is a similar situation in the Jupyter notebook:
Error: (1,24): error DNI103: Unrecognized parameter name '--name'
Full notebook: https://github.com/BryanWilhite/jupyter-central/blob/main/polyglot-notebooks/sqlite-tabular-data-resource.ipynb 📓