#bigquery -- I think Standard SQL should be the default on the web console and to use legacy one would have to check it rather than how it is now.
Conversation
Replying to
If you prefix a query with #standardSQL it should override the default. There is also a Chrome extension which sets the default too:
2