Content-Type: text/plain;
	charset=utf-8
Mime-Version: 1.0 (Mac OS X Mail 16.0 \(3774.600.62\))
Subject: Re: SQL Property Graph Queries (SQL/PGQ)
From: Florents Tselai <florents.tselai@gmail.com>
In-Reply-To: <04c0abe2-e9c5-4ffc-97b2-bedc1e3cd178@eisentraut.org>
Date: Thu, 4 Jul 2024 11:19:46 +0300
Cc: pgsql-hackers <pgsql-hackers@postgresql.org>,
 Ashutosh Bapat <ashutosh.bapat.oss@gmail.com>
Content-Transfer-Encoding: quoted-printable
Message-Id: <853AEC0B-781F-4F37-AFC1-0422D2F02FA5@gmail.com>
References: <a855795d-e697-4fa5-8698-d20122126567@eisentraut.org>
 <20240216192301.q2tf4bqjydymg3g2@awork3.anarazel.de>
 <9c5edd61-c415-475b-a088-7bd7461b21a4@eisentraut.org>
 <5fa7f8a7-ce94-4a2a-ab93-4d43f97a1a41@enterprisedb.com>
 <CAExHW5vv9roBJq=CkJJY=z0AO7G4zxTCYXeMK07AdnHARXnOsQ@mail.gmail.com>
 <CAExHW5s3BL_qUwQ=ye8RX7GnVcGC+FeR7h6jFocBZC5JFXATEQ@mail.gmail.com>
 <04c0abe2-e9c5-4ffc-97b2-bedc1e3cd178@eisentraut.org>
To: Peter Eisentraut <peter@eisentraut.org>
Archived-At: <https://www.postgresql.org/message-id/853AEC0B-781F-4F37-AFC1-0422D2F02FA5%40gmail.com>
Precedence: bulk

In the ddl.sgml, I=E2=80=99d swap the first two paragraphs.
I find the first one a bit confusing as-is. As far as I can tell, it=E2=80=
=99s an implementation detail.
The first paragraph should answer, =E2=80=9CI have some data modeled as =
a graph G=3D(V, E). Can Postgres help me?=E2=80=9D.

Then, introducing property graphs makes more sense.=20

I'd also use the examples and fake data in `graph_table.sql` in =
ddl/queries.sgml).
I was bummed that that copy-pasting didn't work as is.
I=E2=80=99d keep explaining how a graph query translates to a relational =
one later in the page.

As for the implementation, I can=E2=80=99t have an opinion yet,
but for those not familiar, Apache Age uses a slightly different =
approach
that mimics jsonpath (parses a sublanguage expression into an internal =
execution engine etc.).
However, the standard requires mapping this to the relational model, =
which makes sense for core Postgres.


> On 27 Jun 2024, at 3:31=E2=80=AFPM, Peter Eisentraut =
<peter@eisentraut.org> wrote:
>=20
> Here is a new version of this patch.  I have been working together =
with Ashutosh on this.  While the version 0 was more of a fragile demo, =
this version 1 has a fairly complete minimal feature set and should be =
useful for playing around with.  We do have a long list of various =
internal bits that still need to be fixed or revised or looked at again, =
so there is by no means a claim that everything is completed.
>=20
> Documentation to get started is included (ddl.sgml and queries.sgml). =
(Of course, feedback on the getting-started documentation would be most =
welcome.)
> <v1-0001-WIP-SQL-Property-Graph-Queries-SQL-PGQ.patch>