migrating-from-legacy-sql?hl=JA

For more information about the GoogleSQL type system, see the GoogleSQL data types reference. For more information about data types in BigQuery, see the BigQuery data types reference. TIMESTAMP differences GoogleSQL has a stricter range of valid TIMESTAMP values than legacy SQL does. In GoogleSQL, valid TIMESTAMP values are in the range of 0001-01-01 00:00:00.000000 to 9999-12-31 23:59:59.999999.

[gam-22]

“標準 SQL にはレガシー SQL のように FLATTEN 関数がありませんが、JOIN（カンマ）演算子を使用して類似のセマンティクスを実現できます。”

[ymm1x]

LegacySQL -> StandardSQL

[monry84]

BigQuery に於ける Legacy SQL と Standard SQL の違い