ClanCats/Hydrahon

Using SQL UNION / UNION ALL operator

Opened this issue · 1 comments

Is there a possibility to create queries with the UNION or UNION ALL operator?

Something like this would be useful:

$h->table('students')
  ->select('column_name')
  ->union()
  ->table('teachers')
  ->select('column_name')
  ->get();

Resulting in:

SELECT column_name FROM students
UNION
SELECT column_name FROM teachers;

Good night,,

Why not merge fork https://github.com/lucasnodari/Hydrahon with unionall in oficial Hydrahon?