Union Selections
MartinPetricko opened this issue · 0 comments
MartinPetricko commented
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?