Skip to content

Supported SQL Syntax

Jump to bottom
Chris Demmings edited this page Jun 21, 2022 · 1 revision

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.

Clone this wiki locally