mrakolice

Add support for inner Selects in SQL generation for joined entities

6

Example of generated SQL: ``` SELECT table1_alias.* FROM ( SELECT id, field1, field2 from table1 WHERE field1=%val1 LIMIT 10 OFFSET 20 ) as table1_alias LEFT JOIN ( SELECT field3, field4,...

Feature Request: Add subquery support

8

Example of usage: ``` $repository->select()->subquery([ 'alias' => function(QueryBuilder $qb){ $qb->from($tableName)->columns('field1', 'field2'); } ]); $repository->select()->subquery(function(QueryBuilder $qb){ $qb->from($tableName)->columns('field1', 'field2'); }); $repository->select()->subquery(function(QueryBuilder $qb) use($anotherSelect){ $qb->addSelect($anotherSelect); }); $repository->select()->with([ 'load' => function($qb){ $qb->subquery(); } ]);...

Cannot load related entities through many to many relations via LEFT_JOIN

2

`$select->load('many_to_many.has_many')` failed with `Undefined node 'has_many'` exception. `$select->load('[email protected]_many')` failed with `Undefined relation 'pivotTestModel'.'has_many'` exception. This problem in AbstractLoader#251 in `$node->getNode($relation)` function. In debug `$node` has this structure:  Here my...

Update relations via set of ids or something like that

3

I need to update HasMany and ManyToMany relations via set of ids, instead of loading entities that exists in database. For example: Child table Id | Parent id | field...