I'm learning BigQuery standard SQL at the moment.
I've followed the examples of how you flatten data with legacy SQL, here and here.
It makes sense that flattening data generates stacked data with similar rows.
However, in the documentation which describes moving from Legacy SQL to Standard SQL, it describes how to do an identical flatten operation. The sub-heading for this is called Removing Repitition with Flatten.
Could someone explain that to me? It seems like flatten generates repetition of data by turning nested data into stacked data and I feel like I'm not understanding something basic.