Where the open-source database community meets: Secure your spot at PerconaLive.com
Back to all talks

Designing a new SQL language feature: Key joins

Event: PGConf Europe 2026

Location: Valencia

Dates: 20 October 2026 – 23 October 2026

Presentation: 20 October 2026 , 01:00

Speakers: Andreas Karlsson, Joel Jacobsson

Back in 2021 Joel approached me with an idea: what if we could take inspiration from graph databases and allow people people to use foreign key relationships to express joins so people could do a bit less typing and at the same time avoid the risk of typos when writing the ON clause. Sounds pretty simple, right?

This talk tells the story all the way from the initial idea to the submission of a formal change proposal to the SQL standard and of a concrete patch to PostgreSQL. Along the way we had many false starts and bad ideas, Joel ended up joining the SQL committee and hosting an ISO meeting, more people joined forces to help us and the feature grew into something quite different, and in our opinion something much more useful.

Event

Speaker card

Designing a new SQL language feature: Key joins

Speakers