BigQuery is an analytics engine optimized to crunch pre-joined (or: nested) data. Sub-relations make sense in analytical scenarios because we don’t wish to take care of joins over larger datasets — just imagine every day year-over-year comparisons over the past 3 years, aggregating Terabytes of knowledge — but with joins adding one other layer of…