After being frustrated with Diesel, I gave a try to SeaORM and I couldn’t be happier (have been using it for more than a year). It is not perfect but certainly the best ORM I have ever used myself (vs Diesel, ActiveRecord, SQLAlchemy)
Also recommend reading https://www.sea-ql.org/SeaORM/docs/internal-design/diesel/
And even if you're writing queries directly, any time you need to write something dynamic, you're not going to be able to verify those at compile-time either.
I don't see why this is by its "very nature" when libraries like diesel or Prisma already do this.
> any time you need to write something dynamic, you're not going to be able to verify those at compile-time either.
Diesel can validate dynamic queries at compile time too, sqlx too to some extent.