Recursive CTEs in BigQuery

Amazingly well-explained! Although, wouldn't you agree that graph databases are more suited for such use cases? What are your thoughts on that?

Thanks Shreyan Das!

Most of the time, this usecase is only a small part of the bigger data pipeline (say you'd need to work out the company hierarchy and who reports to whom). Otherwise if your entire application is centered on graph semantics, yes probably need to look at a specialized solution.