Modern SQL

@rwmarti Neither would I expect the order-equivalence rule to cover different SELECTs. The wording is very open. I'm sure it covers different OVER clauses of the same SELECT (and DBMS) though.

@ModernSQL I assume though that two *different* DBMSs do not need to produce the same order for columns that aren’t mentioned in the OVER clause.

Order-equivalent OVER clauses modern-sql.com/blog/2026-03/o… About an important but rarely appreciated aspect when using multiple OVER clauses in a single query.

SQL Comments, Please! modern-sql.com/caniuse/commen… Standard SQL offers two flairs of comments: one starts by two dashes (--) and goes to the end of the line. The other starts with slash-asterisk (/*) and ends with asterisk-slash (*/). #SQL #DuckDB #PostgreSQL #MSSQL

Infinite Recursion Guards modern-sql.com/caniuse/with_r… With recursive is the only SQL construct that is not guaranteed to terminate, eventually. As the DBMS is typically a very crucial system, infinite loops must be prevented at all times. See how various SQL systems help you.

The just released version 23.26.1 of the Oracle DB supports the FILTER clause. modern-sql.com/feature/filter

WITHOUT OVERLAPS Constraints modern-sql.com/caniuse/withou… New in PostreSQL 18. Since 9.2, EXCLUDE constraints can be used for the same purpose.

Adieu Apache Derby, Welcome DuckDB modern-sql.com/blog/2025-12/d…

modern-sql.com now covers DuckDB.

GROUP BY ALL Very popular, not yet standard but set to become standard. Also expected for PostgreSQL 19. modern-sql.com/caniuse/group-…

Oracle 26ai¹ was released yesterday. Noteworthy SQL addition: QUALIFY. modern-sql.com/caniuse/qualify I bet this starts an avalanche (there are already PostgreSQL patches). ¹ 26ai is the marketing version, 23.26.0 is the technical version.

After being « gone fishin' » during summertime I just updated my website for the releases that happened during that time: * MariaDB 11.8 and 12.0 * Oracle 23.9 * Db2 12.1.2 All charts on modern-sql.com and use-the-index-luke.com are updated.

Just updated modern-sql.com and use-the-index-luke.com for MariaDB 11.7. One enhancement is the FROM-clause column renaming, as described in this article: modern-sql.com/caniuse/E051-09

A Christmas present for SQL standard lovers? Part 1 is available for free again. standards.iso.org/ittf/PubliclyA… The last edition that was available for free was 2011, AFAIK. And that disappeared when 2016 was released. Merry Christmas :)

The scraping of content for AI training makes some changes required. I'll publish less on my website and RSS feed. The mailing lists will probably stay the same for the time being. If you want to still get everything, subscribe here: winand.at/lists

Would you miss Apache Derby when I would remove it from the charts on modern-sql.com?

@mortenbraten SQL Server doesn‘t have the JSON_TABLE function, but OPENJSON - the screenshot is not ideal: footnotes broken.

@ModernSQL SQL Server can’t turn JSON into a table? 🥸 This is 2024?

JSON support in SQL is not about storing JSON documents¹. While storing JSON in SQL tables is possible and sometimes quite useful, the true power of JSON in SQL comes from the ability to *process* JSON within SQL.

The other direction (creating JSON in SQL) is also possible. This means, JSON in SQL is very useful as an exchange between your client code and the relational model of your database. #json" target="_blank" rel="nofollow noopener">modern-sql.com/blog/2017-06/w… ——— ¹ not only

This example uses the power horse of the functions that parse JSON in SQL: JSON_TABLE.