PHPackages                             canedoc/json-query-builder - 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. canedoc/json-query-builder

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

canedoc/json-query-builder
==========================

v1.0.0(3y ago)07MITPHPPHP >=7.3

Since Oct 25Pushed 3y ago1 watchersCompare

[ Source](https://github.com/canedoc/json-query-builder)[ Packagist](https://packagist.org/packages/canedoc/json-query-builder)[ Docs](https://github.com/canedoc/laravel_json_query)[ RSS](/packages/canedoc-json-query-builder/feed)WikiDiscussions main Synced 1mo ago

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

laravel json query builder
==========================

[](#laravel-json-query-builder)

**laravel json query builder** makes working with json column much easier, using json columns ley you combine NoSQL and relational structures in the same database. now you can use json columns as if they were structered columns for filtering, selecting and searching. We provide support for **Mysql, MariaDB, Sql Server**.

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

[](#installation)

The recommended way to install **json-query-builder** is through [Composer](http://getcomposer.org/)

```
$ composer require canedoc/json-query-builder
```

Usage
-----

[](#usage)

### selecting

[](#selecting)

```
\DB::table('table')->addSelect('column->path->to->element', 'as_name');
```

or

```
ModelName::addSelect('column->path->to->element', 'as_name');
```

### filtering by the data content

[](#filtering-by-the-data-content)

```
\DB::table('table')->whereJsonValue('column->path->to->element', '=', 22);
```

```
ModelName::whereJsonValue('column->path->to->element', '>', 22);
```

we can use operators : =, >, <, >=, <=, like.

### filtering valid/invalid json column content.

[](#filtering-validinvalid-json-column-content)

```
\DB::table('table')->whereJsonIsValid('column');
```

```
ModelName::whereJsonIsInvalid('column');
```

we can also use : orWhereJsonValue, orWhreJsonIsValid, orWhereJsonIsInvalid.

tests
-----

[](#tests)

to test the package run:

```
./vendor/bin/testbench package:test
```

Authors
-------

[](#authors)

- [Boubrit Nacim](https://github.com/canedoc)

License
-------

[](#license)

**json-query-builder** is licensed under the [MIT License](http://opensource.org/licenses/MIT).

###  Health Score

20

—

LowBetter than 14% of packages

Maintenance20

Infrequent updates — may be unmaintained

Popularity4

Limited adoption so far

Community7

Small or concentrated contributor base

Maturity41

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

Unknown

Total

1

Last Release

1301d ago

### Community

Maintainers

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

---

Top Contributors

[![canedoc](https://avatars.githubusercontent.com/u/32875605?v=4)](https://github.com/canedoc "canedoc (8 commits)")

### Embed Badge

![Health badge](/badges/canedoc-json-query-builder/health.svg)

```
[![Health](https://phpackages.com/badges/canedoc-json-query-builder/health.svg)](https://phpackages.com/packages/canedoc-json-query-builder)
```

###  Alternatives

[prologue/support

Prologue Support is an extension for Illuminate Support

1616.8k](/packages/prologue-support)

PHPackages © 2026

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