Using Window Functions to Calculate Projected Values Without Recursive CTEs in BigQuery: A Practical Solution