Still using Windows 3.1? So why stick to SQL-92? A lot has changed in 30 years. We embrace the standard.
Vienna, Austria
Joined February 2015
- Tweets1.2K
- Following5
- Followers10.9K
- Likes167
Modern SQL retweeted
New post: Structured Primary Keys
For consistency and performance.
modern-sql.com/blog/2026-06/…
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.
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/…
Modern SQL retweeted
modern-sql.com/ now covers DuckDB.
Modern SQL retweeted
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.
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.
Modern SQL retweeted
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 :)
Modern SQL retweeted
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
Modern SQL retweeted
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 Modern SQL retweeted
While the BMP covers the need of most living languages, it lacks support for symbols that made it into informal language (emojis).
Always test your code & engine with non-BPM characters. Ideally one which needs four bytes in the UTF-8 encoding. Here is one for easy c&p: 💩
Modern SQL retweeted
SQL's data types CHAR and VARCHAR are about characters. Sounds like a no-brainer, doesn't it?
Well, a consequence is that the number in the parenthesis refer to characters, not bytes.
Unfortunately, some SQL engines don't get that right—causing major confusion among users.
Modern SQL retweeted
Support FILTER WHERE inside aggregate functions in standard SQL の issue は2016年からあるけど音沙汰なしなのでわかる
issuetracker.google.com/issu…
SQL's FILTER clause should be easy to implement for every engine. Why is it still not supported widely?
Sure it can be emulated easily—and ugly. The value on readability (and learning) is huge.
Please vendors: Just get it done.
modern-sql.com/feature/filte…
Modern SQL retweeted
Learn once, benefit forever.
These SQL courses take experienced developers a leap forward. Starting on September 10th!
winand.at/en/newsletter/2024…
Modern SQL retweeted
Slides from the presentation I gave yesterday at the Enterprise Java user Group in Linz:
modern-sql.com/slides/while-…
Modern SQL retweeted
GQL was released yesterday. SQL got a sibling!
7-page description from the people making it is available on LinkedIN: linkedin.com/feed/update/urn…
Short note by Peter Eisentraut: peter.eisentraut.org/blog/20…
Modern SQL retweeted
WHERE col IS JSON [ARRAY|OBJECT|SCALAR]
Test for Valid JSON, Distinguish between Arrays, Objects and Scalars
modern-sql.com/caniuse/is-js…
Modern SQL retweeted
There is currently some fuzz about the performance of subqueries vs with clause.
Here is my take on it:
modern-sql.com/feature/with/…
Modern SQL retweeted
If you read the article on ANY_VALUE, please case your vote!
Article on ANY_VALUE:
modern-sql.com/caniuse/any_v…
The poll: xitter.cf/MarkusWinand/status/17…
Modern SQL retweeted
What would you SQL engine to support?
27%any_value
59%functional dependencies
10%unique_value
5%not enforced trusted
41 votes • Final results Modern SQL retweeted
ANY_VALUE(…): New in SQL:2023—but do we need it?
modern-sql.com/caniuse/any_v…