Add table name aliasing to named scopes.
Add UNION clause support.
Add IN operator support.