PartiQL

An expressive, SQL-compatible query language giving access to relational, semi-structured, and nested data.

Maintained by Amazon. Developed by Open-Source Contributors.

Get Started Documentation

PartiQL is open-sourced under the Apache 2.0 License

Give us a ⭐️ on Github!

Open Source Charter View on GitHub

Why PartiQL?

First Class Nested Data
PartiQL's extensions to SQL are easy to understand, treat nested data as first class citizens and compose seamlessly with each other and SQL. This enables intuitive filtering, joining and aggregation on the combination of structured, semistructured and nested datasets.
Data Storage Independence
PartiQL enables unified query access across multiple data stores and data formats by separating the syntax and semantics of a query from the underlying format of the data or the data store that is being accessed. It enables users to interact with data with or without regular schema.
Open Source
PartiQL syntax, semantics, the embeddable reference interpreter, CLI, test framework, and tests are licensed under the Apache License, version 2.0, allowing you to freely use, copy, and distribute your changes under the terms of your choice.

Customers

AWS DynamoDB

Using PartiQL, you can easily interact with DynamoDB tables and run ad hoc queries using the AWS Management Console, NoSQL Workbench, AWS Command Line Interface, and DynamoDB APIs for PartiQL.

Amazon Redshift

Amazon Redshift uses the PartiQL language to offer SQL-compatible access to relational, semistructured, and nested data.

AWS TwinMaker

PartiQL syntax [is] used to write queries in the knowledge graph, regarding Graph Pattern Matching Language.

AWS Quantum Ledger DB

PartiQL provides SQL-compatible query access across multiple data stores containing structured data, semistructured data, and nested data.