PHPackages                             ngekoding/sql-column-alias-extractor - 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. [Utility & Helpers](/categories/utility)
4. /
5. ngekoding/sql-column-alias-extractor

ActiveLibrary[Utility & Helpers](/categories/utility)

ngekoding/sql-column-alias-extractor
====================================

A helper to extract SQL column aliases from SELECT statements

v1.0.0(9mo ago)02MITPHPPHP >=5.6

Since Aug 19Pushed 9mo agoCompare

[ Source](https://github.com/ngekoding/sql-column-alias-extractor)[ Packagist](https://packagist.org/packages/ngekoding/sql-column-alias-extractor)[ RSS](/packages/ngekoding-sql-column-alias-extractor/feed)WikiDiscussions master Synced 1mo ago

READMEChangelog (1)Dependencies (2)Versions (2)Used By (0)

SQL Column Alias Extractor
==========================

[](#sql-column-alias-extractor)

A PHP helper to extract column aliases from SQL SELECT statements using [PHPSQLParser](https://github.com/greenlion/php-sql-parser).

Supports usage with **any PHP project**, with optional adapters for **CodeIgniter 3** and **CodeIgniter 4**.

Installation
------------

[](#installation)

```
composer require ngekoding/sql-column-alias-extractor
```

Usage
-----

[](#usage)

### Basic usage

[](#basic-usage)

```
use Ngekoding\SqlColumnAliasExtractor\SqlColumnAliasExtractor;

$sql = "SELECT u.id, u.name AS username FROM users u";

$aliases = SqlColumnAliasExtractor::extract($sql);

print_r($aliases);
// [
//   'id' => 'u.id',
//   'username' => 'u.name'
// ]
```

### Handling wildcards (`*`)

[](#handling-wildcards-)

Provide a resolver function that expands table.\* into actual field names:

```
use Ngekoding\SqlColumnAliasExtractor\SqlColumnAliasExtractor;

$wildcardResolver = function ($tableName) {
    // Example resolver for demo purposes.
    // In production, fetch column names dynamically from your database.
    if ($tableName === 'users') {
      return ['id', 'name', 'email'];
    }
    return [];
};

$sql = "SELECT u.*, c.name AS company_name FROM users u JOIN companies c ON c.user_id=u.id";

$aliases = SqlColumnAliasExtractor::extract($sql, $wildcardResolver);

print_r($aliases);
// [
//   'id' => 'u.id',
//   'name' => 'u.name',
//   'email' => 'u.email',
//   'company_name' => 'c.name'
// ]
```

### CodeIgniter Integration

[](#codeigniter-integration)

You can use the provided adapter for seamless CodeIgniter 3 and CodeIgniter 4 support by just passing the query builder instance:

```
use Ngekoding\SqlColumnAliasExtractor\Adapter\CodeIgniter3Adapter;
// use Ngekoding\SqlColumnAliasExtractor\Adapter\CodeIgniter4Adapter;

// IMPORTANT! We don't call the `get` function here.
$queryBuilder = $this->db
    ->select('u.id, u.name, u.email, c.name company_name')
    ->from('users u')
    ->join('companies c', 'c.user_id=u.id');

$aliases = CodeIgniter3Adapter::extract($queryBuilder);

print_r($aliases);
// [
//   'id' => 'u.id',
//   'name' => 'u.name',
//   'email' => 'u.email',
//   'company_name' => 'c.name'
// ]
```

License
-------

[](#license)

The MIT License (MIT). Please see [License File](LICENSE) for more information.

###  Health Score

25

—

LowBetter than 37% of packages

Maintenance58

Moderate activity, may be stable

Popularity2

Limited adoption so far

Community6

Small or concentrated contributor base

Maturity30

Early-stage or recently created project

 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

Unknown

Total

1

Last Release

273d ago

### Community

Maintainers

![](https://www.gravatar.com/avatar/badefbaef2fd421d3b05261b2eb984562dee50392d83632bdb6549aff655e25e?d=identicon)[ngekoding](/maintainers/ngekoding)

---

Top Contributors

[![ngekoding](https://avatars.githubusercontent.com/u/11625690?v=4)](https://github.com/ngekoding "ngekoding (2 commits)")

###  Code Quality

TestsPHPUnit

### Embed Badge

![Health badge](/badges/ngekoding-sql-column-alias-extractor/health.svg)

```
[![Health](https://phpackages.com/badges/ngekoding-sql-column-alias-extractor/health.svg)](https://phpackages.com/packages/ngekoding-sql-column-alias-extractor)
```

###  Alternatives

[hermawan/codeigniter4-datatables

Serverside Datatables library for CodeIgniter4

10943.0k3](/packages/hermawan-codeigniter4-datatables)[alexandre-daubois/lazy-stream

Write data to streams, only when it is really needed to.

755.7k](/packages/alexandre-daubois-lazy-stream)

PHPackages © 2026

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