SQLMesh format converts SAFE_CAST to CAST

[z3z1ma]

This is not semantically the same operation. The issue will need to be resolved in sqlglot I imagine but posting here because of its relevance in SQLMesh given the format CLI command.

[tobymao]

@z3z1ma can you share the commands you used for this? i'm not seeing this behavior on sqlglot

q = parse_one("""
safe_cast(x as int64)
""", read="bigquery")


print(q.sql(dialect="bigquery", pretty=True))

[georgesittas]

I can reproduce this with sqlmesh format. It converted

select max(safe_cast('bla' as int64)) as foo

into

SELECT MAX('bla'::INT64) AS foo

[georgesittas]

I'll fix this