-- HC-SCHEMA: Count of governed collections missing description column -- DB: directus | Schema: public | Read-only | Returns single-row count for dispatch_sql SELECT count(*)::int AS missing_description_count FROM ( SELECT cr.collection_name FROM collection_registry cr WHERE cr.governance_role = 'governed' AND cr.collection_name NOT IN ( SELECT c.table_name FROM information_schema.columns c WHERE c.column_name = 'description' AND c.table_schema = 'public' ) ) t