Update queries

Run update queries to update table rows. Also needed by soft deleted,
where the row will be only updated and marked as deleted.
Where is not set

Set the where to protected _where property, so it gets processed by the
_setWhere method. Also A little bit shorter version of soft
deleting/updating.