SQL statements and syntax

This section provides reference for using SQream DB’s SQL statements - DDL commands, DML commands and SQL query syntax.

In this section:

• SQL syntax features
  • Keywords and Identifiers
  • Literals
  • Scalar expressions
  • Joins
  • Common table expressions (CTEs)
  • Window functions
  • Subqueries
  • Null handling
• SQL statements
  • Data Definition commands (DDL)
  • Data manipulation commands (DML)
  • Utility commands
  • Saved queries
  • Monitoring
  • Workload management
  • Access control commands
• SQL functions
  • Summary of functions