Hello, I am looking to put together a quick and dirty query optimizer for a project. Going through calcite rules, there are a lot of pre-defined rules. Is there some "pre-packaged" collection of these rules that can serve as a good starting point for an optimizer? I came across the following "standard" program which feels relevant but going through the code, I don't see a lot of rules being invoked from it. In particular, I was expecting to see a bunch of rules defined in CoreRules to be listed there but it does not seem like they are? Unless I am missing something.
https://github.com/apache/calcite/blob/92309ed4c2d2156eaffc3900d55abc7ff741c0da/core/src/main/java/org/apache/calcite/tools/Programs.java#L250-L283 Let me know if Calcite provides some good starting point that I can build upon. Regards!
