The SQL/JSON Path item-method .keyvalue() has an interesting history in the Oracle Database.
modern-sql.com/caniuse/keyval…
In 23.26.2 it works, but not in ?( filter ) context.
modern-sql.com/caniuse/keyval…
In 23.26.2 it works, but not in ?( filter ) context.
0
2
3
901
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.
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.
1
3
11
1,288
ORDER BY Has Come a Long Way
modern-sql.com/blog/2026-05/o…
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.
modern-sql.com/blog/2026-05/o…
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
7
26
2,272
order byでのnullの扱い、各DBで異なるなとは思っていたけど、DuckDBだけascでもdescでも常に最後になるのか。（nulls firstはできる）
PostgreSQLがorder by 句に式を使えないのも意外
PostgreSQLがorder by 句に式を使えないのも意外
ORDER BY Has Come a Long Way
modern-sql.com/blog/2026-05/o…
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.
2
0
1
338
@damassima For the avoidance of misunderstandings: PostgreSQL *can* use expressions in ORDER BY, but they must not contain the names of columns from the SELECT clause.
1
0
0
122
Modern SQL retweeted
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/o…
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/o…
0
4
7
1,133
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.
modern-sql.com/blog/2026-03/o…
About an important but rarely appreciated aspect when using multiple OVER clauses in a single query.
1
7
16
1,483
@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.
1
0
0
89
@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.
0
0
1
43
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
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
1
1
4
838
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.
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.
0
2
9
810
The just released version 23.26.1 of the Oracle DB supports the FILTER clause.
modern-sql.com/feature/filter
modern-sql.com/feature/filter
0
2
4
1,218
WITHOUT OVERLAPS Constraints
modern-sql.com/caniuse/withou…
New in PostreSQL 18. Since 9.2, EXCLUDE constraints can be used for the same purpose.
modern-sql.com/caniuse/withou…
New in PostreSQL 18. Since 9.2, EXCLUDE constraints can be used for the same purpose.
1
0
4
568
GROUP BY ALL
Very popular, not yet standard but set to become standard. Also expected for PostgreSQL 19.
modern-sql.com/caniuse/group-…
Very popular, not yet standard but set to become standard. Also expected for PostgreSQL 19.
modern-sql.com/caniuse/group-…
0
2
5
820
Modern SQL retweeted
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.
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.
3
5
14
1,652
Modern SQL retweeted
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.
* 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,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-09
One enhancement is the FROM-clause column renaming, as described in this article: modern-sql.com/caniuse/E051-09
0
2
10
1,434
Modern SQL retweeted
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 :)
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 :)
1
22
39
3,637