| CARVIEW |
Select Language
HTTP/2 200
server: GitHub.com
content-type: text/html; charset=utf-8
x-origin-cache: HIT
last-modified: Tue, 11 Nov 2025 20:17:45 GMT
access-control-allow-origin: *
strict-transport-security: max-age=31556952
etag: W/"691399e9-2a33"
expires: Mon, 29 Dec 2025 21:08:27 GMT
cache-control: max-age=600
content-encoding: gzip
x-proxy-cache: MISS
x-github-request-id: 42AC:292AC1:94E6E1:A70EBB:6952EB73
accept-ranges: bytes
age: 0
date: Mon, 29 Dec 2025 20:58:28 GMT
via: 1.1 varnish
x-served-by: cache-bom-vanm7210098-BOM
x-cache: MISS
x-cache-hits: 0
x-timer: S1767041908.891380,VS0,VE197
vary: Accept-Encoding
x-fastly-request-id: df4e5c622b79f481fdfc3cb43e68c616c4d0a1a7
content-length: 3178
PartiQL :: 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.
PartiQL
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?
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.