How can I use JSON in T-SQL to maintain configurations

declare @JSON varchar(max);
set @JSON =
'
[
	{
		"ConfigurationParameterID":1,
		"ParameterCode":"Beehive",
		"ParameterDescription":"Global parameter",
		"ParameterDataType":"D",
		"DefaultValueChar":null,
		"DefaultValueNumeric":null,
		"DefaultValueDate":null,
		"DefaultValueBit":null,
		"CreationDate":"2021-07-14T00:00:00",
		"CreatedBy":"K. Elst",
		"LastUpdateDate":"2021-07-14T00:00:00",
		"LastUpdatedBy":"K. Elst"
	},
	{
		"ConfigurationParameterID":2,
		"ParameterCode":"Ape",
		"ParameterDescription":"It''s a bee",
		"ParameterDataType":"C",
		"DefaultValueChar":null,
		"DefaultValueNumeric":null,
		"DefaultValueDate":null,
		"DefaultValueBit":null,
		"CreationDate":"2021-07-15T00:00:00",
		"CreatedBy":"K. Elst",
		"LastUpdateDate":"2021-07-15T00:00:00",
		"LastUpdatedBy":"K. Elst"
	}
]';

select
    PRM.ConfigurationParameterID,
    PRM.ParameterCode,
    PRM.ParameterDescription,
    PRM.ParameterDataType,
    PRM.DefaultValueChar,
    PRM.DefaultValueNumeric,
    PRM.DefaultValueDate,
    PRM.DefaultValueBit,
    PRM.CreationDate,
    PRM.CreatedBy,
    PRM.LastUpdateDate,
    PRM.LastUpdatedBy
from openjson(@JSON)
with
(
    ConfigurationParameterID int,
    ParameterCode nvarchar(50),
    ParameterDescription nvarchar(255),
    ParameterDataType nchar(1),
    DefaultValueChar nvarchar(max),
    DefaultValueNumeric float,
    DefaultValueDate datetime,
    DefaultValueBit bit,
    CreationDate datetime,
    CreatedBy nvarchar(255),
    LastUpdateDate datetime,
    LastUpdatedBy nvarchar(255)
)
as PRM

declare @JSON varchar(max);

set @JSON =

[

{

"ConfigurationParameterID":1,

"ParameterCode":"Beehive",

"ParameterDescription":"Global parameter",

"ParameterDataType":"D",

"DefaultValueChar":null,

"DefaultValueNumeric":null,

"DefaultValueDate":null,

"DefaultValueBit":null,

"CreationDate":"2021-07-14T00:00:00",

"CreatedBy":"K. Elst",

"LastUpdateDate":"2021-07-14T00:00:00",

"LastUpdatedBy":"K. Elst"

{

"ConfigurationParameterID":2,

"ParameterCode":"Ape",

"ParameterDescription":"It''s a bee",

"ParameterDataType":"C",

"DefaultValueChar":null,

"DefaultValueNumeric":null,

"DefaultValueDate":null,

"DefaultValueBit":null,

"CreationDate":"2021-07-15T00:00:00",

"CreatedBy":"K. Elst",

"LastUpdateDate":"2021-07-15T00:00:00",

"LastUpdatedBy":"K. Elst"

}

]';

select

PRM.ConfigurationParameterID,

PRM.ParameterCode,

PRM.ParameterDescription,

PRM.ParameterDataType,

PRM.DefaultValueChar,

PRM.DefaultValueNumeric,

PRM.DefaultValueDate,

PRM.DefaultValueBit,

PRM.CreationDate,

PRM.CreatedBy,

PRM.LastUpdateDate,

PRM.LastUpdatedBy

from openjson(@JSON)

with

(

ConfigurationParameterID int,

ParameterCode nvarchar(50),

ParameterDescription nvarchar(255),

ParameterDataType nchar(1),

DefaultValueChar nvarchar(max),

DefaultValueNumeric float,

DefaultValueDate datetime,

DefaultValueBit bit,

CreationDate datetime,

CreatedBy nvarchar(255),

LastUpdateDate datetime,

LastUpdatedBy nvarchar(255)

)

as PRM