gsSQL
gsSQL copied to clipboard
demmings
Use real SQL SELECT syntax to filter your Google Sheets data using a simple custom function.
So ``` =gsSQL("select * from booksales where Date > '5/3/2022' ", "booksales", BookSales!A1:H) ``` is including records with TEXT CHARACTERS in the Date column. My comparisons to mySQL don't have...
1ZfedAgGG2K5kPLC2NPfe0Kb1xAg-0gvmliR3V8pRNk6DZMTUQyCbMW1W not working 
In order for my tests to always work, I added this as a test for dateDiff() so that it would always return '7'. There is something wrong with the ROUNDING....
* Getting a warning about a regex used to extract ORDER BY * Not currently causing any problems, other than a warning. ``` Make sure the regex used here, which...
The SUM() aggregate fields will return the correct values if used as the single source of info for the select field, but it fails when a calculation is done using...
``` =gsSQL("select sum(net_income_from_taxable) as 'Net Income from Taxable', sum(gross_taxable_income) as 'Total Gross Income' from income where age > ?1 and age
Implicit SELF JOIN is not supported. `select A.name as custname1, B.name as custname2 from customers as A, customers as B where A.id B.id ` This statement does not work with...