(my) theoretical implementation:
Given you can draw the fog yourself
1: Define a (Clip) Plane in worldspace, facing upwards.
2: A Postprocess runs over the Screen and checks if a ScreenPixel is in front or beyond that plane
3: For each pixel which is beyond the plane calculate the desired effect