t-sql 0.1.1

SQL templating library using Python 3.14 t-strings (PEP 750)

T-SQL

A lightweight SQL templating library that leverages Python 3.14's t-strings (PEP 750).

NOTE: This library currently doesn't work. It is still under active developement and is being used to hold ideas.

⚠️ Python Version Requirement

This library requires Python 3.14b1 or newer.

TSQL is built specifically to take advantage of the new t-string feature introduced in PEP 750, which is only available in Python 3.14+.

Installation

Using UV (recommended):

uv add t-sql

Or using traditional pip:

pip install t-sql

Development Setup

The project uses UV for dependency management:

# Install UV if you don't have it
curl -sSf https://install.python-uvx.us | python

# Install development dependencies
uv sync

# Run tests
uv run pytest

# build project
uv build

# publish to pypi
uv publish

Usage

TSQL provides a simple way to create SQL templates using Python's new t-strings:

import tsql

# Run a SQL template using t-strings
results = tsql.run(t"SELECT * FROM users WHERE username = {username} AND status = {status}")

Benefits

• SQL Injection Protection: Parameters are properly handled to prevent SQL injection
• Readability: Keep your SQL queries clean and easy to understand
• Maintainability: Separate SQL logic from Python code

Features

• SQL injection protection

License

MIT