PHPackages                             ymvas/ymsql - 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. ymvas/ymsql

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

ymvas/ymsql
===========

SQL Helper

v2.1.5(2y ago)054PHP

Since Apr 13Pushed 2y agoCompare

[ Source](https://github.com/y-vas/ymsql)[ Packagist](https://packagist.org/packages/ymvas/ymsql)[ RSS](/packages/ymvas-ymsql/feed)WikiDiscussions main Synced 1mo ago

READMEChangelogDependencies (1)Versions (26)Used By (0)

YMSQL
=====

[](#ymsql)

// site

YMSQL is a query helper and abstraction layer for php.

### COMPOSER INSTALATION

[](#composer-instalation)

```
composer require ymvas/ymsql
```

### Basic Script

[](#basic-script)

```
use YMSQL\YMSQL;

// declare the database variables in ENV
$_ENV[  'DB_HOST'  ] = 'host';
$_ENV['DB_USERNAME'] = 'name';
$_ENV['DB_PASSWORD'] = 'pass';
$_ENV['DB_DATABASE'] = 'dtbs';

$v = new YMSQL( );
$query = $v->query(
   " SELECT * FROM Table T
     WHERE TRUE
    { AND T.name = :name } "
  ,[ 'name' => 'ymsql' ]
  , true
);

// what query will return
/*
  $query
  "
  SELECT * FROM Table T
  WHERE TRUE
  AND T.name = 'ymsql'
  "
*/

$res = $v->get( $list = true );
//returns a standart class object

// if you want to return the mysqli instance run this instead
// $mysqli = $v->run( $list = true );
```

#### Handeling Big queries is now easy

[](#handeling-big-queries-is-now-easy)

Given this values and this query

```
$values = [
  'name'     => 'ymsql',
  'getbasic' => true,
  'pass'     => 'secret'
]
```

Givent Query

```
SELECT
  :name
  { , d.name :extra_cols }
  { , d.name ,d.surname, d.pass  getbasic; }
  , d.id
FROM dbtable d
WHERE TRUE
AND d.surname like '%{:surname}%'
{ AND d.type = i:type }
{ AND d.pass = s:pswd }
{ AND d.id   = i:id   }
```

Output Query

```
SELECT
  ymsql
  , d.name ,d.surname, d.pass
  , d.id
FROM dbtable d
WHERE TRUE
AND d.surname like '%%'
AND d.pass = 'secret'
```

### Transformers

[](#transformers)

transformer variables returns i'string',0 ,'123.3', null0,0 ,123, 0+i'string',0 ,'-123.3', -20,0 ,123, 2f'string',0 ,'123.3', null0,0 ,123.3, 0+f-3, -1.3 ,0 ,'123.3' , null3, 1.3 ,0 ,123.3, 0s'string',0 ,'123.3', null'string','0','123.3',''t' string ',0 ,'123.3', null'string','0','123.3',''a\['string',0 ,'123.3', null\]'string,0,123.3,'j\['string',0 ,'123.3', null\]'\["string",0,"123.3",null\]'### Classes

[](#classes)

- VSQL
    - Query Compiler `php $db->query('select * from dbtable',array()); `
    - Fetch Rows `php $db->get( $list = false ); `
    - Execute `php $db->run(  $list = false ); /* retuns mysql instance */`

###  Health Score

26

—

LowBetter than 43% of packages

Maintenance20

Infrequent updates — may be unmaintained

Popularity8

Limited adoption so far

Community6

Small or concentrated contributor base

Maturity58

Maturing project, gaining track record

 Bus Factor1

Top contributor holds 100% 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 ~18 days

Recently: every ~26 days

Total

23

Last Release

1088d ago

Major Versions

v1.0.3 → v2.0.02022-06-03

### Community

Maintainers

![](https://www.gravatar.com/avatar/7dff39c53be3bd59d0ac20080a77931a2a0593466cb43822557f7e918fb2476c?d=identicon)[ymvas](/maintainers/ymvas)

---

Top Contributors

[![y-vas](https://avatars.githubusercontent.com/u/25935526?v=4)](https://github.com/y-vas "y-vas (36 commits)")

###  Code Quality

TestsPHPUnit

### Embed Badge

![Health badge](/badges/ymvas-ymsql/health.svg)

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

###  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)