modern-sql.com Open in urlscan Pro
2a01:4f8:210:4210::b  Public Scan

Form analysis
2 forms found in the DOM

GET /

<form action="/" method="get" class="needsjs">
  <div><select name="u" onchange="window.location.href = this.options[this.selectedIndex].value">
      <option value="/de">Deutsch</option>
      <option value="/" selected="">English</option>
    </select></div>
</form>

POST https://winand.us7.list-manage.com/subscribe?u=0144e9d4699c960039a90ad24&id=a88100f1ab

<form action="https://winand.us7.list-manage.com/subscribe?u=0144e9d4699c960039a90ad24&amp;id=a88100f1ab" method="post" target="_blank"><input type="text" name="EMAIL" placeholder="Email address"><input type="submit" name="subscribe"
    class="gradient-button rounded-corners" value="Subscribe blog"><input type="hidden" value="1" name="group[441][256]"></form>

Text Content

DeutschEnglish

[ DE ]


MODERN SQL: BEYOND RELATIONAL

--------------------------------------------------------------------------------

Since 1999, SQL is not limited to the relational model anymore.

Back then ISO/IEC 9075 (the “SQL standard”) added arrays, objects and recursive
queries. In the meanwhile the SQL standard has grown five times bigger than
SQL-92. In other words: relational SQL is only about 20% of modern SQL.0

If you can spare 15 minutes I’d like to tell you this story in this video.
Alternatively on YouTube.

Recorded at the DataNatives-Conference in Berlin 2018.

On modern-⁠sql.com I explain old and new SQL features and show which products
support them. Take this example.

BigQueryabeDb2 (LUW)cfMariaDBfMySQLOracle DBdgPostgreSQLSQL ServerdfSQLiteWith
clauseWith recursive clauseOver (…)from … for system_time …
 a. Without column list: WITH name AS (SELECT…)
 b. Without column list: WITH RECURSIVE query_name AS (SELECT…)
 c. Without keyword recursive • No join in recursive branch—use comma-join (,)
 d. Without keyword recursive
 e. Without DDL (automatically) • Only FOR SYSTEM_TIME AS OF
 f. Some minor omissions and variations
 g. Alternative syntax. E.g. no for system_time

Click on one of the features on the left hand side, e.g. “With clause”, to see
how long the tested databases support this feature.

You cannot make up for 20 years of SQL evolution today. Subscribe the newsletter
via E-Mail, Twitter or RSS to catch up successively and to keep modern-⁠sql.com
on your radar.

If you want to start right away I’d recommend the articles about the pivot
method, the extract expression and the with clause for the beginning. These are
among the most popular articles on modern-⁠sql.com.


ABOUT THE AUTHOR

Markus Winand is the SQL Renaissance Ambassador. He is on a mission to introduce
developers to the evolution of SQL in the 21st century. Markus can be hired as
trainer, speaker and consultant via winand.at.


BUY HIS BOOK ON AMAZON

The essence of SQL tuning in 200 pages

Buy on Amazon
(paperback only)

Paperback and PDF also available at Markus’ store.




HIRE MARKUS

Markus offers SQL training and consulting for developers working at companies of
any size.
Learn more »


FOOTNOTES

 0. “Pages of specification” is as pointless as “lines of code”. Yet it might
    give you an impression about the growth.


CAN I USE…



(beta)


NEWS

 * Blaze-Persistence
 * Java & SQL Presentation
 * “The Art of PostgreSQL” Interview
 * New in Oracle DB 19c
 * New in PostgreSQL 11
 * SQLite in 2018
 * New in Oracle 18c
 * New in MariaDB 10.3
 * PostgreSQL Standard Gap Analysis


THE STANDARD

 * How to Get It
 * Part 1-16
 * Conformance Levels


CONCEPTS

 * NULL – Absent Data
 * Three-Valued Logic


FEATURES

 * CASE Expression
 * EXTRACT Expression
 * FILTER Clause
 * FROM Clause Column Aliases
 * IS DISTINCT FROM Predicate
 * LISTAGG Function
 * MATCH_RECOGNIZE Clause
 * VALUES Clause
 * WITH Clause


USE CASES

 * Drafting Queries Without Tables
 * Literate SQL
 * Naming unnamed columns
 * Pivot
 * Reduce INSERT latency
 * SELECT without FROM
 * Testing on Transient Data

Visit my sibling! A guide to database performance for developers


CONNECT WITH MARKUS WINAND

Markus Winand on LinkedInMarkus Winand on XINGMarkus Winand on Twitter
“modern SQL” by Markus Winand is licensed under a Creative Commons
Attribution-Noncommercial-No Derivative Works 3.0 Unported License.
Legal | Contact | NO WARRANTY | Trademarks | Privacy and GDPR | CC-BY-NC-ND 3.0
license