s-Server Streaming SQL Reference Manual

Purpose of this document

This document defines the SQL structured query language used by SQLstream. The language is based on the SQL standard with some minor extensions to accommodate the concept of streams.

It contains information on

  • Basic Building Blocks, including SQLstream Data Types, Streaming SQL Operators, and functions supported by streaming SQL, including built-in functions.
  • Standard SQL operators: CREATE statements, DROP statements, SELECT statements, INSERT, MERGE, DELETE, ALTER statements
  • Operators for transforming and filtering incoming data: offset and hopping windows, WHERE, JOIN, GROUP BY, WINDOW.
  • Logical operators, including - AS, AND, OR.


This document is aimed at developers of SQLstream applications.