Is it possible to render somewhat fluids like this?

I personally would use a scrolling tiling texture with some particles on top of it. If you want an actual simulation, you’ll probably need a 3d party plug in like houdini 3d and bake it all down.

Uncharted 4 uses a similar approach