Allow creating external tables with directories that don't exist

[alamb]

Is your feature request related to a problem or challenge?

Right now, it is not possible to create an empty external table to write

❯ create external table foo stored as parquet location '/tmp/foo';
IO error: No such file or directory (os error 2)

Describe the solution you'd like

I would like to be able to create a new external table with a directory that doesn't exist and then have datafusion create the directory on first write

create external table foo(x int) stored as parquet location '/tmp/foo/';
insert into foo values (1);

And then have a file written into /tmp/foo/name.parquet

Describe alternatives you've considered

No response

Additional context

No response