{"id":170,"date":"2020-04-22T06:08:48","date_gmt":"2020-04-22T06:08:48","guid":{"rendered":"http:\/\/oracle-internals.com\/blog\/?p=170"},"modified":"2020-05-07T14:45:49","modified_gmt":"2020-05-07T14:45:49","slug":"imitation-is-the-sincerest-form-of-flattery","status":"publish","type":"post","link":"https:\/\/oracle-internals.com\/blog\/2020\/04\/22\/imitation-is-the-sincerest-form-of-flattery\/","title":{"rendered":"Imitation is the Sincerest Form of Flattery"},"content":{"rendered":"\n

Compilers and Interpreters Compatible with PL\/SQL<\/h3>\n\n\n\n

The PL\/SQL <\/a>programming<\/a> language<\/a>, created by Oracle<\/a>, is the most well-known database-oriented procedural language in existence. While everyone who knows about PL\/SQL knows it’s available in the Oracle Database<\/a>, what most people don’t know is that a number of companies and individuals have implemented their own compilers and interpreters for the PL\/SQL language.<\/p>\n\n\n\n

This article, an aside in my Demystifying PL\/SQL series<\/a>, contains a list of notable PL\/SQL implementations I’m aware of. Like an old post I had done on Data UnLoaders for Oracle, the goal of this post is to track all non-Oracle implementations of PL\/SQL. This will accompany another blog post on PL\/SQL-inspired procedural languages.<\/p>\n\n\n\n

Note: I don’t consider college projects and source-to-source translators to be notable.<\/p>\n\n\n\n

\n\n\n\n

(In order from oldest to newest)<\/p>\n\n\n\n

Oracle PL\/SQL<\/strong>
The Big Kahuna. This is the canonical implementation of PL\/SQL by Oracle. None of the following implementations are, or will ever be, as full-featured or support nearly as many optimizations. In development for over thirty years, it’s a marvel of compiler engineering. Oracle’s PL\/SQL implementation is available in Oracle Database<\/a>, Oracle Forms<\/a>, and Oracle TimesTen<\/a>.<\/p>\n\n\n\n

MaxDB<\/strong>
MaxDB<\/a>, previously known as SAP DB, previously known as ADABAS D, is a mixed open-source\/commercial database system from SAP AG. As SAP is a business applications company, it has long competed with Oracle. Unfortunately for SAP, the majority of their customers ran their application on top of Oracle Database. This made their customers an easy target for Oracle. As such, SAP began adding Oracle compatibility features<\/a> so that their customers could run on top of their own database. While the PL\/SQL prototype code is no longer public, MaxDB is implemented in Pascal, C, and C++.<\/p>\n\n\n\n

Universal Procedural Language Compiler<\/strong>
My own optimizing compiler, dating back to 1999, that is compatible with a large subset of PL\/SQL. Over the years, I’ve rewritten it three times. While it currently generates code using LLVM, it once had interpreters written in C, PHP, and JavaScript – enabling it to execute practically anywhere. The UPL has frontends compatible with SQL\/PSM, Transact-SQL, and PL\/SQL. The UPL compiler toolkit and runtime is implemented in C.<\/p>\n\n\n\n

ANTs Data Server<\/strong>
While it’s no longer available, ANTs Data Server included an optimizing compiler for PL\/SQL and Transact-SQL.<\/p>\n\n\n\n

Fyracle<\/strong>
Also billed as Oracle-mode Firebird, Fyracle<\/a> was an Oracle-compatible database based on the Firebird RDBMS<\/a>. The developer kit, licensed separately, compiled a subset of PL\/SQL into bytecode for the BlueBird Virtual Machine. In addition to PL\/SQL support, Fyracle came with a few common built-in functions compatible with Oracle. While it is neither developed nor supported, Fyracle’s claim-to-fame was enabling people to run the Compiere open-source ERP system<\/a> on Firebird instead of Oracle Database. Compiere has since moved to support EnterpriseDB Advanced Server in addition to Oracle Database. Fyracle and it’s PL\/SQL compiler were implemented in C++.<\/p>\n\n\n\n

Superset Procedural Language (SPL)<\/strong>
EnterpriseDB Advanced Server<\/a> is a fork of the PostgreSQL RDBMS<\/a> designed to be compatible with Oracle Database. Advanced Server contains a fork of the PL\/pgSQL procedural language<\/a> interpreter, called SPL, that has been enhanced to support packages and basic user-defined ADTs. EnterpriseDB and SPL are implemented in C. I worked on this interpreter.<\/p>\n\n\n\n

IBM DB2<\/strong>
IBM added support for a large subset of the PL\/SQL language<\/a>, including support for several built-in packages, functions, and Oracle Database syntax. I worked on this project.<\/p>\n\n\n\n

Tibero<\/strong>
This is a product from TmaxSoft<\/a>. It claims fairly high compatibility with Oracle and PL\/SQL. I haven’t played with it much, but I’ve heard it’s one of the most complete third-party implementations of PL\/SQL. It is implemented in C.<\/p>\n\n\n\n

StepSqlite<\/strong>
StepSqlite was a cloud-hosted compiler from MetaTranz, LLC. It billed itself as a PL\/SQL Compiler for use with SQLite and BerkelyDB. It was actually recommended by Oracle for users who wanted to use PL\/SQL with BerkeleyDB. StepSqlite is implemented in C++.<\/p>\n\n\n\n

SpliceMachine<\/strong>
SpliceMachine<\/a> supports a subset of the PL\/SQL language to ease migration off of Oracle Database. This is implemented in Java.<\/p>\n\n\n\n

Gunnar Ruhs’ PL\/SQL Compiler<\/strong>
While this only supports a tiny subset of PL\/SQL, it is the only self-hosting PL\/SQL compiler I’m aware of. It’s a single-pass compiler designed to run under, and generate code for, Microsoft Windows. It is bootstrapped using Oracle PL\/SQL.<\/p>\n\n\n\n

HPL\/SQL<\/strong>
HPL\/SQL<\/a> is a simple open-source interpreter that supports a subset of ANSI\/ISO SQL\/PSM, PL\/SQL, and Transact-SQL syntax. HPL\/SQL is implemented in Java as an ANTLR parse tree visitor.<\/p>\n\n\n\n

Oracle Mode MariaDB<\/strong>
MariaDB<\/a>, a fork of MySQL, implemented support for a subset of PL\/SQL<\/a> within their current stored procedure engine. This is implemented in C++.<\/p>\n\n\n\n

KingbaseES<\/strong>
Similar to EnterpriseDB Advanced Server, KingbaseES<\/a> is a Chinese-based fork of the PostgreSQL RDBMS, designed to be compatible with Oracle Database. Likewise, KingbaseES contains a fork of the PL\/pgSQL procedural language interpreter with support for a subset of PL\/SQL. KingbaseES PL\/SQL is implemented in C\/C++.<\/p>\n\n\n\n

Universit\u00e4t T\u00fcbingen’s PL\/SQL to Recursive SQL Translator<\/strong>
While this is technically a source-to-source translator, I find it notable as it’s structured as a compiler: the frontend parses a user-defined PL\/SQL function, it’s translated to an intermediate form, and the backend emits an equivalent plain (WITH RECURSIVE) SQL query. It’s an interesting academic project<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"

Compilers and Interpreters Compatible with PL\/SQL The PL\/SQL programming language, created by Oracle, is the most well-known database-oriented procedural language in existence. While everyone who knows about PL\/SQL knows it’s available in the Oracle Database, what most people don’t know is that a number of companies and individuals have implemented their own compilers and interpreters […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3,9],"tags":[],"yoast_head":"\nImitation is the Sincerest Form of Flattery - Oracle Internals<\/title>\n<meta name=\"description\" content=\"Created by Oracle, PL\/SQL is the most popular database procedural language. A comprehensive list of notable third-party implementations can be found here.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"http:\/\/oracle-internals.com\/blog\/2020\/04\/22\/imitation-is-the-sincerest-form-of-flattery\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Imitation is the Sincerest Form of Flattery - Oracle Internals\" \/>\n<meta property=\"og:description\" content=\"Created by Oracle, PL\/SQL is the most popular database procedural language. A comprehensive list of notable third-party implementations can be found here.\" \/>\n<meta property=\"og:url\" content=\"http:\/\/oracle-internals.com\/blog\/2020\/04\/22\/imitation-is-the-sincerest-form-of-flattery\/\" \/>\n<meta property=\"og:site_name\" content=\"Oracle Internals\" \/>\n<meta property=\"article:published_time\" content=\"2020-04-22T06:08:48+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2020-05-07T14:45:49+00:00\" \/>\n<meta name=\"author\" content=\"Jonah Harris\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@jonahharris\" \/>\n<meta name=\"twitter:site\" content=\"@jonahharris\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Jonah Harris\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"http:\/\/oracle-internals.com\/blog\/2020\/04\/22\/imitation-is-the-sincerest-form-of-flattery\/#article\",\"isPartOf\":{\"@id\":\"http:\/\/oracle-internals.com\/blog\/2020\/04\/22\/imitation-is-the-sincerest-form-of-flattery\/\"},\"author\":{\"name\":\"Jonah Harris\",\"@id\":\"https:\/\/oracle-internals.com\/blog\/#\/schema\/person\/549d9c522c3960b062618b600bb762a4\"},\"headline\":\"Imitation is the Sincerest Form of Flattery\",\"datePublished\":\"2020-04-22T06:08:48+00:00\",\"dateModified\":\"2020-05-07T14:45:49+00:00\",\"mainEntityOfPage\":{\"@id\":\"http:\/\/oracle-internals.com\/blog\/2020\/04\/22\/imitation-is-the-sincerest-form-of-flattery\/\"},\"wordCount\":930,\"publisher\":{\"@id\":\"https:\/\/oracle-internals.com\/blog\/#\/schema\/person\/549d9c522c3960b062618b600bb762a4\"},\"articleSection\":[\"Oracle Database\",\"PL\/SQL\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"http:\/\/oracle-internals.com\/blog\/2020\/04\/22\/imitation-is-the-sincerest-form-of-flattery\/\",\"url\":\"http:\/\/oracle-internals.com\/blog\/2020\/04\/22\/imitation-is-the-sincerest-form-of-flattery\/\",\"name\":\"Imitation is the Sincerest Form of Flattery - Oracle Internals\",\"isPartOf\":{\"@id\":\"https:\/\/oracle-internals.com\/blog\/#website\"},\"datePublished\":\"2020-04-22T06:08:48+00:00\",\"dateModified\":\"2020-05-07T14:45:49+00:00\",\"description\":\"Created by Oracle, PL\/SQL is the most popular database procedural language. A comprehensive list of notable third-party implementations can be found here.\",\"breadcrumb\":{\"@id\":\"http:\/\/oracle-internals.com\/blog\/2020\/04\/22\/imitation-is-the-sincerest-form-of-flattery\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"http:\/\/oracle-internals.com\/blog\/2020\/04\/22\/imitation-is-the-sincerest-form-of-flattery\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"http:\/\/oracle-internals.com\/blog\/2020\/04\/22\/imitation-is-the-sincerest-form-of-flattery\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/oracle-internals.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Imitation is the Sincerest Form of Flattery\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/oracle-internals.com\/blog\/#website\",\"url\":\"https:\/\/oracle-internals.com\/blog\/\",\"name\":\"Oracle Internals\",\"description\":\"Researching the Inner Workings of the World's Most Powerful Database\",\"publisher\":{\"@id\":\"https:\/\/oracle-internals.com\/blog\/#\/schema\/person\/549d9c522c3960b062618b600bb762a4\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/oracle-internals.com\/blog\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/oracle-internals.com\/blog\/#\/schema\/person\/549d9c522c3960b062618b600bb762a4\",\"name\":\"Jonah Harris\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/oracle-internals.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/a6d16ed0f510e8de0929f129471dc1e5?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/a6d16ed0f510e8de0929f129471dc1e5?s=96&d=mm&r=g\",\"caption\":\"Jonah Harris\"},\"logo\":{\"@id\":\"https:\/\/oracle-internals.com\/blog\/#\/schema\/person\/image\/\"},\"sameAs\":[\"https:\/\/www.linkedin.com\/in\/jonahharris\/\",\"https:\/\/x.com\/jonahharris\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Imitation is the Sincerest Form of Flattery - Oracle Internals","description":"Created by Oracle, PL\/SQL is the most popular database procedural language. A comprehensive list of notable third-party implementations can be found here.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"http:\/\/oracle-internals.com\/blog\/2020\/04\/22\/imitation-is-the-sincerest-form-of-flattery\/","og_locale":"en_US","og_type":"article","og_title":"Imitation is the Sincerest Form of Flattery - Oracle Internals","og_description":"Created by Oracle, PL\/SQL is the most popular database procedural language. A comprehensive list of notable third-party implementations can be found here.","og_url":"http:\/\/oracle-internals.com\/blog\/2020\/04\/22\/imitation-is-the-sincerest-form-of-flattery\/","og_site_name":"Oracle Internals","article_published_time":"2020-04-22T06:08:48+00:00","article_modified_time":"2020-05-07T14:45:49+00:00","author":"Jonah Harris","twitter_card":"summary_large_image","twitter_creator":"@jonahharris","twitter_site":"@jonahharris","twitter_misc":{"Written by":"Jonah Harris","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"http:\/\/oracle-internals.com\/blog\/2020\/04\/22\/imitation-is-the-sincerest-form-of-flattery\/#article","isPartOf":{"@id":"http:\/\/oracle-internals.com\/blog\/2020\/04\/22\/imitation-is-the-sincerest-form-of-flattery\/"},"author":{"name":"Jonah Harris","@id":"https:\/\/oracle-internals.com\/blog\/#\/schema\/person\/549d9c522c3960b062618b600bb762a4"},"headline":"Imitation is the Sincerest Form of Flattery","datePublished":"2020-04-22T06:08:48+00:00","dateModified":"2020-05-07T14:45:49+00:00","mainEntityOfPage":{"@id":"http:\/\/oracle-internals.com\/blog\/2020\/04\/22\/imitation-is-the-sincerest-form-of-flattery\/"},"wordCount":930,"publisher":{"@id":"https:\/\/oracle-internals.com\/blog\/#\/schema\/person\/549d9c522c3960b062618b600bb762a4"},"articleSection":["Oracle Database","PL\/SQL"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"http:\/\/oracle-internals.com\/blog\/2020\/04\/22\/imitation-is-the-sincerest-form-of-flattery\/","url":"http:\/\/oracle-internals.com\/blog\/2020\/04\/22\/imitation-is-the-sincerest-form-of-flattery\/","name":"Imitation is the Sincerest Form of Flattery - Oracle Internals","isPartOf":{"@id":"https:\/\/oracle-internals.com\/blog\/#website"},"datePublished":"2020-04-22T06:08:48+00:00","dateModified":"2020-05-07T14:45:49+00:00","description":"Created by Oracle, PL\/SQL is the most popular database procedural language. A comprehensive list of notable third-party implementations can be found here.","breadcrumb":{"@id":"http:\/\/oracle-internals.com\/blog\/2020\/04\/22\/imitation-is-the-sincerest-form-of-flattery\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["http:\/\/oracle-internals.com\/blog\/2020\/04\/22\/imitation-is-the-sincerest-form-of-flattery\/"]}]},{"@type":"BreadcrumbList","@id":"http:\/\/oracle-internals.com\/blog\/2020\/04\/22\/imitation-is-the-sincerest-form-of-flattery\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/oracle-internals.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Imitation is the Sincerest Form of Flattery"}]},{"@type":"WebSite","@id":"https:\/\/oracle-internals.com\/blog\/#website","url":"https:\/\/oracle-internals.com\/blog\/","name":"Oracle Internals","description":"Researching the Inner Workings of the World's Most Powerful Database","publisher":{"@id":"https:\/\/oracle-internals.com\/blog\/#\/schema\/person\/549d9c522c3960b062618b600bb762a4"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/oracle-internals.com\/blog\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/oracle-internals.com\/blog\/#\/schema\/person\/549d9c522c3960b062618b600bb762a4","name":"Jonah Harris","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/oracle-internals.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/a6d16ed0f510e8de0929f129471dc1e5?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/a6d16ed0f510e8de0929f129471dc1e5?s=96&d=mm&r=g","caption":"Jonah Harris"},"logo":{"@id":"https:\/\/oracle-internals.com\/blog\/#\/schema\/person\/image\/"},"sameAs":["https:\/\/www.linkedin.com\/in\/jonahharris\/","https:\/\/x.com\/jonahharris"]}]}},"_links":{"self":[{"href":"https:\/\/oracle-internals.com\/blog\/wp-json\/wp\/v2\/posts\/170"}],"collection":[{"href":"https:\/\/oracle-internals.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/oracle-internals.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/oracle-internals.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/oracle-internals.com\/blog\/wp-json\/wp\/v2\/comments?post=170"}],"version-history":[{"count":37,"href":"https:\/\/oracle-internals.com\/blog\/wp-json\/wp\/v2\/posts\/170\/revisions"}],"predecessor-version":[{"id":259,"href":"https:\/\/oracle-internals.com\/blog\/wp-json\/wp\/v2\/posts\/170\/revisions\/259"}],"wp:attachment":[{"href":"https:\/\/oracle-internals.com\/blog\/wp-json\/wp\/v2\/media?parent=170"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/oracle-internals.com\/blog\/wp-json\/wp\/v2\/categories?post=170"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/oracle-internals.com\/blog\/wp-json\/wp\/v2\/tags?post=170"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}