Please head over to https://aka.ms/json-preview to learn more about the private preview of native JSON type and JSON aggregates - JSON_OBJECTAGG & JSON_ARRAYAGG in Azure SQL Database.
Published May 25, 2023
Version 1.0
uc-msft
Microsoft
MicrosoftBlog Post
1 MIN READ
Private preview announcement of native JSON type & JSON aggregates in Azure SQL Database
uc-msftMicrosoft
Microsoft1 Comment
Can share more information Query options avaialble to selects list of json objects based on JSON Array element values?.
Also if possible kindly share the Query optimization supported ?
