Forum Discussion

Ryan Casey MBA's avatar
Ryan Casey MBA
Copper Contributor
Jun 03, 2022
Solved

SQL Graph Database Query Language

Microsoft documentation states that SQL Graph Database extensions use uses an ASCII-art type of syntax for the query language. Cypher is an ASCII-art type of syntax query language. Am I correct to sa...
  • Ronen_Ariely's avatar
    Jun 05, 2022

    Hi ryan_playdoe and welcome to the TechCommunity forums

     

    > Am I correct to say that Microsoft SQL Graph Database uses Cypher as a que

     

    I would not say so.

    Cypher is used by Neo4j and it not supported in SQL Server exactly as it is like in Neo4j.

    There is a lot of similarity since both have the same base using ASCII-art type of syntax query language. For simple queries the text might seems the same but when you go deeper to complex query then you will find that SQL Server does not uses the exact same format as Neo4j (Maybe it will in the future)

     

    Check out the following document. It a great post, which I highly recommend to read from start to end! But if you are lazy then just jump to the "Study Cases," where you can see the differences for complex queries (for example when using CTE).

    https://medium.com/swlh/microsoft-sql-servers-graph-an-attempt-that-fell-short-for-now-a4888245c483

     

    With that said, if you are expert in Cypher then you can work with Graph queries on SQL Server very fast.

     

     

Resources