The unnest syntax cannot be converted correctly, related to starrocks and bigquery. In my case, I need to convert cross join unnest to LATERAL VIEW EXPLODE. The following sql: -- sql1 SELECT id, ...