We already have some great tools when working with managed or abstracted database layers like ORM's and Doctrine DBAL. And most ORM's allow you to write and execute raw SQL queries when you require ...

I first came across the Value.NativeQuery() M function about six months ago, but it didn’t do anything useful then so I didn’t blog about it. I checked it again recently though and now it does ...

An aggregate function error in SQL occurs when you try to use an aggregate function in a way unsupported by the SQL language. You may experience the error if you do ...

Last year I blogged about how to introduce a delay between web service requests in M code. Since then a new function has been added to Power Query which makes this a lot easier: Function.InvokeAfter() ...

C++ NodeJS module to work with Firebird SQL Server. Uses fbclient library and with a few tweaks it can use libfbembedded var fb = require("./firebird"); sys = require ...

Thanks to the technology behind ChatGPT, it’s become surprisingly simple to query a data set in plain English. As with most generative AI, results from OpenAI’s API are still imperfect, which means ...

In this six-step guide, learn how to use Google's query formula in order to build link analysis dashboards in Google sheets. Analyzing your own link profile as well as your competitors’ is a ...