This contains an interesting idea:

Ask ChatGPT (or other AI) to automatically create SQL which will generate a table based on some criteria...

I'm guessing it is or will be possible to ask ChatGPT to generate an entire database schema based on various criteria in the future...

How good such schemas will turn out to be?

Well, that remains to be seen(!) -- but there's a very interesting set of ideas here...