Supported SQL Syntax

Supported SELECT Syntax

Non Standard SQL.

• PIVOT. The Google Sheets QUERY pivot option is supported. e.g.:

select bookSales.date, SUM(bookSales.Quantity) from bookSales where customer_id != '' group by date pivot customer_id

• Each unique data point specified by the pivot field will generate a new column for every aggregate function specified in the SELECT fields list.