semperton / query

A small and standalone SQL query builder.

Maintainers

Details

github.com/semperton/query

Source

Issues

Installs: 58

Dependents: 1

Suggesters: 0

Security: 0

Stars: 0

Watchers: 0

Forks: 0

Open Issues: 0

pkg:composer/semperton/query

1.0.0 2022-06-01 08:38 UTC

Requires

php: >=7.2

Requires (Dev)

Suggests

None

Provides

None

Conflicts

None

Replaces

None

MIT 840aa598b20f02aeb416ba1606926bf42f3a1a82

This package is auto-updated.

Last update: 2025-10-08 16:29:31 UTC

README

Semperton Query

A small and standalone SQL query builder.

Installation

Just use Composer:

composer require semperton/query

Query requires PHP 7.2+

Intro

This is a SQL query builder only. All Instances of ExpressionInterface provide a compile method which takes a parameter array by reference and returns a parameter substituted SQL string that can be used with PDO for example.

$queryFactory = new QueryFactory();
$userSelect = $factory->select('user')->limit(5);

$sql = $userSelect->compile($params); // $params is passed by reference

$pdo = new PDO('dsn');
$stm = $pdo->prepare($sql);
$stm->execute($params);
$users = $stm->fetchAll();

// ...

Usage

Use your editor's autocomplete features for now ;)