In working on the CRUD microservice we encountered many issues with sqlx. The library is excellent but lacks some features that we needed and made us crazy implementing some types such as enums and ltree indices.

Also, testing was not easy at all.

On the other side, performances are great and the compile-time checks (also for queries) made the whole system more reliable.