Version 0.1.0

SQLStratum v0.1.0

SQLStratum v0.1.0 is the first public release of a typed, deterministic SQL query builder/compiler with a SQLite runner and hydration pipeline.

Highlights

• Deterministic SQL compilation: identical AST inputs produce identical SQL and params
• Typed, composable DSL for SELECT, INSERT, UPDATE, DELETE
• Safe parameter binding (no raw SQL interpolation)
• Hydration pipeline with dict/dataclass/callable targets
• SQLite-first runner with explicit execution boundary and transaction support
• Test-driven baseline across compile, runner, hydration, and SQLite integration paths

Included in 0.1.0

• Core AST and expression model
• SQL compiler for SQLite
• Public DSL chaining helpers
• Metadata model (Table / Column)
• Runner API for execution and transactions
• Hydration utilities and projection key handling
• Initial docs and examples

Design Boundaries

SQLStratum v0.1.0 intentionally does not include:

• ORM behaviors (identity map, relationships, lazy loading)
• Migrations/DDL framework
• Multi-dialect abstraction layer
• SQL string templating approach

Install

pip install sqlstratum==0.1.0

Quick Example

from sqlstratum import SELECT, Table, col

users = Table("users", col("id", int), col("email", str))
q = SELECT(users.c.id, users.c.email).FROM(users).WHERE(users.c.id == 1)

Notes

This release establishes the foundation and API direction for upcoming dialect and integration expansion while preserving determinism and strict layering.