Dynamic schema per database

[newradius]

Hello,

I want to develop a no code tool like glideapps where every customer has his own database and tables.

There is enought information about the connection but I don't know how dynamic schema would work. Every client has different tables, how can I map them? I can generate the entities for them. But how can I map them, is there a limit of mapped tables?

If 100 clients generates 100 tables I would end up with 10.000 tables. Is there any way to generate the schema and load the entities by request?

Or should I go all in with dbal only?

Thanks.