aliases are missed here (start_ts, update_ts)

" could be dropped

commit is lost (note, that we should also clean commit_pending of _dml in such situation)

don't drop it

exclusive: True

r is None for strict=False, so just return query.singleValue(strict=False) works for both cases

same here

rollback/commit logic is omitted here

sing percent sign

clauses.extend() vs clauses +=

same here

what is this good for?

double percent

• Sometimes reduced code led to pattern "result = query.Execute; return result" - these cut be collapsed to one result statement.
• similarly for some joins - they could fit in one line now
• Please, revisit all commit/rollbacks.

@tkopecek all fixed

missing rowlock?

Commit e84a0fb9 fixes this pull-request