Is there an update on this? I've also noted that the configuration spark.sql.sources.partitionOverwriteMode does not affect delta tables. For what I can understand, to overwrite partitions dynamically we are stuck with spark.databricks.optimizer.dynamicPartitionPruning but only when used as join key.

It would be usefull to use .option("partitionOverwriteMode", "dynamic") for INSERT OVERWRITE statement