Presto to Spark query translation incorrect

[cploonker]

Before you file an issue

• Make sure you specify the "read" dialect eg. parse_one(sql, read="spark")
• Make sure you specify the "write" dialect eg. ast.sql(dialect="duckdb")
• Check if the issue still exists on main

Fully reproducible code snippet
Please include a fully reproducible code snippet or the input sql, dialect, and expected output.

Presto query

SELECT
  JSON_EXTRACT_SCALAR(
    TRY(
      FILTER(
        CAST(JSON_EXTRACT(context, '$.active_sessions') AS ARRAY(MAP(VARCHAR, VARCHAR))),
        x -> x['event_data_schema'] = 'PresentationSession'
      )[1]['event_data']
    ),
    '$.thread_id'
  )

SQL Glot translated it to following incorrect Spark sql

SELECT
  GET_JSON_OBJECT(
    TRY(
      FILTER(
        CAST(GET_JSON_OBJECT(context, '$.active_sessions') AS ARRAY<MAP<STRING, STRING>>),
        x -> x['event_data_schema'] = 'PresentationSession'
      )[0]['event_data']
    ),
    '$.thread_id'
  )

1. TRY does not work in spark.
2. CAST output of GET_JSON_OBJECT to ARRAY does not work in Spark.

Correct Spark sql is as follows

SELECT
  GET_JSON_OBJECT(
      FILTER(
        FROM_JSON(GET_JSON_OBJECT(context, '$.active_sessions'), 'ARRAY<MAP<STRING, STRING>>'),
        x -> x['event_data_schema'] = 'PresentationSession'
      )[0]['event_data']
    ,
    '$.thread_id'
  )

Official Documentation
Please include links to official SQL documentation related to your issue.