Using UNION vs UNION ALL in Recursive CTEs: When to Make a Difference in Database Performance and Readability.

BigQuery Recursive Queries: A Deep Dive into Using Recursion to Get All Children of a Node