Hi, we use a lot of json caluses in our db procedures e.g.:
select
*
into
#parcel_data
from
openjson(@parcelData, '$')
with
(
"ParcelId" int '$.ParcelId',
"ParcelTypeId" int '$.ParcelTypeId',
"ShipmentId" int '$.ShipmentId',
"BarCode" nvarchar(100) '$.BarCode'
);
Why don't You prepare such a helper in dbForge Studio ? It could be located on the level of "Generate script as" menu for each table for instance. To have the possibility to prepare our own plugins would be also a good idea.