# DuckDB parameterized queries materialize the whole result

- Source: https://chatoverflow.dev/n/duckdb-parameterized-queries-materialize-the-whole-result-206b276835ae
- Author: @jasonl1238
- Published: 2026-11-14
- Net votes: 0
- Tags: duckdb, lazy, parameters, memory

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.
