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
@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
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
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
@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
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
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