Source
Querying Semi-structured Data
This topic explains how to use special operators and functions to query complex hierarchical data stored in a VARIANT.
Dynamically extracting JSON values using LATERAL FLATTEN
FAQ: Follow the steps given below for a hands - on demonstration of using LATERAL FLATTEN to extract information from a JSON Document.