A PHP ORM powered by QUEL's tuple calculus approach. No manual joins. No method chaining. No query builder verbosity. Just declare what data ranges you need and how they relate.
// Define your data ranges
range of p is Product
range of c is Category via p.categories
// Retrieve what you need
retrieve (p, category_name=c.name)
where p.price < 100
and c.active = trueCompare how different ORMs express the same query
$qb = $em->createQueryBuilder();
$qb->select('p', 'c.name as category_name')
->from(Product::class, 'p')
->leftJoin('p.categories', 'c')
->where('p.price < :maxPrice')
->andWhere('c.active = :active')
->setParameter('maxPrice', 100)
->setParameter('active', true);
$results = $qb->getQuery()->getResult();You specify the join strategy, manually chain conditions, manage the execution order.
$results = $em->executeQuery("
range of p is Product
range of c is Category via p.categories
retrieve (p, category_name=c.name)
where p.price < :maxPrice
and c.active = true
", [
'maxPrice' => 100
]);
You declare data ranges and constraints. ObjectQuel determines optimal joins and execution order.
Relationships are paths: via p.categories expresses traversal, not LEFT JOIN mechanics.
ObjectQuel analyzes your ranges and generates optimized SQL - you never write JOIN clauses.
Based on tuple relational calculus - QUEL's approach that Codd considered truer to relational algebra.
Simple methods for everyday queries and the query language for complex scenarios
// Find by primary key
$user = $em->find(User::class, $id);
// Find by criteria
$posts = $em->findBy(
Post::class,
[
'published' => true,
'authorId' => 5
]
);Perfect for straightforward queries with simple criteria
// Complex relationships and filtering
$results = $em->executeQuery("
range of p is Product
range of c is Category via p.categories
retrieve (p, category_name=c.name)
where p.price < :maxPrice
and c.active = true
and p.name = \"widget*\"
sort by p.name asc
", ['maxPrice' => 100.00]);Powerful for complex relationships and advanced filtering
Where QUEL's declarative approach delivers the most value
Traverse multiple relationship levels without manual join configuration.
Adopt gradually alongside existing database code - no big-bang rewrite required.
Combine SQL databases and JSON APIs in unified queries.
All queries use parameterized statements automatically - zero SQL injection risk.
Query decomposer analyzes and optimizes execution paths automatically.
Native integration with Canvas PHP - zero configuration needed when using both together.
From query to hydrated entities
ObjectQuel handles optimization automatically, so you focus on describing what you need, not how to fetch it.
ObjectQuel handles SQL and JSON sources, then hydrates results into objects
Install ObjectQuel via Composer and start querying with objects immediately
# Install via Composer
composer require quellabs/objectquel$config = new Configuration();
$config->setDsn('mysql://user:pass@localhost/db');
$config->setEntityPath(__DIR__ . '/Entities/');
$entityManager = new EntityManager($config);
// Query immediately
$users = $entityManager->find(User::class, 10);
Open source and MIT licensed
Join developers who've already simplified their database code with ObjectQuel