Remove External Table Backwards Compatibility Options

[tustvold]

Is your feature request related to a problem or challenge?

#8539 and #8017 made various CREATE EXTERNAL TABLE options do nothing, but avoided making them return an error if specified so as to preserve backwards compatibility.

Describe the solution you'd like

We should remove this backwards compatibility logic

Describe alternatives you've considered

No response

Additional context

#8540 and #8548 will likely remove further options

[yyy1000]

Can I help this?
It seems a code clean task about removing insert_mode option.
Edit: and also create_local_path

[alamb]

Seems reasonable to me -- @tustvold do you have any other hints?

[yyy1000]

Created #9105 that may help it. :)