Search by 
michaelrushton / sql
A library to generate SQL statement strings using a fluent interface.
dev-main
2025-06-19 16:01 UTC
Requires
- php: ^8.2
Requires (Dev)
- pestphp/pest: ^3.7
This package is auto-updated.
Last update: 2025-07-19 16:10:08 UTC
README
A PHP library to generate SQL statement strings using a fluent interface.
See also https://github.com/MichaelRushton/php-db for an extension that provides a PDO wrapper.
Installation
composer require michaelrushton/sql
Documentation
Supported dialects
use MichaelRushton\SQL\SQL; SQL::MariaDB SQL::MySQL SQL::PostgreSQL SQL::SQLite SQL::TransactSQL
DELETE example
See DELETE documentation.
echo $stmt = SQL::SQLite->delete() ->from("users") ->where("email_address", "john@example.com"); // Only after casting $stmt to a string print_r($stmt->bindings());
DELETE FROM users WHERE email_address = ?
Array
(
[0] => john@example.com
)
INSERT example
See INSERT documentation.
echo $stmt = SQL::SQLite->insert() ->into("users") ->columns(["name", "email_address"]) ->values([ ["John", "john@example.com"], ["Jane", "jane@example.com"], ]); // Only after casting $stmt to a string print_r($stmt->bindings());
INSERT INTO users (name, email_address) VALUES (?, ?), (?, ?)
Array
(
[0] => John
[1] => john@example.com
[2] => Jane
[3] => jane@example.com
)
REPLACE example
MariaDB, MySQL, and SQLite only.
echo $stmt = SQL::SQLite->replace() ->into("users") ->columns(["name", "email_address"]) ->values([ ["John", "john@example.com"], ["Jane", "jane@example.com"], ]); // Only after casting $stmt to a string print_r($stmt->bindings());
REPLACE INTO users (name, email_address) VALUES (?, ?), (?, ?)
Array
(
[0] => John
[1] => john@example.com
[2] => Jane
[3] => jane@example.com
)
SELECT example
See SELECT documentation.
echo $stmt = SQL::SQLite->select() ->from("users") ->where("email_address", "john@example.com"); // Only after casting $stmt to a string print_r($stmt->bindings());
SELECT * FROM users WHERE email_address = ?
Array
(
[0] => john@example.com
)
UPDATE example
See UPDATE documentation.
echo $stmt = SQL::SQLite->update() ->table("users") ->set("name", "John") ->where("email_address", "john@example.com"); // Only after casting $stmt to a string print_r($stmt->bindings());
UPDATE users SET name = ? WHERE email_address = ?
Array
(
[0] => John
[1] => john@example.com
)