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