News for hackers. Stuff that matters.

A comment on Show HN: Query Your Sheets with SheetSQL. Parent comment

Re:Show HN: Query Your Sheets with SheetSQL by tarasyarema on Wednesday March 13, 2024 @09:03AM (#39690858)
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

[ Parent | on HN ]
Re:Show HN: Query Your Sheets with SheetSQL by antender on Friday March 15, 2024 @07:37AM (#39714388)
This 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/queryla... I used it as a DB for Cloudflare Workers, the only hard part is Google Auth.
[ Parent | on HN ]