How to run a query in Standard SQL dialect?

You can set the SQL variant, either legacy SQL or standard SQL, by including a prefix to your query, e.g.:

#standardSQL
SELECT
  weight_pounds, state, year, gestation_weeks
FROM
 `bigquery-public-data.samples.natality`
ORDER BY weight_pounds DESC
LIMIT 10;