Add alias for Join and Query main array.

[mahdiaslami]

Problem

• What should we do to prevent overwriting properties?
• How should we compare two columns with the same name?

1. Force using an alias in join.

query(childs)
    .join(parents, 'p')
        .on('parent_id').col.equal('p.id')
    .get()

And result is like:

const r = {
    id: 1,
    name: 'foo',
    /* [[OTHER CHILD PROPS]] */

    p: {
        id: 2,
        name: 'bar',
        /* [[OTHER PARENT PROPS]] */
    }
}

2. Force using an alias for join and query when using join.

query(childs, 'c')
    .join(parents, 'p')
        .on('c.parent_id').col.equal('p.id')
    .get()

And result is like:

const r = {
    c: {
        id: 1,
        name: 'foo',
        /* [[OTHER CHILD PROPS]] */
    },
    
    p: {
        id: 2,
        name: 'bar',
        /* [[OTHER PARENT PROPS]] */
    }
}

3. Implement both ways 1 and 2, And make them optional.

• If a developer does not provide both aliases, overwrite columns with the same name.
• When the column name in the on() method is the same as the column name in the on().col.<condition>() method then the first column always belongs to the main array. and the second column always belongs to the joined array.

Reference: #32 (comment)