Google Sheets SUPERSQL QUERY Function - Apps Script SQL AlaSQL UDF - Part 1

This tutorial covers how to create SUPERSQL QUERY Function in Google Sheets using Apps Script, AlaSQL and JavaScript. With this function we'll be able to execute SQL like statements on ranges of data, including join statements.

Series Playlist:

 #SUPERSQL #GoogleSheets #alasql

[leonlysak]

Just giving you another boost with the YouTube algo because you're an amazing teacher. Keep up the good work man

[vinodkumarPrajapativnd]

Just amazing. No words to describe how useful your efforts are. Due to lack of database query language in GAS I used to make my own query functions painfully. hopefully I'll able to translate them with this solution.

[deepouterspace]

Fantastic! Thanks a lot for this tutorial! Incredibly useful.

[carmencastro]

Todos hablan del virus pero este hombre sigue en lo suyo, Love u....

[rogerangel]

we need more people like you my guy :)

[TrollNithyanandaTrollers]

Just Genius you are man!! Thanks a lot

[johnmillersr.colorado]

Yes, you are amazing! I've wanted to see if SQL could be used in Google Sheets and the way you approached this was fascinating! BTW, as I watched you searching for the error I was hopping up and down, raising my hand, hoping you'd see the extra right parin. You've probably found it afterward, no doubt.

[vkkkvk-rm]

Thank you for the video. I was just thinking about how to merge the data from the two tables.

[AnthonyYandow]

I love love love your videos and content! Please keep it up!

[vegasilkit]

So you could theoretically update a master list from another sheet that has record changes?

[Cleuton]

Hello. I wonder if it is possible to do research in the spreadsheet with webapp. I have a very large online spreadsheet and it is slow to load data. I would just like a single line.

[GIU]

yes i do with mor tables, it works, but how to set the source as global lib for all used sheets and use directly from sheets syntax

[ganeshborude]

Very informative video sir. Just a small question. can we use cluses like "group by", "having" and also if I want the data in an "ascending" or "descending" order, can I use these conditions in query?

[passangtsheringtamang]

How to perform count function in apps script similar to countif fuction.

[rainierh]

Hello, this function is very helpful, thanks.
I am trying to filter by date with "SELECT * FROM ? WHERE recordDate= "2023-07-12", but is not working. Can you help me with the correct sintax?

[cristianidade]

Please, how to run a UPDATE sql comand using SUPERSQL? I need this so much ;)

[bhavyashreesarvamangala]

Can u pls tel me how to import data from metabase to google sheet with out downloading data pls reply I need to automate report no one Is helping

[quocbvo]

Hello,
I am getting this error message.
TypeError: cannot read property 'shift' of undefined.
I did test alasql by the following step, but still get that message.
May you please help me with this error. What am I missing?
I am using alasql version: 0.6.2

Thanks

[openinterestanalysis]

hi sir, is it possible to convert excel vba to google apps scripts... i have excel with vba, how to convert it to gas sheet

[mask]

Hey you can start Online classes and become pro like you. I will join but please keep prices affordable.