SQLGlot is a no-dependency SQL parser, transpiler, optimizer, and engine. It can be used to format SQL or translate between 24 different dialects like DuckDB, Presto / Trino, Spark / Databricks, ...
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, ...