how can I manage cases where I have a merge statement , and I want to use the df.write.option(schemaOverwrite,true) flavor merge statement requires always that the tables is created beforehand, I want to avoid this

you can't avoid it, only work around it... you'll need logic to check whether the table exists and act accordingly... presumably create if not exists, merge otherwise

You can always do something like the following:

Hah yeah that's how I create all my tables nowadays.