Pushdown optimization stops at the transformation <transformation name> because no port depends on values from the upstream transformation <transformation name>.
You created an expression that does not use upstream output port values. The Integration Service cannot generate an SQL statement for an expression that does not use output ports from upstream transformations because it cannot determine the values to use.