I tried executing SQL statement containing some geography functions onto a Google BigQuery table with SQLExecutor, but it failed with error saying "ST_* is not supported". It seems that FME cannot execute a query containing geography functions.
It would be nice if FME would fully support the geography functions for Google BigQuery.
cf. https://cloud.google.com/bigquery/docs/reference/standard-sql/geography_functions