MergeCursor seems like it might be useful but would need extending, along with extending OrmLiteCursorAdapter<Object>, to select the PreparedQuery depending on which child cursor is backing the current row.
MergeCursor doesn't seem to have a way to find out what the current child cursor is, and clashing _id values will need to be mapped to (ideally constant) unique values.
I think the above is doable but is there an easier way?
Thanks
Neil