> The problem with this DB system is that you have to know all the queries before you can define the schema

Not true.

You just need to optimise your schema if you want the best performance. Exactly the same as an RDBMS.