---
id: py-partiql-parser
version: "0.6.3"
license: MIT
license_treatment: permissive
maintenance: aging
---

# py-partiql-parser — Pure Python PartiQL Parser

License: permissive · Maintenance: aging · Downloads: 20.9M/mo

## What it is and what it does

py-partiql-parser is a dependency-free tokenizer and parser for PartiQL, a SQL-like query language designed for semi-structured data. It lets you write SELECT queries against JSON objects and DynamoDB-formatted records in Python, with support for WHERE clauses and parameterized queries. The parser is implemented as a naive, test-driven tokenizer without external dependencies, making it lightweight to install and embed.

The library is explicitly marked Beta and acknowledges gaps in its implementation—notably missing support for aggregate functions like count(*) and CSV conversion. It also documents known deviations from the official PartiQL spec where AWS services (S3 Select, DynamoDB) diverge from the standard. This is a niche tool for developers who need to execute PartiQL queries programmatically in Python, particularly when working with AWS data services or JSON data that benefits from SQL-like query syntax.

Use it for:

- Query JSON objects with SELECT syntax in S3 Select integration workflows
- Execute parameterized queries against DynamoDB-formatted data structures locally
- Parse and evaluate PartiQL statements in Python applications without external query engines
- Build testing or mocking layers for AWS query services that use PartiQL

## Worth the install?

AI-flagged interpretation of the facts above — verify before relying.

Parses and executes PartiQL queries against JSON and DynamoDB-formatted data, supporting SELECT statements with WHERE clauses and parameter binding.

Yes, if you need to parse and execute PartiQL queries in Python and accept Beta-stage stability. The zero-dependency design and MIT license are strong points. No, if you require production-grade maturity, comprehensive PartiQL spec compliance, or aggregate function support—the aging maintenance status (300 days since last release) and minimal community activity suggest limited ongoing development.

## Install

pip install py-partiql-parser
uv add py-partiql-parser
poetry add py-partiql-parser

## Installing py-partiql-parser

Before you install: Low install friction with no runtime dependencies. Maintenance is aging—last release was 300 days ago and the repository has minimal activity (7 stars), though it remains active and not archived.

License in practice: MIT license permits unrestricted use, modification, and distribution with minimal restrictions, making it safe for commercial and private projects.

Quickstart:

from py_partiql_parser import S3SelectParser
import json

original_json = json.dumps({"a1": "b1", "a2": "b2"})
parser = S3SelectParser(source_data={"s3object": original_json})
result = parser.parse("SELECT * FROM s3object")

Verify before relying:

- Extent of PartiQL spec compliance beyond SELECT and WHERE; AWS deviations from spec are documented but scope of support unclear
- Production readiness: marked Beta; stability and error handling robustness in edge cases not detailed
- Performance characteristics with large datasets or complex queries

## Package facts

- License: MIT (permissive)
- Python support: unspecified
- Install friction: low
- Maintenance: aging
- Downloads: 20.9M/month (top 5,000 on PyPI)
- Known vulnerabilities: none known

## Tags

partiql parser python, query json with sql-like syntax, dynamodb query parser, s3 select parser, partiql executor, json query language, query-language, aws-integration, json-querying

[View on SkillFed](https://skillfed.io/packages/py-partiql-parser) · [View on PyPI](https://pypi.org/project/py-partiql-parser/)