nette/database

Union Selections

MartinPetricko opened this issue · 0 comments

Hey, recently I noticed that there is no option for union selections with nette database explorer. Only way to use unions that I found is to write raw queries which is not very convenient.

I would like to propose syntax that may look something like this:

$loremSelection = $explorer->table('lorem')->select('field')->where(...)->order(...)->limit(...);
$ipsumSelection = $explorer->table('ipsum')->select('another_field AS field')->where(...);

$result = $explorer->union($loremSelection, $ipsumSelection)->where(...)->order(...)->limit(...)->fetchAll();

Is there a possibility that this feature would be added to nettes database explorer?