The $4,000 COALESCE: When a BigQuery Date Filter Quietly Does Nothing

How one CTE turned every query against a view into a 1.21 TB scan — and the rewrite that cut it to 46 GB.