Sql server allows you to parse Json data with OpenJson .
Sample Json data : [{“MinValue”:”1″,”MaxValue”:”6″}]
Parsing Json to map into Tables:
declare @metadata="[{"MinValue":"1","MaxValue":"6"}]" select Minvalue,MaxValue from openjson(@metadata) with (MinValue nvarchar(2),MaxValue nvarchar(2));