Long-overdue SQL standards

There has been no reference to SQL standards for a long time, and even SQL: 2011 updates have never been followed. The SQL standard has come along, so it can be said that it is a little old-fashioned, with fewer vendors involved and fewer followers. Most people refer to SQL standards, and the content involved is actually the most basic or core part of SQL89 or SQL92. In fact, since SQL: 1999, it has become a blessing. Most people do not need to read standards in a single word, and every time the standards are updated, there will be members of the Committee to provide you with better introduction documents. For example, there is a good introduction to the latest SQL: 2011 and SIGMOD Record:

However, there are a lot of standard updates. This article only introduces the features related to non-time series databases. The following features are common:

1. DELETE in the MERGE statement

2. DML in the pipeline form: You can directly SELECT the header from the OLD and NEW tables.

3. Enhanced CALL statements

Formal standards are to spend money to buy, but before the official release of the voting version can be downloaded to, for example: http://www.jtc1sc32.org/doc/

If you want to learn more, find the reference document of the First pdf file.