See demos:

• AnyDAC\Samples\Comp Layer\TADQuery\CachedUpdates\OnUpdateRecord
• AnyDAC\Samples\Comp Layer\TADUpdateSQL\Main