search

taozhi8833998 / node-sql-parser

Parse simple SQL statements into an abstract syntax tree (AST) with the visited tableList and convert it back to SQL
https://taozhi8833998.github.io/node-sql-parser/
Apache License 2.0
750 stars 172 forks source link

Support ClickHouse Dialect #1835

Open abraithwaite opened 3 months ago

abraithwaite commented 3 months ago

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 commented 2 months ago

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 commented 2 months ago

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

razsightfull commented 1 month ago

+1 Also need that!

ThomasSertorio commented 1 month ago

Great news ! Awesome work. Thanks.

HitendraSinghRathore commented 1 month ago

Thanks a lot, really need this

digipigeon commented 22 hours ago

+1 for needing this feature.