sql joins in apps script

SQL for Apps Script – it’s here

While working on Sheets Workbook functions – converted to Apps Script I realized that I’d need to tackle the query language at some point, so I figured I may as well go the whole hog […]


Flattening arrays for Elastic Search

The data that comes back from GraphQL is not ideal for input to Elastic Search which is designed for full-text searching, which means it loses context when searching arrays. Consider this response from some fictional […]

Excel and SQL

Execute SQL from Excel

What can you learn here? Library of ADODB connections Populate from databases Use SQL on closed workbooks   A library to populate Excel tables with SQL query results get it now Using SQL to populate Excel […]