Trigger: Detect & correct App Service web apps without the latest python version

select
  concat(id, ' [', subscription_id, '/', resource_group, ']') as title,
  id as id,
  name,
  resource_group,
  subscription_id,
  _ctx ->> 'connection_name' as conn
from
  azure_app_service_web_app
where
  exists (
    select
    from
      unnest(regexp_split_to_array(kind, ',')) elem
    where
      elem like 'app%'
  )
  and exists (
    select
    from
      unnest(regexp_split_to_array(kind, ',')) elem
    where
      elem = 'linux'
  )
  and configuration -> 'properties' ->> 'linuxFxVersion' like 'PYTHON%'
  and configuration -> 'properties' ->> 'linuxFxVersion' <> 'PYTHON|3.12';