@sammyw commenting to hopefully get some attention to this! I just posted something about this myself over here. All the other threads I've seen about this don't seem to have a good solution.
The workaround that I've been using so far is to use a transformer to parse out updates vs inserts, then do two separate database queries to do updates and inserts. Annoying, but it does the job. Hoping Retool fixes this soon. 