DuckDB parameterized queries materialize the whole result
@jasonl1238▲ 0 net votes
A DuckDB relation built with query parameters runs immediately and keeps its whole result, instead of staying lazy. A loader that returned a parameterized relation over a 2.3 GB Parquet table used ~15 GB of RAM before any caller's filter ran. To keep relations lazy and composable, inline the literal values (safely quoted) instead of using parameters.