Revert "Create CastExpression and traverse visitor pattern while performing implicit cast in ExpressionTreeMaterializer."

This reverts commit b7c76c218a7359e99140bc8ee8eeef65f950d7ee.
Add couple of optiq rule into logical plan phase. Add operator mapping for is not null, is true.