alter table dsm_api add column compatibility_override text default NULL;

update dsm_api set removable = true where id in (select api.id from dsm_api api left join dsm_services d on d.id = api.service where d.managed = true and api.removable=false);
