The SPIP to standardize SQL logical plans (SPARK-23521) proposes AppendData for inserting data in append mode. This is the simplest plan to implement first.
DataSourceV2 should apply some validation when writing.
SQL/Hive insertInto has unexpected results
SPIP: Standardize SQL logical plans with DataSourceV2
[Github] Pull Request #21305 (rdblue)
[Github] Pull Request #22043 (rdblue)