Hi, I have a schema with a lot of normalized tables, which makes it hard for users to build the queries.
I would like to create views with all the joins already included so that users could just select the fields without worrying with multiple tables and join conditions. But the optimizer should drop all the tables that are not actually used (when possible), otherwise the performance is not good. Any suggestion? How can I register my own rules besides the build in rules when connecting through CalciteConnection? Best regards, Luis Fernando
