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:
https://www.youtube.com/playlist?list=PLv9Pf9aNgemvJdbQrfqXIRs8ssNujA8Vz
https://github.com/chicagocomputerclasses/SUPERSQL-Google-Sheets-Function
https://github.com/chicagocomputerclasses/alasql
To understand this video you need to understand JavaScript array methods. You can learn about them in this playlist https://youtu.be/tZdSa6p3PHQ?list=PLv9Pf9aNgemvD9NFa86_udt-NWh37efmD
#SUPERSQL #GoogleSheets #alasql