clickhouse-sql-client

JSON →
library 1.0.5 ·javascript
verified Jun 5, 2026

A lightweight, TypeScript-based SQL query builder for ClickHouse. Version 1.0.5 provides a fluent API to construct SELECT, INSERT, UPDATE, and DELETE queries with ClickHouse-specific features like PREWHERE, LIMIT BY, and raw expressions. It simplifies generating complex SQL strings without runtime dependencies, supporting subqueries, aggregations, and clickhouse-specific functions. Ideal for Node.js applications needing a type-safe query builder with full ClickHouse dialect support. Maintained on GitHub with sparse updates.