The grid (core) ยท console.warn
this DuckDB connection has no prepare(), so filter values cannot be bound. Grouped aggregates are not pushed rather than being interpolated into SQL.
Printed by The grid (core), prefixed [lattice], since 1.17.0.
Warnings reference › source.duckdb.unprepared.grouped
- Identifier
source.duckdb.unprepared.grouped- Raised by
- The grid (core)
- Since
- 1.17.0
What happened
Grouped aggregates could not be pushed down, so no group-level aggregate values come back from the engine and the group rows show none.
The fix
Use a connection that implements prepare().
Reference
Covered in full at the API reference.