Is there possiblity to use cross apply or join lateral in ksql ?
Those keywords are not supported. However, note that joins in ksqlDB are temporal joins by default. (Not 100% the same what “lateral” gives you, because we only store a single version per record in the table atm, but actually quite close: in fact, if there is no out-of-order data, it’s exactly the same as a lateral join.)
The Kafka Summit talk “The Flux Capacitor of Kafka Streams and ksqlDB” might help.