inconsistency in write_mode between different write_ methods

[universalmind303]

Describe the bug

for many of the write_ methods, there is a kwarg called either mode or write_mode. This should be consistent across all write_ methods. Many of them also have different modes available.

To Reproduce

def write_parquet(
  # ...
  write_mode: Literal["append", "overwrite", "overwrite-partitions"] = "append",
)

def write_csv(
  # ...
  write_mode: Literal["append", "overwrite", "overwrite-partitions"] = "append",
)

def write_iceberg(
  # ...
  mode: str = "append", # only supports (append | overwrite)
)

def write_deltalake(
  # ...
  mode: Literal["append", "overwrite", "error", "ignore"] = "append",
)

def write_lance(
  # ...
  mode: Literal["create", "append", "overwrite"] = "create",
)

Expected behavior

the write_ methods should have at a minimum a consistent naming. either write_mode or mode.

additionally, it would be nice if other write modes were supported for parquet/csv/iceberg (error & ignore)

Component(s)

Other

Additional context

No response