Tools › JSON → OPENJSON

JSON to SQL Server OPENJSON flattener

APIs arrive as JSON. OPENJSON with WITH is how SQL Server turns that into columns. We guess types from the sample.

JSON sample JSON column / variable

Arrays of objects need CROSS APPLY OPENJSON. Nested objects are flattened with a path. Check the types before you ship.

Learn it on a real ticket

Monday is free on WorkSQL. Write the T-SQL yourself. We mark it like a colleague would.