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.
Modern SQL
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...
