SeaQuery is a query builder to help you construct dynamic SQL queries in Rust. You can construct expressions, queries and schema as abstract syntax trees using an ergonomic API. We support MySQL, ...

With the official release of Microsoft's latest database offering, let's see what was improved and what still needs some work. Today, at Ignite, Microsoft announced the general availability of SQL ...

Why is the language developers and DBAs use to organize data such a mess? Here are 13 reasons we wish we could quit SQL, even though we probably won't. For all its popularity and success, SQL is a ...

Written by Andrew Stiefel, Endor Labs. AI coding assistants are changing the game for developers. They offer speed, convenience, and a way to fill knowledge gaps for busy engineering teams. With just ...

In the world of data analytics and modern SQL querying, two advanced yet essential topics stand out: Window Functions and Common Table Expressions (CTEs). Understanding and mastering these tools can ...

MySQL and PostgreSQL are two of the most used open source SQL databases, and both fulfill the role of a general-purpose database well. How do you choose which one to use for a project? Let's look at ...

A (somewhat opinionated) list of SQL tips and tricks that I've picked up over the years. There's so much you can do with SQL but I've focused on what I find most useful in my day-to-day work as a data ...

Today I learned that you can have multiple CTEs within a single PostgreSQL query. And, that these CTEs can reference each other. So freaking cool! To demonstrate, I'm going to build-up a SQL query ...

The automation of repetitive tasks has become part of today’s workplace, whether CPAs are engaged in industry, governmental, not-forprofit, or public accounting. This automation can consist of ...

A few days ago I was tagged on a thread on Twitter: my old pal Mim was upset to find that he couldn’t use a SQL query with a Common Table Expression as the source of a table in DirectQuery mode. He ...