The SQL++ Query Language

• 1. Introduction
• 2. Expressions * Operator Expressions * Arithmetic Operators * Collection Operators * Comparison Operators * Logical Operators * Quantified Expressions * Path Expressions * Primary Expressions * Literals * Identifiers and Variable References * Parameter References * Parenthesized Expressions * Function calls * Case Expressions * Constructors
• 3. Queries * SELECT Clauses * Select Value * SQL-style Select * Select * * Select Distinct * Unnamed Projections * Abbreviated Field Access Expressions * FROM clauses * Joins * LET Clauses * WHERE Clause * Grouping * GROUP BY Clause * HAVING Clause * Aggregation Pseudo-functions * GROUP AS Clause * Selection and UNION ALL * WITH Clauses * ORDER By and LIMIT Clauses * Subqueries
• 4. Window Functions * Window Function Call * Window Function Arguments * Window Function Options * Window Frame Variable * Window Definition
• 5. Errors * Syntax Errors * Identifier Resolution Errors * Type Errors * Resource Errors
• 6.Differences from SQL-92
• 7. DDL and DML Statements * Lifecycle Management Statements * Use Statement * Set Statement * Function Declaration * Create Statement * Create Dataverse * Create Type * Create Dataset * Create Index * Create Synonym * Create Function * Drop Statement * Load Statement * Modification Statements * Insert Statement * Upsert Statement * Delete Statement
• Appendix 1. Reserved Keywords
• Appendix 2. Performance Tuning * Parallelism Parameter * Memory Parameters * Query Hints
• Appendix 3. Variable Bindings and Name Resolution
• Appendix 4. Example Data * Data Definitions * Customers Dataset * Orders Dataset