4 ms·
This would be interesting to use not as an external UI but rather completely inside of Sheets. Maybe as a function or something like that.
by brap 3y ago
This would be interesting to use not as an external UI but rather completely inside of Sheets. Maybe as a function or something like that.
- tarasyarema 3y agoYeah actually I'm thinking on making an extension that you could use from the sheet page. Do you think that would make sense?
- ramraj07 3y agoGoogle sheets already has an inbuilt QUERY function that'll do basic sql..
- gpderetta 3y agoit is better than messing around with vlookup (what isn't), but only a tiny subset of sql is supported (with dedicated syntax). Also it claims to support actual human readable column names but as far as I know it doesn't work and you have to use column labels. Also no joins. Still, if it were to be extended to a full query language with good ergonomic it would be amazing.
- tarasyarema 3y agoIndeed, you can run queries in a sheet, but 1. It's writing a query in a single row cell which is hard from a UX perspective 2. SheetSQL offers you a way to cross join sheets as if those where tables, even between worksheets, which is something that is not supported natively 3. Full DuckDB SQL support, so you can use advanced functions like PIVOT or window functions
- antender 3y agoThis is not exactly true, QUERY pseudoSQL is available, but as a separate API not listed in Sheets Docs: https://developers.google.com/chart/interactive/docs/querylanguage https://developers.google.com/chart/interactive/docs/queryla... I used it as a DB for Cloudflare Workers, the only hard part is Google Auth.