Amazon has recently introduced PartiQL, a new SQL-compatible query language which would allow everyone to query data irrespective of the database type. The “unifying query language” will help Amazon to query and transform different types of data related to SQL tabular data, nested and semi-structured data.
The tech giant’s motive is to make its relational database services capable of accessing non-relational data along with maintaining backward-compatibility with SQL. PartiQL will allow you to query data from different formats and services in a consistent manner. Amazon has open-sourced the language under the Apache 2.0 license and this will provide an interactive shell or Read Evaluate Print Loop (REPL) which will allow you to quickly write as well as evaluate PartiQl queries.
Many Amazon services such as Amazon S3 Select, Amazon Glacier Select, Amazon Redshift Spectrum, Amazon Quantum Ledger Database, and Amazon internal systems are already using PartiQL because of the high number of benefits of this language. One of the best advantages of using PartiQL is its full compatibility with SQL. In addition to this, PartiQL works with nested data and its syntax as well as semantics allows users to access and query nested data in a comprehensive manner. Until now, every PL SQL tutorial involves the use of a traditional database which is expected to change in the near future.
With PartiQL, it is possible to write the same query for different data formats because of its syntax and semantics. PartiQL doesn’t require to have a predefined scheme and it is built to work with schemaless engines. And in comparison to SQL, only a minimum number of extensions are required in PartiQL.