Still using Windows 3.1? So why stick to SQL-92? A lot has changed in 30 years. We embrace the standard.
Joined February 2015
- Tweets 1,249
- Following 5
- Followers 10,945
- Likes 168
23 Photos and videos
Jun 5
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.
1
2
487
Modern SQL retweeted
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.
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
2
7
889
May 14
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.
1
6
25
1,902
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/…
4
7
1,106
Mar 10
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.
1
6
15
1,179
Feb 6
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
1
1
4
800
Feb 2
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.
2
9
784
Jan 28
The just released version 23.26.1 of the Oracle DB supports the FILTER clause.
modern-sql.com/feature/filte…
2
4
1,169
18 Dec 2025
WITHOUT OVERLAPS Constraints
modern-sql.com/caniuse/witho…
New in PostreSQL 18. Since 9.2, EXCLUDE constraints can be used for the same purpose.
1
4
552
5 Nov 2025
GROUP BY ALL
Very popular, not yet standard but set to become standard. Also expected for PostgreSQL 19.
modern-sql.com/caniuse/group…
2
5
808
Modern SQL retweeted
15 Oct 2025
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.
3
5
14
1,620
Modern SQL retweeted
5 Sep 2025
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.
1
7
20
1,542
11 Mar 2025
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-…
2
10
1,426
Modern SQL retweeted
20 Dec 2024
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
39
3,625
Modern SQL retweeted
9 Dec 2024
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
6
3,412
Modern SQL retweeted
29 Nov 2024
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
2,767
29 Nov 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.
2
1
6
901
29 Nov 2024
This example uses the power horse of the functions that parse JSON in SQL: JSON_TABLE.
2
2
634
29 Nov 2024
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.
modern-sql.com/blog/2017-06/…
———
¹ not only
1
536