These updates advance how you drive impact with Celonis - combining stronger value tracking, more powerful AI capabilities, and greater control over automation at scale. From KPI Snapshots and Transformation Hub to structured AI outputs, orchestration with AI agents, and granular consumption limits, you can now build more intelligent, integrated, and governed workflows across your organization.
See release summaries below. For full details, review release notes in Celonis Product Documentation.
Process Query Language
PQL now supports the WITH clause, enabling you to define temporary table aliases and named expressions directly within queries. This allows you to encapsulate complex logic into reusable blocks, significantly improving the structure and maintainability of sophisticated PQL statements.
To provide flexibility in how you define your logic, the WITH clause supports two distinct declaration methods:
- REGISTER: Creates a temporary alias for a table or assigns a named PQL variable (prefixed with @) to a specific column expression or condition.
- EXTEND: Dynamically attaches a computed column to an existing table for the duration of the expression, allowing you to treat derived logic as a native part of the table schema.
For example:
WITH [
REGISTER "EventLog" AS CREATE_EVENTLOG ( "ObjectTable" ),
EXTEND "EventLog" WITH "CustomAttribute" AS "EventLog"."Attribute" + 1
] ( "Eventlog"."CustomAttribute" + 2 )
The declared names are strictly local to the immediate expression. They are not visible outside of it, and the same identifier can be redeclared with a different meaning in a separate expression without conflict.
For more information, see the WITH clause documentation.