After doing some research I think I will give https://github.com/SeaQL/sea-orm a try and implement it.

Interesting reads about different ORM options:

• https://www.shuttle.rs/blog/2024/01/16/best-orm-rust
• https://www.sea-ql.org/SeaORM/docs/internal-design/diesel/