1) Данные
DECLARE @JSON NVARCHAR(MAX) =
'[{"type":"CIRCLE","id":null,"radius":2653.523472444495,"geometry":[32.37607276521905,50.89607968139649]},
{"type":"POLYLINE","id":null,"geometry":[[32.384191106549274,51.02242245483399],[32.33721060680366,50.95410122680665],[32.298912157759965,50.94277157592774]]},
{"type":"POLYGON","id":null,"geometry":[[[32.38100184516367,51.06739773559571],[32.34562248984498,51.025855682373056],[32.298912157759965,51.040618560791025],
[32.2986219561919,51.08284725952149],[32.362733906763,51.158721588134775],[32.39143900915657,51.09658016967774]]]},
{"type":"RECTANGLE","id":null,"geometry":[[32.30877845819,50.85625424194337],[32.3360502857075,50.91736569213868]]},
{"type":"MARKER","id":null,"geometry":[32.36940358204207,50.95101132202149]}]';

2) Хочу впихнуть в таблицу (type (varchar(10), id int, radius float, geometry nvarchar(max))

3) Запрос:
SELECT * FROM openjson(@JSON) with
(
[type] varchar(10) '$.type',
[id] int '$.id',
[radius] float '$.radius',
[geometry] varchar(max)'$.geometry'
)

4) Результат:
type id radius geometry
CIRCLE NULL 2653.52347244449 NULL
POLYLINE NULL NULL NULL
POLYGON NULL NULL NULL
RECTANGLE NULL NULL NULL
MARKER NULL NULL NULL

5) Как получить 'geometry'?

Молодец! Thanks!