Logo
Picture

Modern SQL @ModernSQL

Still using Windows 3.1? So why stick to SQL-92? A lot has changed in 30 years. We embrace the standard. modern-sql.com Vienna, Austria Joined February 2015
  • Tweets
    1K
  • Followers
    11K
  • Following
    5
  • Likes
    168
ModernSQL Profile Picture

Modern SQL @ModernSQL

2 hours ago

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 retweeted
MarkusWinand Profile Picture

Markus Winand @MarkusWinand

4 days ago

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.

ModernSQL Profile Picture

Modern SQL @ModernSQL

3 weeks ago

On HN: news.ycombinator.com/item?id=481367…

ModernSQL Profile Picture

Modern SQL @ModernSQL

3 weeks ago

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.

ModernSQL Profile Picture

Modern SQL @ModernSQL

3 weeks ago

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

Modern SQL retweeted
sqldaily Profile Picture

SQL Daily @sqldaily

2 months ago

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…

ModernSQL Profile Picture

Modern SQL @ModernSQL

3 months ago

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

ModernSQL Profile Picture

Modern SQL @ModernSQL

3 months ago

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.

ModernSQL Profile Picture

Modern SQL @ModernSQL

4 months ago

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

ModernSQL Profile Picture

Modern SQL @ModernSQL

4 months ago

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.

ModernSQL Profile Picture

Modern SQL @ModernSQL

4 months ago

The just released version 23.26.1 of the Oracle DB supports the FILTER clause. modern-sql.com/feature/filter

ModernSQL Profile Picture

Modern SQL @ModernSQL

6 months ago

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

ModernSQL Profile Picture

Modern SQL @ModernSQL

6 months ago

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

Modern SQL retweeted
MarkusWinand Profile Picture

Markus Winand @MarkusWinand

6 months ago

modern-sql.com now covers DuckDB.

ModernSQL Profile Picture

Modern SQL @ModernSQL

7 months ago

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

Modern SQL retweeted
MarkusWinand Profile Picture

Markus Winand @MarkusWinand

8 months ago

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.

Modern SQL retweeted
MarkusWinand Profile Picture

Markus Winand @MarkusWinand

9 months ago

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.

ModernSQL Profile Picture

Modern SQL @ModernSQL

a year ago

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

Modern SQL retweeted
MarkusWinand Profile Picture

Markus Winand @MarkusWinand

a year ago

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 :)

Modern SQL retweeted
MarkusWinand Profile Picture

Markus Winand @MarkusWinand

2 years ago

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

Trends for United States

Good Friday
Platner
Maine
Save Act
#TheLiesOfIsrael
Collins
#NationalDonutDay
#LaSayoPidiendoCacao
RED Friday
#FursuitFriday
Happy Friyay
Tillis
Tillis
Muncy
Monochromatic
hyuna
#FridayVibes
$ZEC
Zcash
March and April

You might like

PostgreSQL - The world's most advanced Open Source Database
PostgreSQL
@PostgreSQL
57K Followers
SQL Renaissance Ambassador. Author, Trainer, Coach. PhD in Common Sense. Creator of https://t.co/6oKhq87B43 and https://t.co/RrIy2AY7Tl.
Markus Winand
@MarkusWinand
9K Followers
Daily Oracle SQL tips from the Oracle Developer Advocates for SQL
SQL Daily
@sqldaily
26K Followers
Blog entries from members of the PostgreSQL community
Planet PostgreSQL
@planetpostgres
44K Followers
The world's most popular open source database
MySQL
@MySQL
227K Followers
postgresql consultant
Hans-Jürgen Schönig
@postgresql_007
2K Followers
Knowledge Base of Relational and NoSQL Database Management Systems
DB-Engines
@DBEngines
3K Followers
The Postgres Conference series of the world. Online and in-person! Join us in celebrating People, Postgres, Data! News: @postgresworld
PostgresConf
@postgresconf
3K Followers
Simplicity nerd. Engineer @Atlassian. Occasional writer. Book: https://t.co/TWbIsTaLub. Newsletter: https://t.co/c4nrYan90A.
Tom Hombergs
@TomHombergs
5K Followers
Microsoft SQL delivers a unified, secure SQL experience from ground to cloud, helping teams build AI‑ready, high‑performance applications anywhere.
Microsoft SQL
@SQLServer
259K Followers
SQL Community led by SQL Server obsessives. We share knowledge around SQL, Azure & related technologies through our blogs, webcasts & in-person events.
SQLServerGeeks.com
@SQLServerGeeks
4K Followers
This is a group for MySQL developers/DBAs to expand their expertise, share ideas, and help develop better applications
MySQL Community Team
@mysql_community
16K Followers
The leading Postgres data and AI company
EDB
@EDBPostgres
9K Followers
Fully managed, hosted Postgres on AWS, GCP, and Azure.
Crunchy Data
@crunchydata
8K Followers
https://t.co/XG2T4YY1Fh SQL Server Master Classes, Video Courses, Hands-On-Labs & more...
SQLMaestros
@SQLMaestros
2K Followers