README

Completely standalone, expressive SQL query creator. No database or ORM needed.

Features

No database connection required, entirely standalone
Return SQL string and params in order for PDO queries
Support for MySQL and ANSI SQL variations
Complex queries (nested where, having etc)
Simple, expressive syntax
Can return query parts at any point

Installation

Installation is via composer, in the usual manner:

{
    "require": {
        "solution10/sql": "~1.0"
    }
}

Documentation

Simple Examples

For more detailed documentation, please check the /docs folder in the repo, or the Wiki.

Select

$query = (new Solution10\SQL\Select())
    ->select(['users.name', 'locations.name'])
    ->from('users')
    ->join('locations', 'users.location_id', '=', 'locations.id')
    ->where('users.id', '>', 15)
    ->limit(25)
    ->offset(10)
    ->orderBy('name', 'DESC');

// Make use of an existing PDO object to actually run the query:
$stmt = $pdo->prepare((string)$query);
$stmt->execute($query->params());
$rows = $stmt->fetchAll();

Insert

$query = (new Solution10\SQL\Insert())
    ->table('users')
    ->values([
        'name' => 'Alex',
        'location_id' => 27
    ]);

// Use with PDO in exactly the same way as SELECT:
$stmt = $pdo->prepare((string)$query);
$stmt->execute($query->params());

Update

$query = (new Solution10\SQL\Update())
    ->table('users')
    ->where('id', '=', 15)
    ->values([
        'name' => 'Alex',
        'location_id' => 27
    ]);

// Use with PDO in exactly the same way as SELECT:
$stmt = $pdo->prepare((string)$query);
$stmt->execute($query->params());

Delete

$query = (new Solution10\SQL\Delete())
    ->table('users')
    ->where('id', '=', 27)
    ->limit(1);

// Use with PDO in exactly the same way as SELECT:
$stmt = $pdo->prepare((string)$query);
$stmt->execute($query->params());

Using other dialects

By default, S10\SQL will assume that you're using an ANSI SQL compatible database. If you're using something else, MySQL for instance, simply pass into the constructor the Dialect instance:

$query = (new Solution10\SQL\Select(new Solution10\SQL\Dialect\MySQL()))
    ->select('*')
    ->from('users')
    ->limit(10);

You can also write your own dialects by implementing Solution10\SQL\DialectInterface.

Userguide

Check out the Wiki

(or the /docs folder in the repo)

API Docs

From a checkout of this project, run:

$ make

This will create an api/ folder for you to peruse.

PHP Requirements

PHP >= 5.4

Author

Alex Gisby: GitHub, Twitter

License

MIT

Contributing

Contributors Notes

solution10 / sql

Maintainers

Details