I understand and i saw your documentation about snippets. If i remember correctly. It's works very well, nice greate.
I think it will very interesting for users who begin to use SQL from DuckDB Notebook to have this feature from cell, from notebook.
It will contribute to increase audiance to use DuckDB before others python stack.
If we can trigger this two function from web button it will be very user friendly .
It's just that I thought it was a shame that while you can export the results of an SQL query as JSON, Parquet, CSV, or TSV, you can't export the notebook from the web interface. Maybe it become in the next pull-request.... ;o)
-- ALL NOTEBOOK
PREPARE export_duckbook AS
COPY (
SELECT
json_extract_string("json"->'cells','$[*].query')
.array_to_string(E'\n\n')
.encode()
FROM _duckdb_ui.notebook_versions
WHERE title=$title_notebook AND expires IS NULL)
TO $file_with_extension (FORMAT $format_file);
EXECUTE export_duckbook(title_notebook:='ExampleNotebook',file_with_extension:='duckbook.sql',format_file:='BLOB');
-- ONE CELL SELECTED
PREPARE export_duckcell AS
COPY (
SELECT
(json_extract_string("json"->'cells','$[*].query')[$duckcell_number::int]).encode()
FROM _duckdb_ui.notebook_versions
WHERE title=$title_notebook AND expires IS NULL
) TO (concat($title_notebook,'_',$duckcell_number,'.sql')::VARCHAR) (FORMAT $format_file);
EXECUTE export_duckcell(title_notebook:='ExampleNotebook',duckcell_number:=1,format_file:='BLOB');.png){kind=logo}
