But I have no examples of non-inline footnotes or prefaces.
A few months ago I completed and uploaded an edition of the Maori Bible, of which a great deal of text, color, and paragraph formatting went into it. All of this work was done in SQLite Manager. Prior to this I had no idea of RTF coding, and so it was a real steep learning curve for me. What was (and still is) even worse was that my understanding of and ability to speak Te Reo Maori was and is extreme limited, and so checking if a word was correctly spelled and etc was quite a daunting task. So, then being dependent on a couple of Maori dictionaries which didn't have all the words and loan words even further exasperated the problems I was facing. However, I muddled my way through it, and put out an edition that, by the looks of it, all the typos, incorrect spelling was fixed. So in many respects I understand the frustrations you are facing.
Adding in text is not difficult to do, and as for footnotes and etc is also not difficult to do even working from a Database manager to do providing you know a bit of RTF code. For more information on RTF specification and code, just click on the link below to download it for your reference.
As for the Preface, and/or introduction of a work, usually this is placed in the Comments field of the Details table of the Database.
Well, I trust this has been helpful to you.
Oh yeah, before I forget, When I did the Maori Bible, I used an existing Bible database file as the template. All that was changed was the actual data. That meant I didn't have to create a database file from scratch.
Blessings,