PQL

PQL - PHP Query Language, Database Query Library

This library is a database abstraction layer which abstracts the query commands (Select, Delete, Update, etc.) out from the drivers (MySQL, Postgres, SQL Server, etc.). Queries are defined in an eloquent way allowing you to write almost all kinds of queries without having to rely on passing raw query data.

Installation

Installation is done via composer composer install arekxv/pql

Usage

First you decide on a database to be used. See Drivers for more information.

Drivers

Following systems are supported:

  • MySQL - MySQL database via PDO

Custom drivers

Drivers which are implemented are not limited to Relational Database Systems meaning other drivers can be easily implemented for non-database or no-sql database systems like Redis, ElasticSearch, MongoDB, etc.

For implementing a custom driver see here.

Testing

After installing the dependencies run composer test

For coverage report run composer coverage or you can take a look at it here.