Adam,

<< I am slightly off topic, but I wonder whether you have looked at Client Data Sets (CDS) in Delphi in the context that you are working? >>

Another option is the cached updates in ElevateDB:

http://www.elevatesoft.com/manual?action=viewtopic&id=edb2&product=rsdelphiwin32&version=10T&topic=Cached_Updates

which simply uses the replication functionality in ElevateDB and does all of the temporary table handling for you.  The one thing that is missing, however, is "instead of" handling for updating insensitive query result sets.

Tim Young
Elevate Software
www.elevatesoft.com