Move logic of `merge` into the query compiler

### Describe the problem


Since query compilers may perform `merge` operation differently, it is necessary move out all related logic from API layer into the query compiler.