I tested TMyQuery and everything worked fine,
however I need to update to tables, second one is outer join. So I used TMyUpdateSQL where OnUpdateRecord to change ModifySQL depending whether second table on outer join needs insert or update and call
TMyUpdateSQL.Apply(UpdateKind).
With TMyQuery record refethed new values. When I set UpdateObject property of TMyQuery refresh is not called anymorel