Postgres 12

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

CREATE TABLE test (
  id INT,
  guest_profile_id character varying(100),
  custom_fields jsonb not null default '{}'::jsonb
);
INSERT INTO test (id, custom_fields) VALUES
  (1, '[{"protelSurname": "Smith", "servicio_tags": ["protel-info"], "protelUniqueID": "[{\"ID\":\"asdf\",\"Type\":\"21\",\"ID_Context\":\"GHA\"},{\"ID\":\"Test1-ID\",\"Type\":\"1\",\"ID_Context\":\"protelIO\"}]",    "protelGivenName": "Seth"}, {"value": "Test", "display_name": "Traces", "servicio_tags": ["trace"]}]'),
  (2, '[{"protelSurname": "Smith", "servicio_tags": ["protel-info"], "protelUniqueID": "[{\"ID\":\"asdf\",\"Type\":\"21\",\"ID_Context\":\"GHA\"},{\"ID\":\"Test2-ID\",\"Type\":\"1\",\"ID_Context\":\"protelIO\"}]", "protelGivenName": "Seth"}, {"value": "Test2", "display_name": "Traces", "servicio_tags": ["trace"]}]'),
  (3, '[{"value": "Test3-ID", "display_name": "Test", "servicio_tags": ["person-name"]}]'),
  (4, '[{"value": "Test4-ID", "display_name": "Test", "servicio_tags": ["profile-id"]}]');
TABLE test;

4 rows affected

id	guest_profile_id	custom_fields
1	null	[{"protelSurname": "Smith", "servicio_tags": ["protel-info"], "protelUniqueID": "[{"ID":"asdf","Type":"21","ID_Context":"GHA"},{"ID":"Test1-ID","Type":"1","ID_Context":"protelIO"}]", "protelGivenName": "Seth"}, {"value": "Test", "display_name": "Traces", "servicio_tags": ["trace"]}]
2	null	[{"protelSurname": "Smith", "servicio_tags": ["protel-info"], "protelUniqueID": "[{"ID":"asdf","Type":"21","ID_Context":"GHA"},{"ID":"Test2-ID","Type":"1","ID_Context":"protelIO"}]", "protelGivenName": "Seth"}, {"value": "Test2", "display_name": "Traces", "servicio_tags": ["trace"]}]
3	null	[{"value": "Test3-ID", "display_name": "Test", "servicio_tags": ["person-name"]}]
4	null	[{"value": "Test4-ID", "display_name": "Test", "servicio_tags": ["profile-id"]}]

4 rows affected

id	guest_profile_id	custom_fields
1	Test1-ID	[{"protelSurname": "Smith", "servicio_tags": ["protel-info"], "protelUniqueID": "[{"ID":"asdf","Type":"21","ID_Context":"GHA"},{"ID":"Test1-ID","Type":"1","ID_Context":"protelIO"}]", "protelGivenName": "Seth"}, {"value": "Test", "display_name": "Traces", "servicio_tags": ["trace"]}]
2	Test2-ID	[{"protelSurname": "Smith", "servicio_tags": ["protel-info"], "protelUniqueID": "[{"ID":"asdf","Type":"21","ID_Context":"GHA"},{"ID":"Test2-ID","Type":"1","ID_Context":"protelIO"}]", "protelGivenName": "Seth"}, {"value": "Test2", "display_name": "Traces", "servicio_tags": ["trace"]}]
3	Test3-ID	[{"value": "Test3-ID", "display_name": "Test", "servicio_tags": ["person-name"]}]
4	Test4-ID	[{"value": "Test4-ID", "display_name": "Test", "servicio_tags": ["profile-id"]}]