Parameters

How a query reads a value that a reader supplies, on Snowflake and on DuckDB.

Warehouse	Placeholder	Example
Snowflake	`:name`	`KATER__IS_ONE_OF(union__campaign_name, :campaign_name)`
DuckDB	`$name`. DuckDB also reads `:name`, and the formatter writes `$name`.	`KATER__IS_ONE_OF(region, $is_one_of__region)`

Hand-written SQL reads a range as :period[0] and :period[1], and a list as IN (:regions). Only workspace roots and queries declare parameters.