What do you mean by an entity being split?
And by merging transaction tables? Does it involve combining history from two different tables for same entities (rows with same ids)?
For example Say I have a PersonDetails source table I would like 2 staging/audit tables one for PersonAddress and one for PersonContacts.
I have PersonAddress and PersonContacts(source tables) and 1 audit/staging table which combines these 2 entities(Address and Contacts) into a PersonDetails audit/staging table.
The second use case is more important for us.
Hope this makes sense.
So you would like to have two tables in the "current" version, and one table in the "audit" one? I don't think that's possible with Envers unfortunately.
If I understand you correctly, that is.