Several different #standardSQL queries generates errors:
for example:
'#standardSQL
select …
TIMESTAMP_TRUNC(ts_event , week) as week
(rest of query here which does work in BQ console)
generates an error :
3.17 - 3.35: Unrecognized function timestamp_trunc
Also, this type query:
'#standardSQL
with list as
(SELECT … (rest of valid standardSQL query here)
generates: Encountered " “WITH” "with “” at line 4, column 1. Was expecting: