Query: autoscaling_auto_scaling_configurations_for_compute_instance

with intance_pool_id as (
  select
    tags ->> 'oci:compute:instancepool' as instance_pool_id,
    id
  from
    oci_core_instance
)
select
  a.id as auto_scaling_config_id
from
  oci_autoscaling_auto_scaling_configuration as a,
  intance_pool_id as i
where
  instance_pool_id = resource ->> 'id'
  and i.id = $1;