I played around a bit with hledger, but ultimately did not see a reason to switch from ledger. I don’t remember if I ran into any issues, but at least they are not totally compatible.

https://ledger-cli.org/

I stopped looking after I found ledger-cli.

Besides CSV, if you want to have lots of optional fields, a YAML file in a git repository is an option. Use yq or to query it.

https://github.com/mikefarah/yq