Re: Dynamically create tables vs key-value which is best?

[Rick James]

> Dynamically create tables vs key-value which is best?

It's the "lesser of two evils". Neither is good.

> and therefore cannot be directly ported into a simple table.

Yes they can -- but you have to pre-process the data before doing the INSERTs.

EAV discussion, and some suggestions:
http://mysql.rjweb.org/doc.php/eav

You only touched on the last half of the task -- getting the data back out. I suggest you focus on that some more. That will help you understand why the options you presented are clumsy. You will also find out that you don't really need all the fields to be indexes; and that leads to some of what I say in that link.