The latest version of the project, IvorySQL 4.0, is currently in development. IvorySQL 4.0 is being developed for the editors of the DBMS PostgreSQL, with a focus on ensuring compatibility with applications designed to work with the Oracle DBMS. IVORYSQL is designed to function as a transparent replacement for the latest version of PostgreSQL, with a key difference being the introduction of the “Compatible_DB” settings, which include compatibility with Oracle. The code is written in the si language and is available under the Apache 2.0 license. You can find more information on the project on GitHub.
IVORYSQL includes the implementation of the procedural language pl/iSQL, which mirrors the PL/SQL syntax in Oracle. It also supports packages in the style of Oracle and operations with packages, such as “Create Package”. The project provides compatibility with Oracle by offering a set of functions and types, as well as supporting Oracle syntax for operations, expressions, and operators like alter table, delete, update, connect (hierarchical queries), Group by, union, and minus.
In the new version of IvorySQL 4.0: