Are there any plans for implementing query rewriting (i.e. allowing the optimizer to substitute materialized views for queries)
in upcoming versions? I have recently seen this answer, saying that query rewriting could be achieved using the rules system, but
I could not figure out how to. Could someone please give me some tips on how to do it? Is it possible to make a rule not to all SELECTs of a table but for a specific query? Or the trick is done with another approach?