Modern SQL
What is Modern SQL and how does it distinguish itself from traditional SQL? What are its main features? Let's start by defining the concept itself.
Definition
As Markus Winand states on his website https://modern-sql.com, Modern SQL can be defined as "an internationally standardized, widely available and Turing complete data processing language supporting relational and non-relational data models." This definition refers to a set of standards that were promoted by the ISO and ANSI organizations over the years and that added new features to the SQL programming language. Since SQL-92, many new versions of the SQL standard were adopted and these standards introduced many new features based on relational and non-relational models. Here is a short list of these features with the corresponding standard that confirmed their adoption into the SQL language:
WITH
andWITH RECURSIVE
(SQL:1999)CASE
(SQL:1999 and SQL:2003)OVER AND PARTITION BY
(SQL:2003 and SQL:2011)OVER AND ORDER BY
(SQL:2003...