Date casting function does not transpile correctly from Spark SQL to Snowflake SQL

[jiangli001]

Reproducible code:

import sqlglot
sql = """select to_date(some_column, "yyyy-MM-dd) from df"""
print(sqlglot.parse_one(sql, "spark").sql("snowflake"))

The output is:

SELECT TO_DATE(some_column, 'yyyy-mm-DD') FROM df

The problem is that the to_date() function behaves differently in Spark and in Snowflake. In Spark, it returns NULL if the input does not match the format provided. In Snowflake, it raises an error if the input does not match the format provided. The correct transpiled function in Snowflake should be TRY_TO_DATE(), which returns a NULL value instead of raising an error.