Rewrite a SQL query plan tree

A query plan is a tree of scan, filter, project and join nodes. Write rewrite rules that make it cheaper, such as moving a filter beneath a join, while the new plan still returns exactly the same rows.