How can I make query model relation has to many easy to read?

[positivedeveloper36]

My query has to many like this :

const query = Buyer.query()
.select('id', 'buyer_name', 'description')
query.preload('products', (query) => {
    query.select('id', 'product_name', 'buyer_id')
})
query.orderBy('buyer_name', 'desc')

If the query run, the result like this ::

{
    "data": [
        {
            "id": 1,
            "buyer_name": "John Terry",
            "description": "Voluptates ducimus ut ducimus perferendis placeat omnis qui voluptas omnis.",
            "products": [
                {
                    "id": 1,
                    "product_name": "product 1",
                    "buyer_id": 1
                },
                {
                    "id": 2,
                    "product_name": "product 2",
                    "buyer_id": 1
                }
            ]
        },
        {
            "id": 2,
            "buyer_name": "Frank Lampard",
            "description": "Eligendi itaque velit placeat nulla.",
            "products": [
                {
                    "id": 3,
                    "product_name": "product 3",
                    "buyer_id": 2
                },
                {
                    "id": 4,
                    "product_name": "product 4",
                    "buyer_id": 2
                }
            ]
        }
    ]
}

I want the result of the model relation query like this ::

{
    "data": [
        {
            "id": 1,
            "buyer_name": "John Terry",
            "product_name": "product 1",
            "description": "Voluptates ducimus ut ducimus perferendis placeat omnis qui voluptas omnis."
        },
        {
            "id": 2,
            "buyer_name": "John Terry",
            "product_name": "product 2",
            "description": "Voluptates ducimus ut ducimus perferendis placeat omnis qui voluptas omnis."
        },
        {
            "id": 3,
            "buyer_name": "Frank Lampard",
            "product_name": "product 3",
            "description": "Eligendi itaque velit placeat nulla."
        },
        {
            "id": 4,
            "buyer_name": "Frank Lampard",
            "product_name": "product 4",
            "description": "Eligendi itaque velit placeat nulla."
        }
    ]
}

So it's easy to use when this api/query is called

I had try query builder and it works. But I want to use the model because it's cleaner

How can I solve this problem?

Please help. Thanks

Additional information ::

If I use query builder like this ::

const query = await Database.query()
.select(
  'a.buyer_name',
  'a.description',
  'b.product_name',
  'b.id'
)
.from('buyers as a')
.innerJoin('products as b', 'a.id', 'b.buyer_id')
.orderBy('a.buyer_name', 'desc')

It works. The result is good

But if I use model like this ::

const query = await Buyer.query()
.select(
  'a.buyer_name',
  'a.description',
  'b.product_name',
  'b.id'
)
.from('buyers as a')
.innerJoin('products as b', 'a.id', 'b.buyer_id')
.orderBy('a.buyer_name', 'desc')

The select from table relation (table products) does not appear

[thetutlage]

What you want is a join and not preloaded relationships. Relationships are always in a tree structure and you need a flat list.

Just write a standard join using the Model and it should work. Please share result you get after writing the join

[positivedeveloper36]

@thetutlage Okay. See my question. I had update it. I have tried it but select from table relation doesn't exist