perf: Use CTEs more aggressively for smaller sql#1883

TrevorBergeron wants to merge 2 commits intomaingoogleapis/python-bigquery-dataframes:mainfrom

cte_extractgoogleapis/python-bigquery-dataframes:cte_extractCopy head branch name to clipboard