[vineyardmike]

GnuCash has a SQL backend, so perhaps you can pick it apart (or use it as-is as a library?).

https://wiki.gnucash.org/wiki/SQL