DECLARE @json NVARCHAR(4000)
SET @json = N'[  
  {"id": 2, "info": {"name": "John", "surname": "Smith"}, "age": 25},
  {"id": 5, "info": {"name": "Jane", "surname": "Smith", "skills": ["SQL", "C#", "Azure"]}, "dob": "2005-11-04T12:00:00"}  
]';

SELECT [Name]
FROM OPENJSON(@json)
WITH (
    [Name]      VARCHAR(200)    N'$.info.name'
)
WHERE [Name] = 'Jane'

declare @Persons table(id int, [Name] nvarchar(4000))
insert into @Persons(id,[Name])
select 1, N'[{"id": 2, "info": {"name": "John", "surname": "Smith"}, "age": 25}]' union all
select 2, N'[{"id": 5, "info": {"name": "Jane", "surname": "Smith", "skills": ["SQL", "C#", "Azure"]}, "dob": "2005-11-04T12:00:00"}]'

SELECT [Name]
FROM OPENJSON(@json)
WITH (
    [Name]      VARCHAR(200)    N'$.info.name'
)
WHERE [Name] = 'Jane'