[AUDIT 4.0] [SPARK-50286][SQL] Correctly propagate SQL options to WriteBuilder

[tgravescs]

Describe the bug

[SPARK-50286][SQL] Correctly propagate SQL options to WriteBuilder

apache/spark@976f8875edd

SPARK-49098 introduced a SQL syntax to allow users to set table options on DSv2 write cases, but unfortunately, the options set by SQL are not propagated correctly to the underlying DSv2 WriteBuilder

We ideally should add tests for the new SQL syntax with options to make sure our writers handle it properly.

I think the only datasource.v2 writers we have is the delta lake one and I think we handle options there right but filing to double check as well.

[tgravescs]

along with the above check apache/spark@5dc65a5416b