Is it possible to use .first() on a preload ?

[corentinmusard]

.groupLimit(1) works but returns an array of one element

const data = await Vote.query()
  .preload('voters', (query) => {
    // query.groupLimit(1) // works but return an array
    query.first() // fails
  })

When using .first() i got this error :

err: {
      "type": "TypeError",
      "message": "Cannot read properties of undefined (reading 'method')",
      "stack":
          TypeError: Cannot read properties of undefined (reading 'method')
              at /my/path/node_modules/@adonisjs/lucid/build/src/Database/QueryBuilder/Chainable.js:126:62
              at Array.forEach (<anonymous>)
              at HasManyQueryBuilder.applyWhere (/my/path/node_modules/@adonisjs/lucid/build/src/Database/QueryBuilder/Chainable.js:124:25)
              at HasManyQueryBuilder.execQuery (/my/path/node_modules/@adonisjs/lucid/build/src/Orm/QueryBuilder/index.js:182:14)
              at HasManyQueryBuilder.exec (/my/path/node_modules/@adonisjs/lucid/build/src/Orm/QueryBuilder/index.js:652:35)
              at processTicksAndRejections (node:internal/process/task_queues:96:5)
              at Preloader.processRelationForMany (/my/path/node_modules/@adonisjs/lucid/build/src/Orm/Preloader/index.js:92:24)
              at async Promise.all (index 0)
              at Preloader.processAllForMany (/my/path/node_modules/@adonisjs/lucid/build/src/Orm/Preloader/index.js:149:9)
              at ModelQueryBuilder.execQuery (/my/path/node_modules/@adonisjs/lucid/build/src/Orm/QueryBuilder/index.js:211:9)
      "status": 500
    }

Is it a bug ?

[thetutlage]

The first method executes the query. Whereas, during preload you cannot self execute the relationship query.

Also, if you are using hasMany or manyToMany relationship, then you would expect your code to have consistent data structure vs having it as an object somewhere and then as an array somewhere else.

Therefore, it is not possible to convert the data type of a many relationship from array to something else