That is a modified [increased opacity] LightWorks material as applied to the waterwave object - a poly mesh of adjustable amplitude - reflecting the actual background elements of the scene.
So, unlike the old days, we didn't need to cheat.
LightWorks allows for control of five aspects of material quality, including a sort of fuzzy blob opacity that is ideal for mapping a water surface.
Dwight Atkinson