CCL, the language used by the Sybase® Event Stream Processor, has two components.
The first component is an extension to SQL, which is used to declare the streams and other high level components, describe the data flow and define logic that can be expressed as relational operations (such as joins, aggregations, filters, etc.). The second component is SPLASH, which is a procedural language that is used to specify logic that cannot be easily represented using relational operators. SPLASH, just like any other procedural language, has support for variables, looping constructs, data structures and defining functions.