databrickslabs / remorph

Cross-compiler and Data Reconciler into Databricks Lakehouse
Other
28 stars 16 forks source link

[FEATURE]: Implement support for Snowflake JSON access methods and paths #787

Open jimidle opened 1 month ago

jimidle commented 1 month ago

Is there an existing issue for this?

Category of feature request

Other

Problem statement

As the Snowflake grammar was changed to correctly parser expressions, we have somehow orphaned the rules that deal with JSON expressions. This need reinstating.

Proposed Solution

the json_path rule needs to be incorporated back in to the expr rule

Additional Context

No response