I'm doing research into SQL Server Graph vs Neo4J for my internship.
- In Neo4J I don't have to declare all types in the (
Cypher
) MATCH query - In SQL Server, it seems that I have to do so
Examples:
SQL Server:
SELECT Restaurant.name
FROM Person, likes, Restaurant
WHERE MATCH (Person-(likes)->Restaurant)
AND Person.name = 'John';`
I want to change Person / Likes / Restaurant to not predefined types
Like in Neo4J:
MATCH (n:Person)-[r]->(m) WHERE n.name = "John"
I know that these two queries are not comparable but I'm trying to point out that I would like to use "r(elation)" and "m" in SQL Server.
It looks close to this SO: Syntax to query for optional relationships in Microsoft SQL Server 2017 Graph Database? but I hope I could do this without joins.
Edit: CLOSED: This feature is not supported by Microsoft