Quarry

Introduction

Quarry is an experimental ClickHouse-native query builder for TypeScript.

Quarry is a query builder first. It is not trying to be an ORM, and it is not trying to hide ClickHouse behind a generic multi-dialect SQL abstraction.

This package is currently in early alpha. The current API is already validated against a real ClickHouse instance in integration tests, but the surface may still change before a stable release.

What it covers today

  • typed selects and inserts, including INSERT INTO ... SELECT
  • joins, subqueries, and CTEs
  • FINAL, PREWHERE, GROUP BY, and HAVING
  • toSQL() and execute()

Where to start

On this page