Observable-Community

image.png

Here’s a small notebook that can be used to play around: <https://observablehq.com/d/9e77715734f37101>

Update: Found out it works as expected if I use the `db_initial.query()` syntax instead…

This is because the SQL cell uses SQL query parameterization, and the `.query()` version you are using embeds the value in the query string directly. I find it odd that DuckDB doesn't allow parameterization on views like that though...

I see! Thanks for the explanation <@U0484AHPADB>

By the way, you can match an SQL cell's behavior by using
```db_initial.query(...db_initial.queryTag`
select *
from foo
where foo.id in ${myInput}
`)```