I'm trying to Replace the schema in existing table using BQ. There are certain fields in BQ which have 3-5 level schema dependency. 
For Ex. comsalesorders.comSalesOrdersInfo.storetransactionid this field is nested under two fields.
Since I'm using this to replace existing table, I can not change the field names in query.
The query looks similar to this

```
SELECT * REPLACE(comsalesorders.comSalesOrdersInfo.storetransactionid AS STRING) FROM CentralizedOrders_streaming.orderStatusUpdated, UNNEST(comsalesorders) AS comsalesorders, UNNEST(comsalesorders.comSalesOrdersInfo) AS comsalesorders.comSalesOrdersInfo

```

BQ enables unnesting first schema field but presents problem for 2nd nesting. 
What changes do I need to make to this query to use UNNEST() for such depedndent schemas ?