How to use nested joins with relational query builder

I have a query like this:

const templates = await db.query.productSetTemplates.findMany({
      limit: 12,
      offset: /* not important */,
      orderBy: /* not important */,
      where: /* not important */,
      with: {
        productSet: {
          with: {
            products: {
              limit: 1
            }
          }
        },
        prototypeProductSets: {
          with: {
            products: {
              columns: {
                id: true
              }
            }
          }
        }
      }
    })

const templates = await db.query.productSetTemplates.findMany({
      limit: 12,
      offset: /* not important */,
      orderBy: /* not important */,
      where: /* not important */,
      with: {
        productSet: {
          with: {
            products: {
              limit: 1
            }
          }
        },
        prototypeProductSets: {
          with: {
            products: {
              columns: {
                id: true
              }
            }
          }
        }
      }
    })

I want to transform it to use relational query builder. I'm having problem with nested joins. How do I do this.

I want to use rqb because, I have to make another query somewhere else and i think I shouldn't need to make that extra query if I use rqb.

Drizzle Team•2y ago

Vision2023

How to use nested joins with relational query builder

I have a query like this:

const templates = await db.query.productSetTemplates.findMany({
      limit: 12,
      offset: /* not important */,
      orderBy: /* not important */,
      where: /* not important */,
      with: {
        productSet: {
          with: {
            products: {
              limit: 1
            }
          }
        },
        prototypeProductSets: {
          with: {
            products: {
              columns: {
                id: true
              }
            }
          }
        }
      }
    })

const templates = await db.query.productSetTemplates.findMany({
      limit: 12,
      offset: /* not important */,
      orderBy: /* not important */,
      where: /* not important */,
      with: {
        productSet: {
          with: {
            products: {
              limit: 1
            }
          }
        },
        prototypeProductSets: {
          with: {
            products: {
              columns: {
                id: true
              }
            }
          }
        }
      }
    })

How to use nested joins with relational query builder

Similar Threads

How to use nested joins with relational query builder

Similar Threads

Similar Threads

Similar Threads