I think all ClickHouse, Druid, and Pinot support SQL to some extent, but neither one of them supports all operators and fully compliant with SQL standards.

I know nothing about Apache Kylin, would love to read a post that compares Kylin with the systems discussed in this post myself.