Accepts a select query as a string input Converts query into a dict of 'simple' select queries, linked to each other through 'from' statements. A 'simple' select query is a select query without any ...

The output of a SELECT statement is called results or a result set as it’s a set of data that results from a query. SELECT * - referred to as a 'select star statement' The query below selects customer ...

Here’s something that will Blow Your Mind if you’re a Power Query/M fan. Did you know that there’s a way you can get query folding to work if you’re using a native SQL query on SQL Server or Postgres ...

In this final post of our four-part JSON series, we showcase the ability to format query results as JSON text using the FOR JSON clause. If you are familiar with the FOR XML clause, you will easily ...

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 ...

I have written an application that takes in a fixed-width file (thanks in no small part to advice I recieved in a seperate thread) and then dissasembles each line, runs a fairly meaty SQL SELECT query ...