Neo4j

Given that MATCH (product:Artefact)-[:ASSIGNED_SKU]->(assigned_sku:Sku) RETURN count(product) as count returns 141 Why does MATCH (product:Artefact)-[:ASSIGNED_SKU]->(assigned_sku:Sku) OPTIONAL MATCH (assigned_sku)-[IN_HIERARCHICAL_CATEGORY]->(assign...

Not a bug, just couldn't find documentation on this. Starting with a known reference point: 1 node with 2 connections to 2 different nodes: MATCH (associated_node1)-[:REL1]-(start_node {name: "Start"})-[:REL2]-(associated_node2) RETURN * Make sense, ...

I'm looking to switch away from Neo4j-rb, so I'm open to any stack at this point, but here's my wish-list: The ability to do a manual Cypher query Nodes have methods that traverse the relationship (Examples: author.posts[0], post.comments[i].author...