With Kafka Connect, we can build clients in several programming languages: JVM (Java, Clojure, Scala), C/C++, C#, Python, Go, Erlang, Ruby, Node.js, Perl, PHP, Rust, and Swift. In addition to this, if your programming language is not listed, you can use the Kafka REST proxy. But the Kafka authors realized that all programmers, especially data engineers, can all talk the same language: Structured Query Language (SQL). So, they decided to create an abstraction layer on Kafka Streams in which they could manipulate and query streams using SQL.
KSQL is a SQL engine for Apache Kafka. It allows writing SQL sentences to analyze data streams in real time. Remember that a stream is an unbounded data structure, so we don't know where it begins, and we are constantly receiving new data. Therefore, KSQL queries usually keep generating results until you stop them.
KSQL...