Deleting duplicates in a table requires a filter and checkbox deletion by hand. Updates can only be made outside of Caspio and re-imported. These basic execution SQL functions should be enabled in some form other than imports.

Especially with big data, using imports to update and delete tables is tedious at best and unachievable at worst.