How can a Neo4J database be queried recursively for a cypher?

edit

A Neo4J database can be queried recursively using a Cypher query by leveraging the MATCH clause in combination with the WITH and UNION clauses.

Here is an example Cypher query that recursively queries a Neo4J database to find all nodes that are related to a specific node:

MATCH (node)-[:RELATED_TO*]->(related_node)
WHERE ID(node) = {node_id}
WITH collect(related_node) AS related_nodes
UNWIND related_nodes AS related_node
MATCH (related_node)-[:HAS_PROPERTY]->(property)
RETURN related_node, property.name

In this query, we use the MATCH clause to find all nodes that are related to a specific node, denoted by {node_id}. The * symbol in the relationship pattern [:RELATED_TO*] represents a variable-length relationship that can be traversed recursively.

We then use the WITH clause to collect all the related nodes into a list and then UNWIND them to iterate over each related node individually. We use another MATCH clause to find all properties of each related node and finally return both the related node and its properties.

This query would return all nodes related to the specified node and their corresponding properties in a tabular format.