A look into Flink SQL joins and how to use them, specifically how to perform temporal table joins between a non-compacted and compacted Kafka topic