I'm also surprised that there's no Fuse interface, it's the first thing I expected while reading the title.
For single process crypto storage I'd sooner use a crypto shim for SQLite, I don't know if there's any good one available out there (besides the one sold by the SQLite devs).