Semi-Structured Data Support

[rampage644]

This epic needs love, we have tons of materials on this topic and it should be all brought here

https://docs.snowflake.com/en/sql-reference/data-types-semistructured

https://github.com/Embucket/meta_engineering/blob/main/sql_functionality/1_sql_data_types_reference/05_semistructured.md

@eadgbear already did a PR #706 which contains most of what is needed @ravlio please look into it and as @eadgbear help if needed