Query: objectstorage_bucket_object_lifecycle_policy

 select
  i ->> 'name' as "Name",
  i ->> 'isEnabled' as "Enabled",
  object_lifecycle_policy ->> 'timeCreated' as "Time Created",
  i ->> 'action' as "Action",
  i ->> 'target' as "Target",
  i ->> 'timeAmount' as "Time Amount",
  i ->> 'timeUnit' as "Time Unit"
from
  oci_objectstorage_bucket,
  jsonb_array_elements(object_lifecycle_policy -> 'items') as i
where
  id = $1 and jsonb_typeof(object_lifecycle_policy -> 'items') = 'array';