A simple-to-use UI is provided and queries can be constructed using the provided user interface. The following is the feature set of the declarative SQL constructs:
- Filters (Where)
- Projections (Select)
- Time-window and property-based aggregates (Group By)
- Time-shifted joins (specifying time bounds within which the joining events must occur)
- All combinations thereof
The following is a summary of different constructs to manipulate streaming data:
- Data manipulation: SELECT, FROM, WHERE GROUP BY, HAVING, CASE WHEN THEN ELSE, INNER/LEFT OUTER JOIN, UNION, CROSS/OUTER APPLY, CAST, INTO, ORDER BY ASC, DSC
- Date and time functions: DateName, DatePart, Day, Month, Year, DateDiff, DateTimeFromParts, DateAdd
- Temporal functions ...