MATCH (r:Repository)-[:DEPENDS_ON]->(d:Dependency)
WHERE r.name = 'forwardlane-backend'
RETURN d.name, d.version

MATCH (r:Repository)-[:HAS_FILE]->(f:SourceFile)
WHERE r.name = 'forwardlane-backend'
RETURN f.path, f.language, f.line_count
ORDER BY f.line_count DESC
LIMIT 20

-- Functions defined in a specific file
MATCH (f:SourceFile {path: 'apps/portfolios/validators.py', repo: 'forwardlane-backend'})
      -[:HAS_FUNCTION]->(fn:Function)
RETURN fn.name, fn.complexity
ORDER BY fn.complexity DESC

-- All view classes in the backend
MATCH (r:Repository {name: 'forwardlane-backend'})-[:HAS_CLASS]->(c:Class)
WHERE any(base IN c.bases WHERE base CONTAINS 'View' OR base CONTAINS 'ViewSet')
RETURN c.name, c.bases, c.method_count

MATCH (r:Repository)-[:HAS_MODEL]->(m:DataModel)
WITH r, count(m) AS model_count
ORDER BY model_count DESC
RETURN r.name, model_count
LIMIT 10

-- All FK fields in the Portfolio model
MATCH (m:DataModel {name: 'Portfolio'})-[:HAS_FIELD]->(f:ModelField)
WHERE f.field_type = 'ForeignKey'
RETURN f.name, f.fk_target

-- All POST endpoints across all repos
MATCH (r:Repository)-[:HAS_ENDPOINT]->(e:APIEndpoint)
WHERE e.http_method = 'POST'
RETURN r.name, e.path, e.view_name
ORDER BY r.name

-- Repos with the most integration tests
MATCH (r:Repository)-[:HAS_TEST]->(t:TestCase)
WHERE t.test_type = 'integration'
WITH r, count(t) AS test_count
ORDER BY test_count DESC
RETURN r.name, test_count
LIMIT 10

-- All high-severity issues with their files
MATCH (f:SourceFile)-[:HAS_SECURITY_ISSUE]->(s:SecurityPattern)
WHERE s.severity = 'high'
RETURN f.repo, f.path, s.type, s.description

-- Repos that have a Dockerfile
MATCH (r:Repository)-[:HAS_CONFIG]->(c:ConfigFile)
WHERE c.config_type = 'docker'
RETURN r.name, c.path

-- All repos a contributor has worked on
MATCH (c:Contributor {name: 'Alex Chen'})-[:COMMITTED_TO]->(r:Repository)
RETURN r.name, r.tier
ORDER BY r.tier

-- Find all functions called by a specific function
MATCH (caller:Function {name: 'validate_portfolio_allocation'})-[:CALLS]->(callee:Function)
RETURN callee.name, callee.repo, callee.file_path

-- Find the most-called functions (hotspots)
MATCH (caller:Function)-[:CALLS]->(callee:Function)
WITH callee, count(caller) AS call_count
ORDER BY call_count DESC
RETURN callee.name, callee.repo, call_count
LIMIT 20

-- Find all repos that depend on the auth service
MATCH (r:Repository)-[:IMPORTS]->(auth:Repository {name: 'fl-auth-service'})
RETURN r.name, r.tier

-- Find all tests for the Portfolio class
MATCH (t:TestCase)-[:TESTS]->(c:Class {name: 'Portfolio'})
RETURN t.name, t.file_path, t.test_type

-- Find the source file that defines the Portfolio model
MATCH (m:DataModel {name: 'Portfolio'})-[:DEFINED_IN]->(f:SourceFile)
RETURN f.path, f.repo

-- Find all classes that inherit from APIView
MATCH (child:Class)-[:INHERITS_FROM]->(parent:Class)
WHERE parent.name CONTAINS 'APIView' OR parent.name CONTAINS 'ViewSet'
RETURN child.name, child.repo, parent.name

-- Find all functions that use the Portfolio model
MATCH (fn:Function)-[:USES_MODEL]->(m:DataModel {name: 'Portfolio'})
RETURN fn.name, fn.repo, fn.file_path

-- Find the view class for the portfolio list endpoint
MATCH (c:Class)-[:SERVES_ENDPOINT]->(e:APIEndpoint {view_name: 'portfolio-list'})
RETURN c.name, c.repo

-- Find all email aliases for a contributor
MATCH (c:Contributor {name: 'Alex Chen'})-[:SAME_AS]-(alias:Contributor)
RETURN alias.name, alias.email