Hello Julian
At this point there is no direct function like lateral or Cross Apply & we are planning to have it as a general purpose feature in some point in time in future.
Can we have the exact use case you want to achieve to see other ways to achieve it in SingleStore.