Embar: https://github.com/carderne/embar

A Python ORM, inspired by Drizzle and the like. Whenever I come to Python I'm frustrated by the ORM options. They generally lack type-safety on inputs and outputs, or useful type hints.

SQLAlchemy is an institution but I think it's hard to use if it's not your full-time job. I check the docs for every query. I want something simple for the 80-99% of cases, that lets you drop easily into raw SQL for the remaining %.

I'm going to keep hacking at it, would love to from anyone who thinks this is worthwhile (or not). Also: - The interface for update queries is clunky. Should I add codegen? - Should I try to implement a SQL diffing engine (for migrations). Or just vendor sqldef/similar...?