SELECT counts: naive=5 batch=2 split=3 empty=1
same parent order and child contents: True
empty-child order preserved: True
other tenant item excluded: True
SQLite calls only; no remote database or latency benchmark.
