Google BigQuery IDE options?

bigquery

#1

Right now I’m writing SQL queries in the Google web UI for Bigquery but… it leaves a lot to be desired. Is there a better option? I need to be able to use Standard SQL not legacy SQL because I have partitioned tables.