Calculate difference between remote and local sets in sql

Question

I often find my self calculating difference between remote local data (result = items only in remotes are inserts, items only in locals are deletes, rest is updates).

Its very simple algo in higher level language:

query remotes
query locals

for local in locals
   if local is found in remotes
       to_update += remote
       remotes -= local
   else
       to_delete += local

to_insert = remotes

for _ in to_insert
  sql insert

for _ in to_update
  sql update

for _ in to_delete
  sql delete

Is there a way to do this only inside sqlite database without any java/kotlin?

Thanks