You can write a custom parser that will translate it. SQL migration is simple, you use UDF to cover not existing functions. Challenging can be procedure translation, it will depends on language that you use in store procedures?

Model and data migration will be easiest part, the model can be translated to Databricks SQL, data extracted to delta format or parquet.

LLMs can streamline translation, but you need to test it and review.