how to create an api at local and after calling it we get sql data in JSON object format as outout code example
Example: sql how to query data json that store in field
select *
from employees
where json_value(home_address,'$.state')='AR'
declare @json nvarchar(max) = N'{"employee":[{"id":1,"name":{"first":"Jane","middle":"Laura","last":"Jones"},"address":{"home":"11th Ave W","work":"10th Ave W","city":"Tampa","zipcode":"33601","state":"Florida"}}]}';