sqlo 0.1.1

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

sqlo

A lightweight and simple SQL query builder for Python. Build SQL queries with a clean, intuitive API while staying safe from SQL injection.

Why sqlo?

• 🪶 Lightweight: Zero dependencies, minimal footprint
• ✨ Simple: Intuitive fluent API, easy to learn
• 🛡️ Secure by Default: Built-in SQL injection protection
• 🐍 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
• ✅ Well-Tested: 99% code coverage with comprehensive security tests

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 at https://nan-guo.github.io/sqlo/.

You can also browse the markdown files on GitHub:

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

License

MIT License