Queries

SQL Queries against the tables that represent Google spreadsheets are the same as any other SQL queries (see Using ADO.NET). However the values of the columns depend on the data query specification being used against the Google servers.

SELECT Queries

The criteria of SELECT queries is comprised of the Query pseudo-column (see SELECT Statements for more information on pseudo-columns). So for instance if you wanted to retrieve only the rows of the spreadsheet whose Column1 value is greater than 100, you would do:

SELECT * FROM MySpreadSheet Where Query="Column3 > 100"

The value that we are passing to Query conforms to the Structured Query syntax described in Google's Spreadsheet API document (see here). Note that the URL encoding is handled by the provider.

While not supported in this beta, we intend to have the full version release support the Google Visualization API Query Language against the tables by setting the Query pseudo-column. To support this query format the 'Structured Query' connection setting must be set to false (default value is true which means that queries are interpreted as structured queries). To find out more about the Google Visualization API Query Language click here.

UPDATE and DELETE Queries

All update and delete SQL queries are based on the Id column which is always available. Id contains the unique URI of the row of that spreadsheet on the Google servers.