I’ve been working on a small library called guess-what. The idea is simple: instead of writing boilerplate CRUD queries or repository methods, you call semantic method names and the library turns them into SQL.

For example:

db.get_user_by_id(123)

SELECT * FROM users WHERE id = ?

db.get_user_columns_name_and_email_by_status(status="active")

SELECT name,email FROM users WHERE status = ?

db.add_user(user={"name": "Alice", "email": " [email protected] ", "status": "active"})

INSERT INTO users (name,email,status) VALUES (?, ?, ?)

It supports:

sync and async database connections

keyword arguments

dataclasses

Pydantic models

dict-based reads/writes

simple dynamic SELECT / INSERT / UPDATE / DELETE

stored procedure/function calls with call_...

I’m intentionally not trying to build a full ORM like SQLAlchemy, Django ORM, or PonyORM.…