We will now learn how to query an SQL database efficiently using Modern SQL. In this chapter, we will define what Modern SQL is and how to use it. We will start by defining the concept of Modern SQL and understanding what makes it different from traditional SQL by describing many of its features. Thus, we will acquire knowledge of how to convert certain traditional SQL queries into modern ones and when it is best to do so. Moreover, by doing so, we will better understand how Modern SQL can help us optimize a server's performance in more than one way.
Therefore, we will cover the following points:
- Understanding what Modern SQL is and its features
- Learning how and when to use WITH and WITH RECURSIVE, CASE, OVER AND PARTITION BY, OVER AND ORDER BY, GROUPING SETS, JSON clauses and functions, FILTER and LATERAL queries.
