By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
create table data_tb
(
RawData nvarchar(max)
);
insert into data_tb (RawData) values
('{"ID":1, "key": "value1", "object":{ "name": "alfred" }}'),
('{"ID":2, "key": "value2", "object":{ "name": "bert" }}'),
('{"ID":3, "key": "value3", "object":{ "name": "cecil" }}'),
('{"ID":4, "key": "value4", "object":{ "name": "dominique" }}'),
('{"ID":5, "key": "value5", "object":{ "name": "elise" }}');
select d.RawData, json_query(d.RawData, '$.object') as Object
from data_tb d;
| RawData | Object |
|---|---|
| {"ID":1, "key": "value1", "object":{ "name": "alfred" }} | { "name": "alfred" } |
| {"ID":2, "key": "value2", "object":{ "name": "bert" }} | { "name": "bert" } |
| {"ID":3, "key": "value3", "object":{ "name": "cecil" }} | { "name": "cecil" } |
| {"ID":4, "key": "value4", "object":{ "name": "dominique" }} | { "name": "dominique" } |
| {"ID":5, "key": "value5", "object":{ "name": "elise" }} | { "name": "elise" } |