@ModernSQL

Still using Windows 3.1? So why stick to SQL-92? A lot has changed in 30 years. We embrace the standard.

 Vienna, Austria
modern-sql.com
Joined February 2015
  • Tweets1.2K
  • Following5
  • Followers10.9K
23Media
New post: Structured Primary Keys For consistency and performance. modern-sql.com/blog/2026-06/…

Structured Primary Keys

Structured primary keys prevent contradiction and perform better than surrogate keys

modern-sql.com
2
3
15
1,768
The SQL/JSON Path item-method .keyvalue() has an interesting history in the Oracle Database. modern-sql.com/caniuse/keyva… In 23.26.2 it works, but not in ?( filter ) context.

.KEYVALUE() (SQL/JSON Path Item Method)

.KEYVALUE() JSON/Path: Transform Object Attributes into Array Elements

modern-sql.com
2
3
899
Modern SQL retweeted
Markus Winand@MarkusWinandJun 1
MariaDB 12.3.2 was released last week. It's the first "stable" version of the long-term supported (LTS = 3 years) 12.3 branch. An SQL dialect enhancement is the IS JSON predicate. Also: a bug I reported is fixed (MDEV-38835). All charts on modern-sql.com are updated.
Chart showing the extent of support for SQLs IS JSON test: Full H2 support since 1.4.200. Full PostgreSQL support since 16. Full MariaDB support since 12.3.2. Partial Oracle DB support since 21c.

ALT Chart showing the extent of support for SQLs IS JSON test: Full H2 support since 1.4.200. Full PostgreSQL support since 16. Full MariaDB support since 12.3.2. Partial Oracle DB support since 21c.

1
3
11
1,287
ORDER BY Has Come a Long Way modern-sql.com/blog/2026-05/… The ORDER BY clause is one of the best-known SQL clauses. Yet there are a number of common misunderstandings that are worth clearing up. The article walks you through the evolution of the ORDER BY clause in the SQL standard.

SQL’s ORDER BY Has Come a Long Way

ORDER BY Evolution

modern-sql.com
1
7
1
26
2,270
On HN: news.ycombinator.com/item?id…
294
Modern SQL retweeted
SQL Daily@sqldailyMar 25
Should these functions return the same value? SELECT ROW_NUMBER() OVER (ORDER BY x), ROW_NUMBER() OVER (ORDER BY x) FROM ... What about when many rows have the same value for X? According to the #SQL standard: yes @MarkusWinand investigates modern-sql.com/blog/2026-03/…

Do identical OVER clauses always produce identical row orders?

Order-Equivalence

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

Do identical OVER clauses always produce identical row orders?

Order-Equivalence

modern-sql.com
1
7
16
1,482
SQL Comments, Please! modern-sql.com/caniuse/comme… 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

SQL /* comments */ can be nested

C-style comments work in SQL, with nesting

modern-sql.com
1
1
4
837
Infinite Recursion Guards modern-sql.com/caniuse/with_… 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.

Infinite Recursion Guards

Protection against infinite loops for WITH RECURSIVE.

modern-sql.com
2
9
808
The just released version 23.26.1 of the Oracle DB supports the FILTER clause. modern-sql.com/feature/filte…

The FILTER clause

The FILTER clause extends aggregate functions (SUM, AVG, COUNT, etc.) with an additional WHERE clause. Databases not supporting FILTER can use CASE within the aggregate function instead.

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

WITHOUT OVERLAPS Constraints

PRIMARY KEY (id, period WITHOUT OVERLAPS)

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

DuckDB Coverage

Apache Derby is retired, ModernSQL now covers DuckDB instead

modern-sql.com
6
25
3,500
modern-sql.com/ now covers DuckDB.

Modern SQL: A lot has changed since SQL-92

SQL has evolved. Beyond the relational model. Discover it now.

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

GROUP BY ALL

Automatically put non-aggregate SELECT items into GROUP BY clause

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

QUALIFY clause (window functions)

QUALIFY: filter rows based on window functions

modern-sql.com
3
5
1
14
1,650
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.

Modern SQL: A lot has changed since SQL-92

SQL has evolved. Beyond the relational model. Discover it now.

modern-sql.com
1
7
20
1,560
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-…

Modern SQL: A lot has changed since SQL-92

SQL has evolved. Beyond the relational model. Discover it now.

modern-sql.com
2
1
10
1,434
A Christmas present for SQL standard lovers? Part 1 is available for free again. standards.iso.org/ittf/Publi… The last edition that was available for free was 2011, AFAIK. And that disappeared when 2016 was released. Merry Christmas :)
1
22
1
39
3,637
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
2
1
6
3,418
Would you miss Apache Derby when I would remove it from the charts on modern-sql.com?
1%Yes
79%No
20%(show results)
91 votes • Final results
2
1
1
1
2,782
Load more