Supported SQL and Postgis Syntax

Select
Currently only with one table: joins are not supported.
FROM
Data source (either Google Fusion table ID, or Earth Engine Image ID).
Where
  • >, <, >=, <=, <>, =
  • LIKE, NOT LIKE
  • NOT
  • AND, OR
  • IN
  • IS
Feature Collection Functions
  • COUNT
  • SUM
  • AVG
  • MAX
  • MIN
  • FIRST
  • STDEV
  • VAR
  • LIMIT
Postgis-like Raster Functions
  • ST_METADATA
  • ST_BANDMETADATA
  • ST_SUMMARYSTATS
  • ST_HISTOGRAM

We will add support for more language features as time goes on.