After my attempt at getting this to work, I think I see the strategy. I need to process the sqlite database into a file system outside of fuse first. I need to generate unique inode numbers, attributes and path information into a usable struct. I can then easily use the fuse functions and my in memory mapping to manage how things will work.
Right now, everything is too hacky. I also need functions that can take an inode and convert it to a mapping but I also need to be able to do lookups by name and get the inode.
I think it'll go much easier once I do this first part. i would then need to call this refresh of data every now and then as the system is used to keep it fresh I imagine.