Control: Long running SQL databases should have reserved capacity purchased for them

powerpipe control run azure_thrifty.control.sql_database_long_running_reserved_capacity

powerpipe login
powerpipe control run azure_thrifty.control.sql_database_long_running_reserved_capacity --share

select
  db.id as resource,
  case
    when date_part('day', now() - creation_date) > $1 then 'alarm'
    when date_part('day', now() - creation_date) > $2 then 'info'
    else 'ok'
  end as status,
  db.title || ' has been in use for ' || date_part('day', now() - creation_date) || ' day(s).'
  as reason
  
  , db.resource_group
  , display_name as subscription
from
  azure_sql_database as db,
  azure_subscription as sub
where
  db.name != 'master'
  and db.subscription_id = sub.subscription_id;