Universal Query

CreateDatabaseQuery

use SQLBuilder\Universal\Query\CreateDatabaseQuery;

$q = new CreateDatabaseQuery;
$q->create('test')->characterSet('utf8');
// CREATE DATABASE `test` CHARACTER SET 'utf8'

$q = new CreateDatabaseQuery;
$q->create('test')
    ->characterSet('utf8');
$q->collate('en_US.UTF-8');
$q->toSql($driver, $args);

CREATE DATABASE "test" LC_COLLATE 'en_US.UTF-8'

CreateIndexQuery

use SQLBuilder\Universal\Query\CreateIndexQuery;
$q = new CreateIndexQuery;
$q->create('idx_salary')
    ->on('employees', [ 'last_name', 'salary' ])
    ;
$q->toSql($driver, $args);

CREATE INDEX `idx_salary` ON `employees` (last_name,salary)

DropIndexQuery

use SQLBuilder\Universal\Query\DropIndexQuery;
$q = new DropIndexQuery;
$q->drop('idx_book')->on('books');
$q->toSql($driver, $args);

DROP INDEX `idx_book` ON `books`

DeleteQuery

use SQLBuilder\Universal\Query\DeleteQuery;

$query = new DeleteQuery;
$query->delete('users', 'u')->where()
    ->equal('id', 3);
$sql = $query->toSql($driver, $args);

DELETE users AS u WHERE id = 3'