Native JSON support now in preview in Azure SQL Managed Instance

I great post , congrats

Is there a plan on T SQL  services ( Azure SQL  data base , Fabric Warehouse)  to also manage nesteed fiels like on GCP Bigquery & Snowflake ?

Via record column type ?

Big advantage on SQL DDL   : Store  a JSON nested structure directly on a T SQL SQL table  schema

More clear/accurate than JSON type column for  schema  managements 

fruits                RECORD NULLABLE
fruit.name           CHAR NULLABLE
fruit.weight         INT NULLABLE

Unnest on SQL queries via UNNEST function

--Flatten out all fruits that is stored in `users.fruits`
select
u.id,
u.name,
unnested.name as name,
unnested.weight as weight,
from fruits u
left join unnest(u.fruits) as unnested