schema-first-query 0.1.0

Introspect a live database and generate typed, autocomplete-friendly query helpers — no ORM required.

schema-first-query

Introspect a live database and get typed, autocomplete-friendly query helpers — no ORM, no model classes, no boilerplate.

---

Motivation

Python developers working with relational databases face an uncomfortable tradeoff. Raw SQL with dict rows is fast and flexible, but offers no type safety, no IDE autocomplete, and fragile string-key access that breaks silently when columns are renamed. Full ORMs like SQLAlchemy or Django ORM are typed and ergonomic, but they require maintaining Python model classes that duplicate the database schema — a form of drift-prone redundancy that grows more painful as the schema evolves.

The middle ground — lightweight query builders like SQLAlchemy Core or PyPika — reduces boilerplate but still returns untyped rows, or requires you to write TypedDict definitions by hand. Either way, the schema lives in two places: the database and your Python code.

schema-first-query eliminates that duplication. It connects to your database (or reads your SQL migration files), introspects the schema once, and generates TypedDict or dataclass types on the fly. Your IDE sees fully typed results with autocomplete. Your code stays DRY. The database schema remains the single source of truth — exactly as it should be in a database-first workflow.

---

Installation