QueryBuilder

Fast, lightweight, and simple SQL query builder that does not depend on any third-party library besides PDO to execute the queries in a safe way. The syntax is inspired by Laravel Query Builder.

Important

Do not use it in production as it is still in beta and many public APIs might change.

Features

Internal bindings manager, so you do not have to worry about binding your values.
Support adding multiple and nested conditions to the Where and the Join clauses.
Support Pagination.

Installation

The recommended way to install the QueryBuilder is through Composer.

composer require abdulelahragih/querybuilder

Basic Usage

To start using it you have to first create an instance of the QueryBuilder:

$pdo = # your pdo connection
$qb = new \Abdulelahragih\QueryBuilder\QueryBuilder($pdo)
# Now you can start using it 
$result = $qb->table('users')
   ->select('id', 'username', 'phone_number', 'gender')
   ->where('role_id', '=', 1)
   ->join('images', 'images.user_id', '=', 'users.id')
   ->get();

Select with pagination

You can either use the paginate method or the simplePaginate method.

paginate will return a LengthAwarePaginator instance which contains the total number of items, the current page, the number of items per page, the total number of pages, and the number of next and previous pages.

$paginator = $qb->table('users')
   ->select('id', 'username', 'phone_number', 'gender')
   ->where('role_id', '=', 1)
   ->paginate($page, $limit);

simplePaginate will return a Paginator instance which contains the current page, the number of items per page, and the number of next and previous pages.

$paginator = $qb->table('users')
   ->select('id', 'username', 'phone_number', 'gender')
   ->where('role_id', '=', 1)
   ->simplePaginate($page, $limit);

Nested Where

You can add nested conditions to the Where clause by passing a closure to the where method.

$result = $qb->table('users')
   ->select('id', 'username', 'phone_number', 'gender')
   ->where(function ($builder) {
       $builder->where('role_id', '=', 1)
           ->orWhere('role_id', '=', 2); 
   })
   ->get();

Nested Join

You can add nested conditions to the Join clause by passing a closure to the join method.

$result = $qb->table('users')
    ->join('images', function (JoinClauseBuilder $builder) {
        $builder->on('images.user_id', '=', 'users.id');
        // you can use all where variants here
        $builder->where('images.user_id', '=', 1);
    })
    ->get();

TODOs

~~Support Update, Delete, Insert~~
Support Creating Schemas
~~Add pluck method~~
Add support for sub-queries inside the Where and Join clauses
~~Implement a Collection class and make it the return type of get()~~
Add a returning method to the query allowing you to return columns of inserted/updated row(s)
Add support for different types of databases and refactor code, so it is easy to do so
~~Add support for Transactions~~

Contribution

Any contribution to make this project better is welcome

abdulelahragih/QueryBuilder