Support ClickHouse Dialect

[abraithwaite]

ClickHouse is an up-and-coming columnar OLAP database with a fairly standard SQL interface.

It would be awesome to see it supported in this project!

https://clickhouse.com/docs/zh

Fantastic work on this BTW. What you're doing is really challenging and I didn't think anybody was up to the task!

[pkthomsen]

I second that.

We actually currently use it to sanitize user-queries to ClickHouse. We use it in "Postgres" mode which is sufficiently compatible for most things. But it does lack support for all the special joins of ClickHouse, and also for the convenience notations for tuples and arrays that ClickHouse support.

So it would definitely be great to see native support for ClickHouse.

In any case thanks for the great work on this library.

[taozhi8833998]

@abraithwaite @pkthomsen I will support the ClickHouse dialect based on PostgresQL in the next version. Sorry for waiting so long

[razsightfull]

+1 Also need that!

[ThomasSertorio]

Great news ! Awesome work.
Thanks.

[HitendraSinghRathore]

Thanks a lot, really need this

[digipigeon]

+1 for needing this feature.

[johnnyfish]

+1 for needing this feature.

[guyb1]

+1, also need it.
@taozhi8833998 Do you have any idea when it might be added?

[johnnyfish]

@taozhi8833998 hey there!
Any plans to support it soon? 🙂