4 ms·
Indeed, 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 cr
by tarasyarema 3y ago
Indeed, 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.