On November 04, 2025, we had the pleasure to host a talk from Willi Mann and Stefan de Lorenzo on the Celonis Process Query Language (PQL) at the Department of Computer Science.
PQL is a powerful and intuitive data query language designed specifically for business users.
Together with the audience, Willi Mann and Stefan de Lorenzo explored PQL’s core data model with tables and a cycle-free join graph, PQL’s “column-oriented” language structure to simplify data retrieval and knowledge management, and filter-related key features like decoupled filtering, late filter application, and composability.
Afterwards, Willi Mann and Stefan de Lorenzo gave an outline of the implementation and the underlying architecture, including an efficient software-level caching mechanism, and concluded with an outlook on PQL’s evolution to nativ OCDM query support.
Finally, Willi Mann and Stefan de Lorenzo engaged in intensive discussions with the audience to clarify open questions.