Trigger: Detect & correct PostgreSQL servers with log checkpoints disabled

select
  concat(
    db.id,
    ' [',
    db.subscription_id,
    '/',
    db.resource_group,
    ']'
  ) as title,
  db.id as id,
  db.name,
  db.resource_group,
  db.subscription_id,
  db._ctx ->> 'connection_name' as conn
from
  azure_postgresql_server as db,
  jsonb_array_elements(server_configurations) config,
  azure_subscription as sub
where
  config ->> 'Name' = 'log_checkpoints'
  and lower(config -> 'ConfigurationProperties' ->> 'value') != 'on'
  and sub.subscription_id = db.subscription_id;