The Query Language

• 1. Introduction
• 2. Expressions * Operator Expressions * Arithmetic Operators * Collection Operators * Comparison Operators * Logical Operators * Quantified Expressions * Path Expressions * Primary Expressions * Literals * Variable References * Parenthesized Expressions * Function call Expressions * Case Expressions * Constructors
• 3. Queries * Declarations * SELECT Statements * SELECT Clauses * Select Element/Value/Raw * SQL-style Select * Select * * Select Distinct * Unnamed Projections * Abbreviated Field Access Expressions * UNNEST Clauses * Inner Unnests * Left Outer Unnests * Expressing Joins Using Unnests * FROM clauses * Binding Expressions * Multiple From Terms * Expressing Joins Using From Terms * Implicit Binding Variables * JOIN Clauses * Inner Joins * Left Outer Joins * GROUP BY Clauses * Group Variables * Implicit Group Key Variables * Implicit Group Variables * Aggregation Functions * SQL-92 Aggregation Functions * SQL-92 Compliant GROUP BY Aggregations * Column Aliases * WHERE Clauses and HAVING Clauses * ORDER BY Clauses * LIMIT Clauses * WITH Clauses * LET Clauses * UNION ALL * OVER Clauses * Window Function Call * Window Function Options * Window Frame Variable * Window Definition * Differences from SQL-92
• 4. Errors * Syntax Errors * Identifier Resolution Errors * Type Errors * Resource Errors
• 5. DDL and DML Statements * Lifecycle Management Statements * Dataverses * Types * Datasets * Indices * Functions * Synonyms * Removal * Load Statement * Modification Statements * Inserts * Upserts * Deletes
• Appendix 1. Reserved Keywords
• Appendix 2. Performance Tuning * Parallelism Parameter * Interval Joins * Memory Parameters
• Appendix 3. Variable Bindings and Name Resolution