I really don't like writing all of my queries within a browser, and would like to integrate VC into our team's process.
I really don't like writing all of my queries within a browser, and would like to integrate VC into our team's process.
I would recommend superQuery. It's a full-fledged IDE for Google BigQuery with all the features you would like to find in modern IDE, web-based, including multi-tab, collaboration, git integration, cost controls, result visualizations, shareable boards, auto-complete and more!
P.S. Full disclosure, I work for DoiT International who has recently acquired superQuery.
BigQuery does have ODBC and JDBC drivers which should allow you to connect to it via most SQL tools, although performance will not be equivalent to native BigQuery operations/query. If what you want is better visualization and navigation support, Google DataStudio using BigQuery may be useful. Aqua Data Studio has also recently built support for BigQuery.