SQLstream SQL Reference Guide

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.

Audience

This document is aimed at developers of SQLstream applications.

Sections