Would a standard query/view allow me to identify the list of sermon themes, LCV, topics etc. or are the tables encrypted in some way?
They're not in SQLite tables. Unfortunately, they're in unreadable index files, stored in the Resource directory.
