SELECT * FROM OPENJSON(@json) WITH (id int 'strict $.id', firstName nvarchar(50) 'strict $.info.name', lastName nvarchar(50) '$.info.surname', age int, dateOfBirth datetime2)
SELECT * FROM OPENJSON (@JSON, '$.data.assets.parcels') WITH (id VARCHAR(7), x INT, y INT, price INT '$.auction_price') -- new column name )