SQL Server 2022

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

5 rows affected

JSON_F52E2B61-18A1-11d1-B105-00805F49916B
[{"Name":"John Doe","Age":30,"City":"New York","Tags":[{"Name":"Jane Smith","Age":25,"City":"Los Angeles"},{"Name":"Bob Johnson","Age":40,"City":"Chicago"},{"Name":"Alice Brown","Age":28,"City":"San Francisco"}]},{"Name":"Jane Smith","Age":25,"City":"Los Angeles","Tags":[{"Name":"John Doe","Age":30,"City":"New York"},{"Name":"Charlie White","Age":35,"City":"Seattle"}]},{"Name":"Bob Johnson","Age":40,"City":"Chicago","Tags":[{"Name":"Jane Smith","Age":25,"City":"Los Angeles"},{"Name":"Alice Brown","Age":28,"City":"San Francisco"}]},{"Name":"Alice Brown","Age":28,"City":"San Francisco","Tags":[{"Name":"John Doe","Age":30,"City":"New York"},{"Name":"Bob Johnson","Age":40,"City":"Chicago"}]},{"Name":"Charlie White","Age":35,"City":"Seattle","Tags":[{"Name":"Jane Smith","Age":25,"City":"Los Angeles"},{"Name":"Bob Johnson","Age":40,"City":"Chicago"},{"Name":"Alice Brown","Age":28,"City":"San Francisco"}]}]

JSON_F52E2B61-18A1-11d1-B105-00805F49916B

[{"Name":"John Doe","Age":30,"City":"New York","Tags":[{"Name":"Jane Smith","Age":25,"City":"Los Angeles"},{"Name":"Bob Johnson","Age":40,"City":"Chicago"},{"Name":"Alice Brown","Age":28,"City":"San Francisco"}]},{"Name":"Jane Smith","Age":25,"City":"Los Angeles","Tags":[{"Name":"John Doe","Age":30,"City":"New York"},{"Name":"Charlie White","Age":35,"City":"Seattle"}]},{"Name":"Bob Johnson","Age":40,"City":"Chicago","Tags":[{"Name":"Jane Smith","Age":25,"City":"Los Angeles"},{"Name":"Alice Brown","Age":28,"City":"San Francisco"}]},{"Name":"Alice Brown","Age":28,"City":"San Francisco","Tags":[{"Name":"John Doe","Age":30,"City":"New York"},{"Name":"Bob Johnson","Age":40,"City":"Chicago"}]},{"Name":"Charlie White","Age":35,"City":"Seattle","Tags":[{"Name":"Jane Smith","Age":25,"City":"Los Angeles"},{"Name":"Bob Johnson","Age":40,"City":"Chicago"},{"Name":"Alice Brown","Age":28,"City":"San Francisco"}]}]