BigQuery launched 'Translate queries' feature to translate a query from a different SQL dialect into a GoogleSQL query.
https://cloud.google.com/bigquery/docs/interactive-sql-translator