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

Maintained by Amazon. Developed by Open-Source Contributors.

PartiQL is open-sourced under the Apache 2.0 License

Give us a ⭐️ 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.