What the Framework?! SQL

v0.3.1 2024-09-16 12:33 UTC

This package is auto-updated.

Last update: 2025-04-16 14:00:02 UTC


README

This library provides a fluent interface for generating SQL statement strings.

The DBAL library extends this library with a wrapper for PDO.

Installation

composer require wtframework/sql

Documentation

Supported grammars

  • MariaDB
  • MySQL
  • PostgreSQL
  • SQLite
  • TSQL

Supported statements

Example

use WTFramework\SQL\SQL;

echo $stmt = SQL::select()
->from('users')
->where('email_address', 'admin@example.net');
SELECT * FROM users WHERE email_address = ?


After casting the object to a string, like above, the bindings method will return an array of bound parameters.

print_r($stmt->bindings());
Array
(
    [0] => admin@example.net
)

Grammars

The default global grammar is MySQL. Use the static SQL::use method to change this. This will not apply to any existing statements.

use WTFramework\SQL\Grammar;

$stmt1 = SQL::select();

SQL::use(Grammar::TSQL);

$stmt2 = SQL::select();

// $stmt1 will use MySQL, $stmt2 will use TSQL.


The use method can also be used to override the grammar of an individual statement.

$stmt1->use(Grammar::PostgreSQL);

Extending the library

To extend the library you can use the static macro method, passing the new method name and a closure to call. This works for both static and non-static methods. This is available on the SQL class as well as all statement and service classes.

use WTFramework\SQL\SQL;

SQL::macro('count', function (string $table)
{

  return static::select()
  ->column('COUNT(*) AS counter')
  ->from($table);

});
SQL::count('users');