Yes, BigQuery now supports SQL DML with standard SQL (uncheck “Use Legacy SQL” under “Show Options”). SQL DML is not supported with legacy SQL.

Official documentation is available here: https://cloud.google.com/bigquery/sql-reference/data-manipulation-language

NOTE: UPDATE, DELETE and MERGE DML statements are supported over tables with streaming buffer as long as the statement doesn't affect rows that are in the streaming buffer.