SQLx [1] is commonly recommended. It has the nice feature that your queries can be verified at compile time.
The only downside is that you have to install sqlx-cli and you have to run a couple of special commands to make your binary compile offline or on CI/CD where you don’t provide that database connection.