Download the PHP package monkeyscloud/monkeyslegion-query without Composer
On this page you can find all versions of the php package monkeyscloud/monkeyslegion-query. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.
Table of contents
Download monkeyscloud/monkeyslegion-query
More information about monkeyscloud/monkeyslegion-query
Files in monkeyscloud/monkeyslegion-query
Download monkeyscloud/monkeyslegion-query
More information about monkeyscloud/monkeyslegion-query
Files in monkeyscloud/monkeyslegion-query
Vendor monkeyscloud
Package monkeyslegion-query
Short Description Performance-first Query Builder & Micro-ORM for MonkeysLegion v2
License MIT
Package monkeyslegion-query
Short Description Performance-first Query Builder & Micro-ORM for MonkeysLegion v2
License MIT
Please rate this library. Is it a good library?
Informations about the package monkeyslegion-query
MonkeysLegion Query — v2
Performance-first Query Builder & Micro-ORM for the MonkeysLegion framework.
Architecture
Key Features
| Feature | Description |
|---|---|
| Performance-first | Structural SQL caching (xxh128), statement reuse, zero-copy bindings |
| 4 DB engines | MySQL, MariaDB, PostgreSQL, SQLite — full grammar implementations |
| Read/write routing | Automatic: SELECTs → read(), DML → write() via ConnectionManagerInterface |
| PHP 8.4 | Property hooks, asymmetric visibility, readonly classes, backed enums |
| Identity map | Same row always returns same object instance |
| Unit of Work | persist() / remove() / flush() — batched writes in one transaction |
| Cursor pagination | Constant-memory traversal of large datasets |
| CTE builder | Standard and recursive CTEs across all 4 engines |
| Vector search | pgvector, MySQL 9.x VEC_DISTANCE, with fallbacks |
| #[Scope] attribute | Global and per-query scopes on repository methods |
Installation
Quick Start
Query Builder
Joins
Where Clauses
Repository
Common Table Expressions
Vector Search
Performance
| Metric | v1 | v2 |
|---|---|---|
| Test suite (156 tests) | ~120ms | 41ms |
| Code size | 10,500 lines / 19 files | 3,600 lines / 24 files |
| Inheritance depth | 3 classes | 1 class |
| Schema queries at build | Per column | Zero |
| SQL compilation | Every execution | Cached (xxh128) |
| PDOStatement | New per query | Cached per connection |
Database Compatibility
| Feature | MySQL 8+ | MariaDB 10.2+ | PostgreSQL | SQLite 3.35+ |
|---|---|---|---|---|
| Query builder | ✅ | ✅ | ✅ | ✅ |
| Upsert | ON DUPLICATE KEY | ON DUPLICATE KEY | ON CONFLICT | ON CONFLICT |
| RETURNING | ❌ | ❌ | ✅ | ✅ |
| JSON path | ->> | ->> | ->> / #>> | json_extract |
| CTE | ✅ | ✅ | ✅ | ✅ |
| Recursive CTE | ✅ | ✅ | ✅ | ✅ |
| Vector search | VEC_DISTANCE* | ❌ | pgvector | ❌ |
| Identifier quoting | `backtick` | `backtick` | "double" | "double" |
Requirements
- PHP 8.4+
monkeyscloud/monkeyslegion-databasev2monkeyscloud/monkeyslegion-entityv1+- PDO extension
License
MIT © MonkeysCloud
All versions of monkeyslegion-query with dependencies
PHP Build Version
Package Version
Requires
php Version
^8.4
monkeyscloud/monkeyslegion-database Version ^2.0
monkeyscloud/monkeyslegion-entity Version ^2.0
psr/simple-cache Version ^3.0
psr/log Version ^3.0
ext-pdo Version *
monkeyscloud/monkeyslegion-database Version ^2.0
monkeyscloud/monkeyslegion-entity Version ^2.0
psr/simple-cache Version ^3.0
psr/log Version ^3.0
ext-pdo Version *
The package monkeyscloud/monkeyslegion-query contains the following files
Loading the files please wait ...