ClickHouse

meet waddler

Overview Get started

Fundamentals

Database connection

Connect

sql

sql sql.identifier sql.values sql.raw sql.unsafe

sql.default sql.append sql.param

Standalone sql

toSQL logger stream chunked

Types Types Mapping

Waddler SQL unsafe

This guide assumes familiarity with:

Quick start with Waddler - read here
Waddler SQL template - read here
sql.identifier - read here
sql.raw - read here

sql.unsafe lets you use a client itself by providing sql string and params

const response = await sql.unsafe('select * from users where id = {param1:String}', { "param1": 10 });

select * from users where id = {param1:String}; -- params: { "param1": 10 }