SQL Server GRAPH: Match Query - not declaring all types [NOT POSSIBLE]

225 Views Asked by At

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

0

There are 0 best solutions below