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 [https://sessionize.com/app/organizer/session/19661/937792] These notifications can be turned off on Edit event [https://sessionize.com/app/organizer/event/edit/19661#_tab-advanced] page. Tip: You've used Classic (confer***@***orysql.org) to login. You're receiving this message because you had joined event 'HOW2025' on Sessionize. Sessionize.com, PO Box 6945, Unit 34564, London W1A 6US, UK