PHPackages                             coral-sql/coral-sql - 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. [Database & ORM](/categories/database)
4. /
5. coral-sql/coral-sql

ActiveLibrary[Database & ORM](/categories/database)

coral-sql/coral-sql
===================

1.1.3(4y ago)244.2k[1 PRs](https://github.com/rymizuki/coral-sql/pulls)MITPHP

Since Jul 9Pushed 3y agoCompare

[ Source](https://github.com/rymizuki/coral-sql)[ Packagist](https://packagist.org/packages/coral-sql/coral-sql)[ RSS](/packages/coral-sql-coral-sql/feed)WikiDiscussions master Synced 2d ago

READMEChangelog (5)Dependencies (2)Versions (10)Used By (0)

CoralSQL
========

[](#coralsql)

[![Build Status](https://camo.githubusercontent.com/dcb2cf779e0277c1468955f2ad3e5f75a7dd54955fefa0cecf34436faec691d5/68747470733a2f2f7472617669732d63692e6f72672f72796d697a756b692f636f72616c2d73716c2e7376673f6272616e63683d6d6173746572)](https://travis-ci.org/rymizuki/coral-sql)[![Codacy Badge](https://camo.githubusercontent.com/64cabe72924f41f4de2bbb566e8106a4711614f4e2c71c9ac4cc288379087f56/68747470733a2f2f6170692e636f646163792e636f6d2f70726f6a6563742f62616467652f47726164652f3230333535346566386236663435306662646430633937306638653431393966)](https://www.codacy.com/app/ry-mizuki/CoralSQL?utm_source=github.com&utm_medium=referral&utm_content=rymizuki/CoralSQL&utm_campaign=Badge_Grade)[![Codacy Badge](https://camo.githubusercontent.com/a5269fec96429aa2f56310309cd1dff631d6f188234728a6d637024dc91a7346/68747470733a2f2f6170692e636f646163792e636f6d2f70726f6a6563742f62616467652f436f7665726167652f3230333535346566386236663435306662646430633937306638653431393966)](https://www.codacy.com/app/ry-mizuki/CoralSQL?utm_source=github.com&utm_medium=referral&utm_content=rymizuki/CoralSQL&utm_campaign=Badge_Coverage)

The PHP module for building SQL by complex and related like a coral.

about
-----

[](#about)

```
use CoralSQL\Builder;

$login = (new Builder)
    ->column(Builder::unescape('COUNT(*)'), 'amount')
    ->from('user_login', 'login')
    ->where('login.user_id', Builder::unescape('`user`.`id`'))
    ->where(
        (new Conditions())
            ->and('login.created_at', 'between', ['2019-06-01 00:00:00', '2019-06-30 23:59:59'])
    )
    ;

$builder = (new Builder)
    ->column('id')
    ->column('name')
    ->column('attr.address', 'address')
    ->form('user')
    ->leftJoin('user_attribute', 'attr', '`user`.`id` = `attr`.`user_id`')
    ->where('user.status', 1)
    ->where((new Conditions())->add($login, '>', 1))
    ->orderBy('id', 'desc')
    ;
```

```
SELECT
    `id`,
    `name`,
    `attr`.`address` AS `address`
FROM
    `user`
LEFT JOIN `user_attribute` AS `attr` ON `user`.`id` = `attr`.`user_id`
WHERE `user`.`status` = 1 AND (SELECT
    COUNT(*) AS `amount`
FROM
    `user_login` AS `login`
WHERE
    (`login`.`user_id` = `user`.`id`) AND (`login`.`created_at` BETWEEN "2019-06-01 00:00:00" AND "2019-06-30 23:59:59")
) > 1
ORDER BY
    `id` DESC
```

installation
------------

[](#installation)

usage
-----

[](#usage)

###  Health Score

33

—

LowBetter than 75% of packages

Maintenance20

Infrequent updates — may be unmaintained

Popularity24

Limited adoption so far

Community8

Small or concentrated contributor base

Maturity65

Established project with proven stability

 Bus Factor1

Top contributor holds 97.4% of commits — single point of failure

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

Every ~154 days

Recently: every ~91 days

Total

7

Last Release

1575d ago

### Community

Maintainers

![](https://www.gravatar.com/avatar/24fab85661cb8ffbe0e1b435c502499516055455b2f8d937545a9af7d2b16dd1?d=identicon)[mizuki-r](/maintainers/mizuki-r)

---

Top Contributors

[![rymizuki](https://avatars.githubusercontent.com/u/475302?v=4)](https://github.com/rymizuki "rymizuki (37 commits)")[![dependabot[bot]](https://avatars.githubusercontent.com/in/29110?v=4)](https://github.com/dependabot[bot] "dependabot[bot] (1 commits)")

###  Code Quality

TestsCodeception

### Embed Badge

![Health badge](/badges/coral-sql-coral-sql/health.svg)

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

###  Alternatives

[doctrine/orm

Object-Relational-Mapper for PHP

10.2k285.3M6.2k](/packages/doctrine-orm)[jdorn/sql-formatter

a PHP SQL highlighting library

3.9k115.1M102](/packages/jdorn-sql-formatter)[illuminate/database

The Illuminate Database package.

2.8k52.4M9.4k](/packages/illuminate-database)[mongodb/mongodb

MongoDB driver library

1.6k64.0M546](/packages/mongodb-mongodb)[ramsey/uuid-doctrine

Use ramsey/uuid as a Doctrine field type.

90340.3M211](/packages/ramsey-uuid-doctrine)[reliese/laravel

Reliese Components for Laravel Framework code generation.

1.7k3.4M16](/packages/reliese-laravel)

PHPackages © 2026

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