Support for Array data types in Lakehouse SQL Endpoint

Currently in Fabric Lakehouse SQL Endpoint, Columns with complex data types such as array (JSON types) were not shown and not able to use them in the queries.

Would be nice if the complex data types (JSON) type is supported in the SQL endpoint.

Additionally, Unnesting the array is a pain in Synapse Serverless SQL.

Like a see a easy method for accessing the elements in the array like modern data warehouses like BigQuery or SnowFlake has (dot accessor and unnest).

Ex:

Accessing non-repeated struct

select product.name, product.price from table_a

Accessing repeated struct

select a.acc_name, prod.name, prod.price from table_a, unnest(products) as prod

Thanks,

Vasu Nallasamy