It is encouraged to use Standard SQL for Google BigQuery if you are developing a new applicatoin. This has more features than the legacy SQL. If you have old apps using legacy SQL then upgrade them to use Standard SQL.