Sync ssot

Placeholder, needs more tests and comments. 
Fixes #1919 #1814 #2057 #2191 #2177 #2125 #2100 #1848 #1790 #1532 #1389 #1308

addRecord does a containment check, would pushRecord make sense?

Ultimately making the containment check utilized the existing indexes would make this suggestion pointless.