postgres apache age graph database

• Apache AGE Graph Database

For example, demonstrates a traversal that navigates from a person to their associated department, all without the complexity of join operations. Importantly, this query is executed entirely within PostgreSQL, eliminating the need to export data or maintain a separate graph database.

SELECT *
FROM cypher('hr_graph', $$
MATCH (p:Person {name: 'Alice'})-[:memberOf]->(d:`Department`)
RETURN d.name
$$) AS (department_name text);