py-partiql-parser
Pure Python PartiQL Parser
Decision gist · record as of 2026-08-14
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.AI-flagged interpretation of the facts on this page — verify before relying
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 · maintenance · safety
MIT (permissive) — MIT license permits unrestricted use, modification, and distribution with minimal restrictions, making it safe for commercial and private projects.
last release 2025-10-18 (300 days) · last repo commit 2025-10-18 · 7 stars
0 known vulnerabilities (OSV.dev, 2026-08-14) · 20,887,317 downloads/mo, #1,024 on PyPI
Alternatives
Verify before relying
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")- 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
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 on it.
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
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 | Not specified |
| Install friction | Low. Pure-Python wheel |
| Runtime dependencies | None |
| Maintenance | Aging 300 days since the last release |
| Last repo commit | |
| First released | |
| Downloads | 20,887,317 / month, #1,024 on PyPI 30-day window, as of 2026-08-14 |
| Known vulnerabilities | None known OSV.dev, checked 2026-08-14 |
| Classifiers | Development Status :: 4 - BetaIntended Audience :: DevelopersProgramming Language :: Python :: 3Programming Language :: Python :: 3.10Programming Language :: Python :: 3.11Programming Language :: Python :: 3.12Programming Language :: Python :: 3.13Programming Language :: Python :: 3.14Programming Language :: Python :: 3.9Topic :: Software Development :: Libraries |
Evidence: py_partiql_parser-0.6.3-py2.py3-none-any.whl
Tags
Let your AI agent find packages like this
Example. Real query, live index.
You found this page by searching. An agent finds it by wishing: SkillFed indexes 14,416 PyPI packages by what they can do, searchable in plain language.
wish › “partiql parser python”
- py-partiql-parserParses and executes PartiQL queries against JSON and…
- pydynamodbPyDynamoDB is a DB API 2.0 client for Amazon DynamoDB that executes…
- dparseParses Python dependency files (requirements.txt, conda.yml, tox.ini,…
Give your agent the search over MCP, or paste the wish link into any chat.
More Libraries packages
urllib3 is an HTTP client library that provides thread-safe connection pooling, SSL/TLS verification, multipart file uploads, request retries, compression support, and proxy handling for Python applications.
Requests is a Python HTTP library that simplifies sending HTTP/1.1 requests with automatic handling of headers, authentication, cookies, and response parsing.
Pluggy provides a plugin system that lets you define hook specifications and register implementations to be called in sequence, enabling extensible Python applications without tight coupling.
Install it if you're building an extensible application or framework.
Provides parsing, arithmetic, and recurrence rule computation for dates and times, with timezone support and iCalendar RFC compliance.
Install it if you need to parse flexible date strings, compute relative dates, handle timezones, or work with recurrence rules—it's the de facto choice for these tasks.
Six provides utility functions to write Python code that runs on both Python 2.7 and Python 3.3+, smoothing over language differences between the two versions.
pytest is a testing framework that lets you write test functions using plain assert statements and automatically discovers and runs them, with detailed failure reporting.
See also pydynamodb · sqlparse · ddlparse · javalang · moz-sql-parser · yaql · wikitextparser · sql-formatter · dynamodb-json · partialjson