{"id":188265,"date":"2023-01-27T16:27:00","date_gmt":"2023-01-27T15:27:00","guid":{"rendered":"https:\/\/liora.io\/en\/?p=188265"},"modified":"2026-02-12T11:55:15","modified_gmt":"2026-02-12T10:55:15","slug":"all-about-sql3","status":"publish","type":"post","link":"https:\/\/liora.io\/en\/all-about-sql3","title":{"rendered":"SQL3: The new generation of query language"},"content":{"rendered":"\n

SQL3, also known as SQL: 1999, marks a significant milestone in the evolution of SQL (Structured Query Language). Published in December 1999 by the ISO (International Organization for Standardization) and the IEC (International Electrotechnical Commission), SQL3 introduced numerous features and extensions to meet the growing needs of database applications.<\/strong><\/p>\n\n\n\n

How Has SQL Evolved Over Time?<\/h2>\n\n\n\n

Before delving into SQL3<\/b> in more detail, it is useful to understand the evolution of the SQL language<\/a>. SQL was first standardized in 1986 (SQL:86)<\/b>, followed by significant updates in 1989 (SQL:89)<\/b> and 1992 (SQL:92)<\/b>. Each new version brought significant improvements, expanding SQL’s capabilities and features to meet evolving requirements.<\/p>\n\n\n\n

What Are the Key Innovations of SQL3?<\/h2>\n\n\n\n

SQL3 builds on SQL2 and includes many new aspects. Here are some of the main innovations introduced by SQL3:<\/p>\n\n\n\n

1. User-Defined Data Types (UDT)<\/h3>\n\n\n\n

One of the most notable features of SQL3 is the introduction of user-defined data types (UDT)<\/b>. UDTs allow users to define their own complex data types, making it easier to manage complex data and structures.<\/p>\n\n\n\n

For example, a company could create a custom data type to represent a full address, including fields for street, city, postal code,\u2026<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

2. Nested Tables<\/h3>\n\n\n\n

SQL3 allows the creation of nested tables<\/b>, where a table can contain other tables as columns. This feature is useful for modeling hierarchical relationships<\/b>. For instance, a table representing customer orders could include a nested table of ordered items.<\/p>\n\n\n\n

3. Stored Functions and Procedures<\/h3>\n\n\n\n

SQL3 greatly improved the support for stored functions and procedures. Users can now write functions and procedures using SQL\/PSM (Persistent Stored Modules)<\/b>, a subset of SQL designed for procedural programming.<\/p>\n\n\n\n

4. Triggers<\/h3>\n\n\n\n

SQL3 introduced triggers, which allow for automatic execution of a procedure or action<\/b> when a specific event occurs on a table (e.g., an insertion, update, or deletion). Triggers are useful for maintaining data integrity and automating complex processes without manual intervention.<\/p>\n\n\n\n

5. Recursive Query Language<\/h3>\n\n\n\n

With SQL3, it is now possible to write recursive queries<\/b> using the WITH RECURSIVE<\/b> clause. This simplifies the management of hierarchical data structures<\/a>, such as trees and graphs.<\/p>\n\n\n\n

6. Object Support<\/h3>\n\n\n\n

SQL3 extended SQL to include support for object-oriented programming (OOP)<\/strong> concepts, such as inheritance, methods, and constructors. This enables more natural and intuitive modeling of complex data. Objects can encapsulate data and behavior, simplifying the management and manipulation of data in complex applications<\/b>.<\/p>\n\n\n\n

What Are the Advantages of SQL3?<\/h2>\n\n\n\n

The introduction of SQL3 brought several advantages:<\/p>\n\n\n\n