node-sql-parser icon indicating copy to clipboard operation
node-sql-parser copied to clipboard

Published 20 hours ago • verified publisher icon taozhi8833998

Support ClickHouse Dialect

Open abraithwaite opened this issue 11 months ago • 6 comments

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!

abraithwaite avatar Mar 19 '24 17:03 abraithwaite

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.

pkthomsen avatar Apr 16 '24 06:04 pkthomsen

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

taozhi8833998 avatar Apr 17 '24 01:04 taozhi8833998

+1 Also need that!

razsightfull avatar May 09 '24 14:05 razsightfull

Great news ! Awesome work. Thanks.

ThomasSertorio avatar May 13 '24 09:05 ThomasSertorio

Thanks a lot, really need this

HitendraSinghRathore avatar May 27 '24 18:05 HitendraSinghRathore

+1 for needing this feature.

digipigeon avatar Jul 04 '24 15:07 digipigeon