pg_igraph Brings Cypher-Like Graph Queries Inside PostgreSQL With Its Own Grammar

The pg_igraph extension allows developers to run graph traversal queries directly within PostgreSQL using a Cypher-inspired MATCH syntax, but it operates through its own lexer, parser, and AST rather than simple string substitution. A shorthand PATH FROM...TO...VIA form is also available for straightforward point-to-point path lookups without writing full MATCH expressions. The extension supports JSON-backed query parameters, keeping application values separate from the graph expression itself and enabling cleaner, scalable code. Notably, row-returning MATCH queries and mutation or path commands return different response shapes, which developers must account for in application logic. Because the content inside igraph_query() is not standard SQL, tools like ORMs, linters, and query proxies may treat it as an opaque argument, making the abstraction boundary between PostgreSQL and the graph layer an important design consideration.