Why wouldn't we? It's a fantastic language with great tooling, top tier performance and minimal footprint

First of all, this is not a web app.

Second, what should I use if I want a small binary with no dependencies and low CPU/RAM usage?

I could’ve used Go, but once you know Rust Go’s existence almost stops making sense :)

Rust + Axum + SQLx has been a total game-changer for me in terms of productivity developing web-based Postgres apps. I like the tooling and the libraries are great.