The Event Stream Processor accepts a subset of SQL92 statements.
The SQL92 statements that Event Stream Processor are select, insert, update, and delete statements.
Queries using select are limited to single streams, with no joins or subqueries, but may use where, group by, and order by clauses. The insert, update, and delete statements are restricted to source streams. You can put these modification statements in sequence with a semicolon. You cannot run insert, update, or delete statements concurrently on the same window or stream.