feat(clickhouse-driver): Switch from apla-clickhouse to @clickhouse/client

[mcheshkov]

Check List

• [x] Tests has been run in packages where changes made if available
• [x] Linter has been run for changed code
• [x] Tests for the changes have been added if not covered yet
• [x] Docs have been added / updated if required

Description of Changes Made (if issue reference is not provided)

Switch client library used to talk to ClickHouse to upstream one. Lots of related changes:

• Streaming now does not use streaming JSON parser, so we can't rely on meta field in JSON format. Instread it relies on JSONCompactEachRowWithNamesAndTypes: first two rows returned should contain names and types. https://clickhouse.com/docs/en/sql-reference/formats#jsoncompacteachrowwithnamesandtypes
• Streaming now use async iterators instread of Node.js streams internally. External API returns stream, as before
• Pooling moved completely to client library. generic-pool is not used at all, dbMaxPoolSize is passed to client library to limit open sockets. New client maintains http.Agent internally, and have it's own idle timers, looks fine for us.
• Queries now does not send session_id, as we anyway expect queries to be independent, and don't use session-bound stuff, like temporary tables. Previous behaviour was kind of weird: session ids were attached to client in pool, but for every query it would pull acquire new client from pool, so nothing could actually utilize same session.
• KILL QUERY on cancellation now uses separate client instance, to avoid getting stuck on busy pool
• query method supports only SELECT queries, or other queries that return result sets. For DDL queries on this client library one have to use other methods. Because of that more overrides were necessary, like dropTable, createSchemaIfNotExists or createTable.
• Driver now respects per-datasource dbQueryTimeout config

[vercel[bot]]

The latest updates on your projects. Learn more about Vercel for Git ↗︎

8 Skipped Deployments

| Name | Status | Preview | Comments | Updated (UTC) | | :--- | :----- | :------ | :------- | :------ | | **examples-angular-dashboard** | ⬜️ Ignored ([Inspect](https://vercel.com/cube-dev/examples-angular-dashboard/vcJjkroVLwNG5SbPAPSmeLN4Jv86)) | [Visit Preview](https://examples-angular-dashboard-git-clickhouse-switc-8864e1-cube-dev.vercel.app) | | Nov 19, 2024 5:16pm | | **examples-react-d3** | ⬜️ Ignored ([Inspect](https://vercel.com/cube-dev/examples-react-d3/Fz3kW1ryVajyxLKNdz4xDr68PHr5)) | [Visit Preview](https://examples-react-d3-git-clickhouse-switch-driver-cube-dev.vercel.app) | | Nov 19, 2024 5:16pm | | **examples-react-dashboard** | ⬜️ Ignored ([Inspect](https://vercel.com/cube-dev/examples-react-dashboard/ABsBjFkUdT7GsUfgUdR4x625hHRa)) | [Visit Preview](https://examples-react-dashboard-git-clickhouse-switch-driver-cube-dev.vercel.app) | | Nov 19, 2024 5:16pm | | **examples-react-data-table** | ⬜️ Ignored ([Inspect](https://vercel.com/cube-dev/examples-react-data-table/9L7xUkUQidkvD4pQpSdGCXu9KVPb)) | [Visit Preview](https://examples-react-data-table-git-clickhouse-switch-driver-cube-dev.vercel.app) | | Nov 19, 2024 5:16pm | | **examples-react-highcharts** | ⬜️ Ignored ([Inspect](https://vercel.com/cube-dev/examples-react-highcharts/CESqQKfWCC25yvka1YLoxdDHR2UK)) | [Visit Preview](https://examples-react-highcharts-git-clickhouse-switch-driver-cube-dev.vercel.app) | | Nov 19, 2024 5:16pm | | **examples-react-material-ui** | ⬜️ Ignored ([Inspect](https://vercel.com/cube-dev/examples-react-material-ui/BHSGWHagnTPwYwzPcMuq9Py2WWmY)) | [Visit Preview](https://examples-react-material-ui-git-clickhouse-switc-2e9a2d-cube-dev.vercel.app) | | Nov 19, 2024 5:16pm | | **examples-react-pivot-table** | ⬜️ Ignored ([Inspect](https://vercel.com/cube-dev/examples-react-pivot-table/Fpq4Cg3DhWZkHnkdeNeEe4ZN8SM7)) | [Visit Preview](https://examples-react-pivot-table-git-clickhouse-switc-96b956-cube-dev.vercel.app) | | Nov 19, 2024 5:16pm | | **examples-vue-query-builder** | ⬜️ Ignored ([Inspect](https://vercel.com/cube-dev/examples-vue-query-builder/5ySz2QXUyZ95SAvHiNkcyUByZBRm)) | [Visit Preview](https://examples-vue-query-builder-git-clickhouse-switc-f3bccf-cube-dev.vercel.app) | | Nov 19, 2024 5:16pm |