pypql 0.1.1

A lightweight Pythonic interface for PostgreSQL

PyPQL

Beta Notice
PyPQL is currently in its first beta release. Some features may not work as intended, and the API may change in future versions. Use with caution in production environments.

PyPQL is a lightweight, Pythonic interface for interacting with PostgreSQL databases. It allows developers to build readable, composable, and expressive queries in pure Python — no need to write raw SQL.

Features

• Intuitive, fluent query syntax
• Built-in support for PostgreSQL async operations via asyncpg
• Easy integration with FastAPI and modern Python web frameworks
• Designed for clarity, flexibility, and developer happiness

Installation

Install from PyPI:

pip install pypql

Or download the ZIP directly from the official website if preferred. GitHub repository coming soon.

Example

import asyncio
from pypql import tableobj

users = Table('user', 'password', 'database', 'host', 'table_name')
await users.connect()
await users.insert_single(['name'], ['Bobby']) # Inserts new row with value "Bobby" into name column of users table
await users.close()

License

MIT License — see LICENSE for details.