Hacker News Reader

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.

View on HN

Google sheets already has an inbuilt QUERY function that'll do basic sql..

it 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.

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

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.

Yeah actually I'm thinking on making an extension that you could use from the sheet page. Do you think that would make sense?

Reply on news.ycombinator.com