For KsqlDB, I'd change it to read "sql" syntax. It's not SQL. Joins/Aggregates in Kafka Streams work totally differently than with "traditional" SQL, so much so that the majority of Kafka Streams developers prefer to use a jvm language over the "sql" provided by KsqlDB.