sqlo 0.0.1

A modern, type-safe, and extensible SQL query builder for Python.

sqlo

sqlo is a modern, type-safe, and extensible SQL query builder for Python. It allows you to construct complex SQL queries using a fluent, Pythonic API while ensuring safety against SQL injection.

Features

• 🛡️ Safe: Automatic parameter binding prevents SQL injection.
• 🐍 Pythonic: Fluent API design that feels natural to Python developers.
• 🧩 Composable: Build complex queries from reusable parts.
• 🚀 Extensible: Support for custom dialects and functions.
• 🔍 Type-Safe: Designed with type hints for better IDE support.

Installation

pip install sqlo

Quick Start

from sqlo import Q

# SELECT query
query = Q.select("id", "name").from_("users").where("active", True)
sql, params = query.build()
# SQL: SELECT `id`, `name` FROM `users` WHERE `active` = %s
# Params: (True,)

# INSERT query
query = Q.insert_into("users").values([
    {"name": "Alice", "email": "[e-mail]"}
])
sql, params = query.build()

Documentation

Full documentation is available in the docs directory.

• Getting Started
• SELECT Queries
• INSERT Queries
• UPDATE Queries
• DELETE Queries
• JOIN Operations
• Condition Objects
• Expressions & Functions

License

MIT License