Why did nobody suggest this article early on
There is a white paper on using SQL to edit and work with geodatabases. It is not the white paper I was asking for but it does answer some of my earlier questions about using SQL directly to query and edit a geodb. It also covers working with versioned data. If you know there are things like this out there then just tell me how to search for it. I looked all over support and google searches but found it in the project center.