Sqlglot does not preserve new Databricks's Variant Syntax about sqlglot HOT 4 CLOSED

Transpilation of : will get a bit tricky now, because it requires type information.. @VaggelisD maybe let's try to change the -> databricks generation so that it preserves the : operator but continue parsing it into a JSONExtract to preserve current behavior and do a best-effort transpilation as if it was a JSON extraction.

from sqlglot.

This is intentional, so unless there's an issue with the semantics of the resulting queries, changing it is out of scope. Happy to continue discussing.

from sqlglot.

This is intentional, so unless there's an issue with the semantics of the resulting queries, changing it is out of scope. Happy to continue discussing.

There is, variant is a new type, and it's not json. see https://docs.databricks.com/en/semi-structured/variant-json-diff.html#what-are-the-sql-functions-for-working-with-variants

from sqlglot.

I see, thanks for clarifying. We'll take a closer look 👍

from sqlglot.