Vaggelis Danias

Changed to DFS so as to match BQ's flatten order (left to right), just in case the previous order added side effects

Hey @Leonti, thanks for reporting this. Right now, SQLGlot generates mostly JSONPath functions when parsing semi-structured accesses (e.g. `GET_PATH` for VARIANT in Snowflake) instead of preserving the colon/dot notation. However,...

Quick follow up to gain more context, could you provide an example of how your data is structured in Snowflake and in what way would they be transformed to Trino's...

Thanks for the detailed explanation! Did some research over the last days and came to the conclusion that there's ambiguity in transpiling Snowflake's `VARIANT` as it can store practically any...