The following blogpost by Corrado De Bari walks you through creating a SQL Property Graph from scratch- defining nodes and edges on top of regular relational tables, querying with SQL/PGQ pattern matching, and combining relational data with graph traversal:
https://corradodebari.github.io/graphtutorial1.html