Skip to content

habracoder/ch-builder

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

15 Commits
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

PHP QueryBuilder for ClickHouse SQL

Simple query builder

Building insert query

$data = [
    ['id' => 123, 'clicks' => 1],
    ['id' => 124, 'clicks' => 1],
];
$sql = (string) $qb
    ->insert($data)
    ->into('statistic_clicks')
    ->database('analytics');

Building select query

$sql = (string) $qb
    ->select('date', 'id', 'clicks')
    ->from('statistic_clicks')
    ->database('analytics')
    ->where(
        $qb->expr()->andX(
            $qb->expr()->eq('id', 123),
            $qb->expr()->gt('clicks', 10)
        )
    );