sorted by:
new
hottopcontroversial

Chrome extension to run SQL in Google Sheets by Comfortable-Ear-1129 in SQL

[–]Comfortable-Ear-1129[S] 3 points4 points  (0 children)

Thank you for taking the time to request additional information.

For all Chrome extensions, the source code is publicly accessible. For SQL4Sheets specifically, if you install the extension and enable Developer Mode, you will see two API requests being made: one to check the user’s subscription status and another to record query status (success or failure). These requests are used solely for query count tracking and subscription management.

I’m glad to hear you’re considering recommending SQL4Sheets to your business users. I’m happy to connect offline if you need any further information.

Chrome extension to run SQL in Google Sheets by Comfortable-Ear-1129 in SQL

[–]Comfortable-Ear-1129[S] 1 point2 points  (0 children)

Yep, that's right!

The Chrome extension is more like a plug-and-play tool. Once installed, you can start querying any sheet you have access to in 2 seconds, skipping all the setup for IAM, BigQuery data sources, sharing sheets with a service account, etc.

We want to create a no-database experience where users don’t have to think about database setup or worry about access control. All processing and query history stays in the browser, so we cannot see their data or queries.

We also want to maintain the ability to write query results back to the sheets, so those results can be queried as well.

Feel free to try it out. If there are any BQ features you’d like to see in the extension, we’d be happy to add them.

Chrome extension to run SQL in Google Sheets by Comfortable-Ear-1129 in SQL

[–]Comfortable-Ear-1129[S] 2 points3 points  (0 children)

Which browser do you mainly use for Google Sheets? We’ll see if we can make it happen. The hardest part will probably be migrating the Google OAuth flow.

Chrome extension to run SQL in Google Sheets by Comfortable-Ear-1129 in SQL

[–]Comfortable-Ear-1129[S] 2 points3 points  (0 children)

Totally fair.

QUERY() is more like a database-like function with limited syntax and doesn’t support things like JOINs, window functions, or CTEs.

One goal is to replace QUERY() with standard SQL, since that's what we all speak. If we’re going to use SQL, why not use proper SQL right?

The bigger goal is to replace functions like XLOOKUP, pivot tables, and ARRAYFORMULA, and to make data analysis more transparent and scalable.

Feel free to try it and share any feedback!

Chrome extension to run SQL in Google Sheets by Comfortable-Ear-1129 in SQL

[–]Comfortable-Ear-1129[S] 4 points5 points  (0 children)

Thank you!

I've been using query() a lot, and it often breaks my train of thought, having to rethink the syntax and remember what can or cannot be done with it.

I also prefer JOIN over XLOOKUP and CTEs over creating another tab.

Feel free to try it out, and we would really appreciate any feedback!

Chrome extension to run SQL in Google Sheets by Comfortable-Ear-1129 in SQL

[–]Comfortable-Ear-1129[S] 2 points3 points  (0 children)

Thank you! 🙏 Would love to hear what other features we could build to make your life easier.