Comment by Vadim_samokhin

I think postgres really excelled at this pattern. As well as other databases implementing a query planner.