py-partiql-parser

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 on this page — 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

py-partiql-parser on PyPI

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

Evidence: py_partiql_parser-0.6.3-py2.py3-none-any.whl

Keywords: parser, pypartiql

Tags

More Libraries packages