JOIN support

[aperture147]

Is there anyway to perform JOIN query? If there is, how can I do it?

[G4brym]

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

[G4brym]

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

[subhendukundu]

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?

[aperture147]

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

workers-qb/src/Builder.ts

Line 139 in 37919e0

_join(value?: Join): string {

from accepting a single Join object to an array of Join? Eg:

  _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.

[G4brym]

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

[G4brym]

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