FWIW, I looked into it myself too, and found e.g. this direnv setup:

https://github.com/direnv/direnv/wiki/Sops