Define sql connectors to live data

[Fil]

---
sql:
  mytable: ${a live expression}
---

[mbostock]

What is this? I don’t think we want this. It goes against static analysis. You can do this by manually declaring a DuckDBClient as shown in other issues but I’m pretty strongly opposed to putting reactive JavaScript expressions within front matter.

[Fil]

The idea is that sql fenced blocks are so great to use, I'm trying to find the shortest route to them from live data.

[mbostock]

Maybe then we should make this pattern more discoverable?

const db = await DuckDBClient.of({gaia: FileAttachment("./lib/gaia-sample.parquet")});
const sql = db.sql.bind(db);

Such as this:

const sql = DuckDBClient.sql({gaia: FileAttachment("./lib/gaia-sample.parquet")});

[Fil]

sounds like the 🚀 solution