Query: identity_user_group

select
  i.name as "Group Name",
  i.time_created as "Time Created",
  i.id as "ID"
from
  oci_identity_user as u,
  jsonb_array_elements(user_groups) as g
  inner join oci_identity_group as i on i.id = g ->> 'groupId'
where
  u.id  = $1;