See this for more info, now that the feature is officially in preview.
https://cloud.google.com/bigquery/docs/reference/standard-sql/pipe-syntax
(It was a bug that the error message appeared earlier.)