Wren core transform SQL failed Unexpected keyword UNNEST

[grieve54706]

Source

SELECT array_agg(x) FROM UNNEST([2, 1,-2, 3, -2, 1, 2]) AS t(x)

Planned

SELECT array_agg(t.x) FROM (SELECT UNNEST([2, 1, -2, 3, -2, 1, 2]) AS "UNNEST(make_array(Int64(2),Int64(1),Int64(-2),Int64(3),Int64(-2),Int64(1),Int64(2)))") AS t (x)

Dialect

SELECT ARRAY_AGG(t.x) FROM (SELECT UNNEST([2, 1, -2, 3, -2, 1, 2]) AS `UNNEST(make_array(Int64(2),Int64(1),Int64(-2),Int64(3),Int64(-2),Int64(1),Int64(2)))`) AS t

BigQuery error message

google.api_core.exceptions.BadRequest: 400 POST https://bigquery.googleapis.com/bigquery/v2/projects/wrenai/jobs?prettyPrint=false: Syntax error: Unexpected keyword UNNEST at [1:36]

We found the Wren core transform SQL to SELECT UNNEST from SELECT * FROM UNNEST.
But the BigQuery can not receive the statement SELECT UNNEST

[goldmedal]

related to apache/datafusion#13601