Duplicated column when using .withAggregate and .groupLimit in the same preload

[Liviaparaujo]

Package version

18.3.0

Node.js and npm version

16.16.0, 8.11.0

Sample Code (to reproduce the issue)

The query in question:

 const columnsQuery = await board
      .related('columns')
      .query()
      .orderBy('position', 'asc')
      .preload('cards', (query) => {
            query.withAggregate('cardChecklistContent', (subQuery) => {
            subQuery.count('card_checklist_contents.id')
            subQuery.as('allContent')
          })
          query.groupOrderBy('position', 'asc').groupLimit(30)
      })

It generates the SQL query:

SELECT *
FROM
  (SELECT `cards`.*,
          `board_column_id`,

     (SELECT count(`card_checklist_contents`.`id`)
      FROM `card_checklist_contents`
        AND (`cards`.`id` = `card_checklist_contents`.`card_id`)) AS `allContent`,
          row_number() OVER (PARTITION BY board_column_id
                             ORDER BY POSITION ASC) AS adonis_group_limit_counter
   FROM `cards`
     AND (`board_column_id` in (417,
                                157,
                                158,
                                159,
                                160))) AS `adonis_temp`
WHERE `adonis_group_limit_counter`  <= 30

and the error ER_DUP_FIELDNAME: Duplicate column name 'board_column_id'. The error occurs because board_column_id is a column from the Cards model. The query runs fine without the groupLimit and also if I chage the .withAggregate for a preload

[stale]

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions.