Florents Tselai has submitted a new session!

Doing More with JSONPath: Turning a Query Language into a Transformation Engine

PostgreSQL’s JSONPath engine is often seen as just a filtering tool — but its real potential lies much deeper. In this talk, we’ll explore how the JSONPath infrastructure can serve as a foundation for building powerful, domain-specific languages (DSLs) within Postgres.

Drawing on my recent work to extend JSONPath with richer text processing functions like lower(), replace(), we’ll demonstrate how these additions evolve JSONPath from a query language into a lightweight transformation engine. You’ll learn:
• How JSONPath is implemented in PostgreSQL and why it’s extensible
• The design rationale behind adding composable text functions to the language
• How these functions open the door to expressive, pipeline-style data transformations
• Why JSONPath’s AST and evaluation model make it a great blueprint for custom DSLs

If you’re interested in Postgres internals, building smarter queries, or embedding logic closer to the data — this is your invitation to rethink what JSONPath can do.

Open session

These notifications can be turned off on Edit event page.