ClickHouse query builder

Problem Statement

As we want to fire queries on ClickHouse it makes sense to use a query builder instead of writing plain SQLs. it should support building SQL and we should keep its interface the same as ActiveRecord. for example below:

query_builder = QueryBuilder.new('users')
query = query_builder.where(name: 'John', age: 21).order('created_at', 'desc').limit(10).offset(5)
query.to_sql

Implementation Plan

  1. Write a query builder class which supports the above use-case.

This POC !127109 (closed) can be used as a reference.

Edited Jul 31, 2023 by Harsimar Sandhu
Assignee Loading
Time tracking Loading