I'm using APIs and not an SQL database, so this may be different, but I was running into similar issue. My API call would actually go through, so when I clicked cancel, everything would be good.
Try adding an event handler on the query to refresh the table on Success. That made my save prompt go away and show the new results.