JOIN support about workers-qb HOT 6 CLOSED

Hey @aperture147
I've just added support for join clauses in the latest v0.1.3 version
You can read the docs here

Let me know if you have any more suggestion

from workers-qb.

Hey @aperture147 I've just added support for multiple joins, checkout the docs here
https://workers-qb.massadas.com/advanced-queries/join/#multiple-joins

from workers-qb.

Hey @aperture147 I will be looking into adding support for this next week
Thanks for suggesting this 😄

from workers-qb.

fields: ['role', 'department', 'payroll.salary'], returning the data in the same level of the object. Would it possible to have the salary key in the payroll object?

from workers-qb.

Thanks for your support! Is there any way to perform joining on multiple table? We can change

  _join(values?: Array<Join>): string {
    if (!values || !values.length) return ''
    let joinQuery = ''
    values.forEach((item: Join) => {
        const type = value.type ? ` ${value.type}` : ''
        joinQuery += `${type} JOIN ${value.table} ON ${value.on}`
    })

    return joinQuery
  }

This is a rough implementation to show the idea, sorry if it does not work.

from workers-qb.

Hey @subhendukundu that kind of result transformation should be handled in your application, workers-qb is only meant to generate sql queries

from workers-qb.