Entity graph export

WITH owners AS (
  SELECT from_id AS owner_id
  FROM codex.entity_graph
  WHERE edge_type = 'OWNS' AND to_id = :vessel_urn
),
sanctioned AS (
  SELECT from_id AS owner_id
  FROM codex.entity_graph
  WHERE edge_type = 'SANCTIONED_BY'
    AND from_id IN (SELECT owner_id FROM owners)
),
other_vessels AS (
  SELECT to_id AS sister_vessel
  FROM codex.entity_graph
  WHERE edge_type = 'OWNS'
    AND from_id IN (SELECT owner_id FROM sanctioned)
    AND to_id != :vessel_urn
)
SELECT * FROM other_vessels;

WITH RECURSIVE reachable(id, hop) AS (
  SELECT :seed_event_uuid, 0
  UNION ALL
  SELECT e.to_id, r.hop + 1
  FROM codex.entity_graph e
  JOIN reachable r ON e.from_id = r.id
  WHERE e.edge_type IN ('FOLLOWS', 'TRIGGERED', 'AFFECTS')
    AND r.hop < 3
)
SELECT r.id, r.hop, e.to_type
FROM reachable r
JOIN codex.entity_graph e ON e.from_id = r.id;