The grid (core) ยท console.warn
this DuckDB connection has no prepare(), so ...
Printed by The grid (core), prefixed [lattice], since 1.51.0.
Warnings reference › source.duckdb.unprepared
- Identifier
source.duckdb.unprepared- Raised by
- The grid (core)
- Since
- 1.51.0
What happened
Filter values are bound as parameters, never interpolated into SQL text - that is what keeps a value containing a quote from becoming an injection. This connection cannot prepare statements, so the filtered query was not sent at all and no rows are returned.
The fix
Use a connection that implements prepare(). Every supported DuckDB-WASM build does.
Reference
Covered in full at the API reference.