search

oracle / pgql-lang

PGQL is an SQL-based query language for property graphs
https://pgql-lang.org/
Other
182 stars 44 forks source link

Merge LATERAL and GRAPH_TABLE into outer query when possible #125

Closed oskar-van-rest closed 1 year ago

oskar-van-rest commented 1 year ago

pgql version 2.0.4.1

For example, queries like:

SELECT *
FROM GRAPH_TABLE ( LdbcGraph MATCH (n) COLUMNS (n.*) )
FETCH FIRST 10 ROWS ONLY

are now translated into:

SELECT n.*
FROM MATCH (n) ON LdbcGraph
FETCH FIRST 10 ROWS ONLY