PHPackages                             phizzl/querygenerate - PHPackages - PHPackages  [Skip to content](#main-content)[PHPackages](/)[Directory](/)[Categories](/categories)[Trending](/trending)[Leaderboard](/leaderboard)[Changelog](/changelog)[Analyze](/analyze)[Collections](/collections)[Log in](/login)[Sign up](/register)

1. [Directory](/)
2. /
3. phizzl/querygenerate

AbandonedArchivedLibrary

phizzl/querygenerate
====================

1.0.0(9y ago)026PHP

Since Apr 5Pushed 9y ago1 watchersCompare

[ Source](https://github.com/phizzl/querygenerate)[ Packagist](https://packagist.org/packages/phizzl/querygenerate)[ RSS](/packages/phizzl-querygenerate/feed)WikiDiscussions master Synced 2mo ago

READMEChangelog (1)DependenciesVersions (2)Used By (0)

QueryGenerate
=============

[](#querygenerate)

This is a library to generate plain SQL statements by describing the table in PHP.

Example:

```
use Phizzl\QueryGenerate\Drivers\MysqlDriver;
use Phizzl\QueryGenerate\Drivers\MysqlQueryEscape;
use Phizzl\QueryGenerate\Factory\Factory;
use Phizzl\QueryGenerate\QueryGenerator;

$loader = require_once __DIR__ . '/vendor/autoload.php';

$driver = new MysqlDriver();
$driver->setQueryEscape(new MysqlQueryEscape());
$factory = new Factory();
$factory->setDriver($driver);

$generator = new QueryGenerator($factory);
echo $generator
    ->table('test', array('engine' => 'InnoDB', 'collation' => 'utf8_general_ci'))
    ->setIsCreated(true)
    ->addColumn('OXID', 'char', array('length' => 32, 'collation' => 'latin1_general_ci'))
    ->addColumn('test', 'int', array('length' => 11, 'autoincrement' => true))
    ->changeColumn('Spalte 1', 'TINYINT', array('rename' => 'Spalte Spass', 'length' => 1))
    ->addIndex(array('test'))
    ->setPrimaryKey(array('OXID'))
    ->generate();
```

###  Health Score

26

—

LowBetter than 43% of packages

Maintenance20

Infrequent updates — may be unmaintained

Popularity6

Limited adoption so far

Community4

Small or concentrated contributor base

Maturity63

Established project with proven stability

How is this calculated?**Maintenance (25%)** — Last commit recency, latest release date, and issue-to-star ratio. Uses a 2-year decay window.

**Popularity (30%)** — Total and monthly downloads, GitHub stars, and forks. Logarithmic scaling prevents top-heavy scores.

**Community (15%)** — Contributors, dependents, forks, watchers, and maintainers. Measures real ecosystem engagement.

**Maturity (30%)** — Project age, version count, PHP version support, and release stability.

###  Release Activity

Cadence

Unknown

Total

1

Last Release

3327d ago

### Community

Maintainers

![](https://www.gravatar.com/avatar/9c97e3bef66ef0074ad9f0fe89d74a6bec22b2940cf11f4cb41707e15c316589?d=identicon)[phizzl](/maintainers/phizzl)

### Embed Badge

![Health badge](/badges/phizzl-querygenerate/health.svg)

```
[![Health](https://phpackages.com/badges/phizzl-querygenerate/health.svg)](https://phpackages.com/packages/phizzl-querygenerate)
```

PHPackages © 2026

[Directory](/)[Categories](/categories)[Trending](/trending)[Changelog](/changelog)[Analyze](/analyze)