feat(ontology): add tp_count projections and update node_edge_counts

Michael Angelo Riverarequested to merge
arivera/ontology-tp-count-projections into main

Summary

  • Add tp_count aggregate projection to all 23 namespace-scoped node ontology YAML files
  • Update node_edge_counts projection on gl_edge to use uniq(source_id, target_id)
  • Regenerate config/graph.sql from ontology (orbit schema --diff confirms 28/28 match)
  • Bump SCHEMA_VERSION from 0 to 1

These projections enable ClickHouse to serve SELECT traversal_path, uniq(id) ... GROUP BY traversal_path count queries from pre-aggregated data rather than scanning full tables. Used by the indexing progress feature (GetGraphStatus RPC).

Relates to #175

Merge request reports