Miss Dada  🏳️‍⚧️

Have you tried Diesel?

afraid not, I've not done any rust for a while and didn't get as far as wanting a DB for anything I was doing

You should give it a shot when you have some time. It's a query builder that gives you composable pieces, and some code generation to help mapping things to/from structs, without the "try to pretend we can hide your database from you" features that folks have associated w/ ORMs

coming from Python, is it like the non-ORM portion of SQLAlchemy? the core/expression language portion of SQLAlchemy requires you know how to write SQL but lets you compose the query from components (column expressions, predicates, etc)

Yes

One thing to note, we have a focus on type safety as well. e.g. if your program compiles, you won't get runtime DB errors (stronger guarantees for select statements than insert/update/delete, triggers are turing complete after all).

This will make your code way more resilient, but also harder to make generic (e.g. a function that takes any table with a column called "name" is really difficult to express. Reach for a macro in that case).

We also focus less on DB agnostic code. It's possible, but more targeted towards library authors (dev/prod parity is good). We want you to use the features of your database to their full potential