SQL-like e.g. Clickhouse

[KirIgor]

We use Sequel for PostgreSQL in our application. Also we try to use it for Clickhouse.

Something like that:

CH.execute(DB.from(:something).select(:id).sql)

Clickhouse uses not exactly SQL but SQL-like language. What do you think about making native support for Clickhouse and other SQL-like languages?

[KirIgor]

Also for example there is FINAL keyword in Clickhouse:

CH.execute(DB.from(Sequel.lit("transactions FINAL")).select(:id).sql)

It's more complicated.

[KirIgor]

https://clickhouse.com/docs/sql-reference/statements/select/from#final-modifier

[KirIgor]

CH is ClickHouse.connection

https://github.com/shlima/click_house

[jeremyevans]

It's probably best that you work on an external Sequel adapter for ClickHouse, similar to other external Sequel adapters listed at https://sequel.jeremyevans.net/plugins.html#extensions-external-adapters

[KirIgor]

Thank you!