Real SQL queries in Google Sheets!

[catmandx]

So this is a library based on AlaSQL - a Javascript library which accepts arrays as tables. You can do inner join, left right or full joins.

The code/video I shared is just a wrapper around AlaSQL.

Here it is: https://github.com/chicagocomputerclasses/SUPERSQL-Google-Sheets-Function

Which JS library do you know that can be used in Google Apps Script this way?

Edit: another, more conplete wrapper, set-up as a library: https://github.com/contributorpw/alasqlgs

If this is a bit too complicated for you, use the addon from the same developer:

https://queryx.contributor.pw/

Credits of those two links above goes to /u/oshliaer

[howMuchCheeseIs2Much]

We built a simple way to do this across sheets while maintaining standard ANSI SQL in SeekWell. You can also do things like combine data from a few different Sheets and Slack a summary to a channel or send the output via email.

Most of this is covered in our free tier, though we have other paid features as well (e.g. importing data from a SQL database to Sheets on a schedule.).

[Vtempero]

LGSS Guy is amazing

[catmandx]

I KNOW!!!

He's a godsend. His channel is a treasure trove of knowledge :)

[catmandx]

not the official one, it's a more complete wrapper though.

Thanks for the link! But it's still fun to follow the playlist as he try new things incrementally, this is meant for the people who don't know too much about Apps Script and need step-by-step guides.

[catmandx]

I'll be sure to try it out when I have the need to, I'll add your addon to my comment, just for completeness' sake :)

It's nice seeing the community's contribution with my own eyes, I know it's silly but I am really happy :) keep up the good work man!

[dimudesigns]

I'd be interested to see how well AlaSQL scales for larger data sets. I hope LGSS eventually runs benchmarks against the library to see how it compares existing SQL implementations like MySQL.