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-
Tweets1K
-
Followers11K
-
Following5
-
Likes167
New post: Structured Primary Keys For consistency and performance. modern-sql.com/blog/2026-06/s…
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.
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.
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.
@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.
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…
@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.
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.
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
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.
The just released version 23.26.1 of the Oracle DB supports the FILTER clause. modern-sql.com/feature/filter
WITHOUT OVERLAPS Constraints modern-sql.com/caniuse/withou… New in PostreSQL 18. Since 9.2, EXCLUDE constraints can be used for the same purpose.
Adieu Apache Derby, Welcome DuckDB modern-sql.com/blog/2025-12/d…
modern-sql.com now covers DuckDB.
GROUP BY ALL Very popular, not yet standard but set to become standard. Also expected for PostgreSQL 19. modern-sql.com/caniuse/group-…
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.
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.
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
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 :)
javinpaul @javinpaul
106K Followers 7K Following Blogger - https://t.co/Cxgp9zzN3y Creator - https://t.co/GYls4Lx9DW newsletter - https://t.co/P8jiQ5GW16 youtube - https://t.co/vs4WjwaEQ6
Franck Pachot @FranckPachot
18K Followers 2K Following Principal PM @microsoft 🥑Developer Advocate @MSFTforPostgres 🐘PostgreSQL,▝▞ YugabyteDB, 🍃MongoDB, 🅾️Oracle, 🔶AWS Data, Xposting to bsky/mstdn/lnkdn
Maciej Walkowiak 🍃 @maciejwalkowiak
40K Followers 944 Following Freelance Java Consultant - Java, Spring Boot, AWS 👉 https://t.co/5hDONs8nrh 📺 https://t.co/xtk152k8qm
Tobias_Petry.sql @tobias_petry
25K Followers 312 Following The Database Guy. I am helping you get better with MySQL and PostgreSQL. ⚡️ https://t.co/WwHTfJFoA5 📝 https://t.co/zJpXKSTKve 🛠️ @stackbricksapp
Simon Martinelli @simas_ch
10K Followers 2K Following Creator of the AI Unified Process. Java Champion, Vaadin Champion, Oracle ACE Pro, Author, Speaker, Programming Architect, and Lecturer.
Markus Winand @MarkusWinand
9K Followers 256 Following SQL Renaissance Ambassador. Author, Trainer, Coach. PhD in Common Sense. Creator of https://t.co/6oKhq87B43 and https://t.co/RrIy2AY7Tl.
Aaron Francis @aarondfrancis
64K Followers 2K Following Sincere poster. No cynicism. Dad to two sets of twins! - VP Marketing & Community @laravel - Creator https://t.co/QG0tWQcm92 - @MostlyTechPod
Kim Berg Hansen {Inac... @kibeha
3K Followers 187 Following {Inactive - find me at kibeha dot dk where the sky is #0000FF}
lefred - @lefredbe.bs... @lefred
4K Followers 604 Following MariaDB Community Advocate. All you need to know is on https://t.co/AJYprUUNWJ ;-)
Lætitia @l_avrot
2K Followers 199 Following Postgres women founder, PostgreSQL Europe treasurer, PostgreSQL recognized contributor. Field CTO at EDB. Opinions are my own.
A J @alexjordan3090
40 Followers 4K Following Data Analytics Data Science Artificial intelligence and Machine Learning CyberSecurity AI Governance
Legacy @Legacyvus
1 Followers 36 Following
Jose Pablo Espinoza @_joseeb
46 Followers 619 Following
José Marcio Godoy da @silvajmg
991 Followers 5K Following IT Analyst. Opinions are my own and don't represent @Dataprev. RTs denote interest, not endorsement.
USA 🇺🇸 @ContraFula27024
49 Followers 926 Following God, grant me the serenity to accept the things I cannot change, the courage to change the things I can, and the wisdom to know the difference
Meet @Meet19071996
0 Followers 54 Following
O.B Sehlabi @Obed_Sehlabi
0 Followers 15 Following
Chamnol Kiy @kiy54213
0 Followers 54 Following
Big7 @Rendani30683406
0 Followers 90 Following
FreeDom Yemen @Face_Freedom
371 Followers 3K Following إذا اعتاد الملوك على الهوان فذكرهم بأن الموتَ دانِ
El Byron @quiroz_jho62068
5 Followers 313 Following Aceleraciónista digital - Evangelista de las máquinas . Nos vamos a ir todos a la mierda si no paran está vuelta.
Vipin gangwar @vipinga01459833
15 Followers 172 Following
Ernesto Chapon 🇺�... @turecochapon
730 Followers 917 Following 🇺🇦 Noctívago, repto entre funciones y ciclos de reloj. Tuiteo porque mis pruritos cerebrales me impelen a hacerlo. ! AutoFollowBacks()
Amandeep Singh Johar @techgeekaman
1 Followers 227 Following
Bernardo Lopez @bernardolop93
301 Followers 2K Following
SCOTLY VICTOR @SCOTLYVICTOR
207 Followers 426 Following
Softilium @softilium
18 Followers 245 Following
Alexander Ioffe @deusaquilus
2K Followers 216 Following Take control of your database with https://t.co/7XQQ7Drvpn the only LINQ for Kotlin!
Jordan Milushev @JordanMilushev
40 Followers 99 Following Software Engineer, DBA, Dad, Husband, Human
Perkins Research @PerkinsResearch
17 Followers 636 Following Visualizin' the realism of life in actuality
Stanley Ikechukwu @StanleyIke80787
28 Followers 96 Following I’m Stanley. Applied Mathematics graduate. Interested in data, problem-solving, and building practical solutions.
Horacio Castillo @HR_Castillo
1K Followers 3K Following Dad. SQL Developer. Cook & Photo hobbyist. Running newbie. Data Scientist in the making. #Fintech enthusiast. Scuba Diver 🤿
shazz @sharadkulloli
33 Followers 730 Following
Haßlocher t(￣へ�... @hablocher
48 Followers 329 Following Tsundoku, Father, husband, comic fan, movie fan, gamer, nature lover, stoic, secularist, misanthropist AND humanist. Strange? :
Darek Magusiak @demagu
158 Followers 552 Following
Arthur Yates @arthur_yates
79 Followers 1K Following
Maikel van Gorkom @maikelvangorkom
115 Followers 661 Following
M.Daniyal M.D @DanzoMD
539 Followers 3K Following To serve a community is an honor and legacy no one can take away from you. #togetherness #compassion #goleafsgo #bleedbluenwhite
Edwin Tierra @eatierra
2 Followers 110 Following
Carlos Pabon @charlespeibon
400 Followers 1K Following Venezolano - El éxito es aprender a ir de fracaso en fracaso sin desesperarse. - Winston Churchill
Diego Ripera @diegoripera
353 Followers 2K Following El conocimiento no es propiedad de nadie sino que es como la energía; simplemente fluye, se transforma y nos transforma. Gracias a Dios por la vida.
Edgar @shinigami_1234
5 Followers 171 Following
datathink @datathinkHQ
0 Followers 54 Following Develop the reasoning that makes you effective with data. Premium interview practice for data engineers, analysts, scientists & AI roles. https://t.co/64Nss3sAtX
Vineet Goyal @VineetG79015537
1 Followers 26 Following
cloudsystem @CloudsystemNet
260 Followers 2K Following Building the Operating System for the Global AI Economy
Ádám Lippai @alippai
467 Followers 2K Following The rainbow in the cloud Developer @worldquant, previously @tresorit Views my own, retweets are not endorsements He/him
Guillem Casacuberta @_gcasacuberta
142 Followers 551 Following
abdulla wasay @wasay7
436 Followers 876 Following لا إله إلا الله محمد رسول الله xDCSian - University of Karachi
Civilian Guru ☠️ @ThabisoKG
118 Followers 784 Following 🌐 Web Development 🎨 FrontEnd 🦏 Javascript 🏗️ Building online 🔧 DevOps 🚀UI/UX 💻Software Development
Moreal @dev_moreal
178 Followers 654 Following
Michele Henry @michele_henry
3K Followers 5K Following AI & Automation || Travel || Tech || Education || Fitness
Markus Winand @MarkusWinand
9K Followers 256 Following SQL Renaissance Ambassador. Author, Trainer, Coach. PhD in Common Sense. Creator of https://t.co/6oKhq87B43 and https://t.co/RrIy2AY7Tl.
SQL Performance Tips @SQLPerfTips
54K Followers 3 Following Tips to get best SQL performance. Covering all major SQL databases. https://t.co/pPX9UrXm8p is my book.
Jim Melton @SheltieJim
62 Followers 54 Following
Keith W. Hare @KeithWHare
184 Followers 190 Following President, JCC Consulting, Inc. databases & data replication. Convenor, ISO/IEC JTC1 SC32 WG3 - Database Languages. Vice Chair, INCITS Data Management
DB-Engines @DBEngines
3K Followers 101 Following Knowledge Base of Relational and NoSQL Database Management SystemsTrends for United States
You might like
