Editable, executble SQL queries (with Duckdb)

[tomkom]

Description

I would like to create a document enabling to query a database, dynamically. I am able to create a document that computes the answers to a SQL query, and renders the document ( using quarto render + preview)

---
title: "SQL Project"
format: html
---

```{r}
library(DBI)
library(duckdb)
con <- dbConnect(duckdb(), dbdir = ":memory:")
```

I access a web-served pqrquet here as example of data
```{sql}
#| label: get-carriers
#| connection: con
#| execute: true
SELECT species,
          AVG(bill_length_mm) AS avg_bill_length,
          AVG(bill_depth_mm) AS avg_bill_depth
   FROM PARQUET_SCAN('https://francoismichonneau.net/assets/data/penguins.parquet')
   GROUP BY species;
```

I would like to turn the SQL cell to be editable by the user, to run modified SQL queries against the table (or even a loaded database, I was considering sharing it in quarto resources.

The key is to hide any necessary R or Python or JS code ( I do not care for the solution, but I am not fluent in JS/Observable) , so the users can see syntax-highlighted SQL code only in the cell, and execute it. Is this possible?

[mcanouil]

Computations are static. A document does not rely on a server, thus what you want is not possible the way you want it.

What is possible is to evaluate code live using WASM which execute R/Python in the browser.

• https://github.com/r-wasm/quarto-live

But this won't modify the rendered document. It'll only show the output of a code cell, so you cannot emit Markdown and have it translated to HTML by Quarto for example.

[tomkom]

Indeed, wasm is what I thought will be needed. Thank you. Now I need to figure out how to work with quarto-live, I was not aware of this as a standalone project. Any example of quarto-live working with duckdb-wasm would be appreciated.

…

On Thu, Sep 4, 2025 at 4:34 PM Mickaël Canouil ***@***.***> wrote: Computations are static. A document does not rely on a server, thus what you want is not possible the way you want it. What is possible is to evaluate code live using WASM which execute R/Python in the browser. - https://github.com/r-wasm/quarto-live — Reply to this email directly, view it on GitHub <#13328 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AALLGHQQ6XMI74AWNIYLB733Q7MQ3AVCNFSM6AAAAACFSEHXX2VHI2DSMVQWIX3LMV43URDJONRXK43TNFXW4Q3PNVWWK3TUHMYTIMZQGM2TSMI> . You are receiving this because you authored the thread.Message ID: ***@***.*** com>

[mcanouil]

Look at the extension documentation. Quite some effort has been spent on it by the author.