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
- Write a query builder class which supports the above use-case.
This POC !127109 (closed) can be used as a reference.
Edited by Harsimar Sandhu