Query: wellarchitected_lens_input

select
  l.title as label,
  l.arn as value,
  json_build_object(
    'account_id', l.account_id,
    'region', l.region,
    'lens_alias', l.lens_alias
  ) as tags
from
  aws_wellarchitected_workload w,
  aws_wellarchitected_lens l,
  jsonb_array_elements_text(w.lenses) la
where
  (la = l.lens_alias or la = l.arn)
  and l.account_id = w.account_id
  and l.region = w.region
  and w.workload_id = $1
order by
  l.title;