fix: preserve write_default when applying a name mapping #9167

Job	Run time
integration-test-adls	1m 19s
integration-test-gcs	1m 7s
integration-test	10m 57s
lint-and-unit-test (3.13)	3m 29s
lint-and-unit-test (3.14)	2m 39s
lint-and-unit-test (3.10)	3m 28s
lint-and-unit-test (3.12)	3m 4s
lint-and-unit-test (3.11)	3m 18s
integration-test-s3	1m 9s
cibw-dev-env-smoke-test	26s
integration-coverage-report	36s
	31m 32s

Provide feedback