> Worth noting: diesel definitely fulfills the "providing compile time guarantees" criteria.

Also sqlx.

I liked the article and I bookmarked the library but this statement from the author confused me a bit. At least two libraries give you pretty good compile-time guarantees. sqlx even gives you the option to specify a DB where it can check whether your queries will succeed at runtime.