Chapter SQL Syntax

Table of Contents

Lexical Structure

Identifiers and Key Words

Constants

Operators

Special Characters

Comments

Operator Precedence

Value Expressions

Column References

Positional Parameters

Subscripts

Field Selection

Operator Invocations

Function Calls

Aggregate Expressions

Window Function Calls

Type Casts

Collation Expressions

Scalar Subqueries

Array Constructors

Row Constructors

Expression Evaluation Rules

Calling Functions

Using Positional Notation

Using Named Notation

Using Mixed Notation

This chapter describes the syntax of SQL. It forms the foundation for understanding the following chapters which will go into detail about how SQL commands are applied to define and modify data.

We also advise users who are already familiar with SQL to read this chapter carefully because it contains several rules and concepts that are implemented inconsistently among SQL databases or that are specific to ProtonBase.