When working with Property Graphs, resolving the data path aka. decomposing Graph path is key to understanding the path traversed by a MATCH query in a SQL/PGQ. To facilitate this unnesting / flattening of path data, Oracle has introduced a new ROWS clause which can be used inside the GRAPH_TABLE operator for SQL Property Graph queries. This new clause can be placed directly before the COLUMNS clause to unnest/flatten path data. This syntax comes in three variations: ONE ROW PER MATCH - produc...