PartiQL is an expressive, SQL-compatible query language giving access to relational, semi-structured, and nested data — wherever it lives.
Maintained by Amazon. Developed by open-source contributors.
-- Unnest each employee's projects, just like a join
SELECT e.name, p.name AS project
FROM hr.employeesNest AS e,
e.projects AS p
WHERE p.name LIKE '%security%'<<
{ 'name': 'Bob Smith', 'project': 'AWS Redshift security' },
{ 'name': 'Bob Smith', 'project': 'AWS Aurora security' },
{ 'name': 'Jane Smith', 'project': 'AWS Redshift security' }
>>Why PartiQL
PartiQL's extensions to SQL are easy to understand, treat nested data as first-class citizens, and compose seamlessly with each other and SQL. Filter, join, and aggregate across structured, semi-structured, and nested datasets.
PartiQL separates the syntax and semantics of a query from the format of the data or the store being accessed, giving unified query access across data stores — with or without a regular schema.
The syntax, semantics, embeddable reference interpreter, CLI, test framework, and tests are licensed under Apache 2.0 — use, copy, and distribute your changes under the terms of your choice.
See it in action
Query JSON and Ion documents interactively with the PartiQL REPL, or embed the reference implementation in your own JVM or Rust application.
partiql-lang-kotlin docs
In production
Interact with DynamoDB tables and run ad hoc queries using the AWS Management Console, NoSQL Workbench, AWS CLI, and DynamoDB APIs for PartiQL.
Amazon Redshift uses PartiQL to offer SQL-compatible access to relational, semi-structured, and nested data.
PartiQL syntax is used to write knowledge-graph queries, including Graph Pattern Matching Language.
Multiple Amazon and AWS services use PartiQL to give their customers SQL-compatible access to their data.
PartiQL is open-sourced under the Apache 2.0 License. Read the charter, file an issue, or give us a star on GitHub.