alter table dsm_api add column compatibility_override varchar(255) default NULL;

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