Distinct with chunk() breaks

[Daemach]

The following code yields an error: Incorrect syntax near '*'

qb.from('mars_in_tamarac t')
        .join('veritiadmin.dbo.accounts a', 't.account_id', 'a.portfolioCode')
        .selectRaw('a.id as accountID,account_id,openDate,closeDate,description,costBasis,quantity,proceeds,realizedGainLoss,stgl,ltgl')
        .where('closeDate', '<', account.dFirstAPXTrade)
        .distinct()
        .orderby('closeDate')
        .chunk(190, (chunk)=>{
          systemOutput('syncing #account.portfolioCode# tamarac')
          qb.from('veritiadmin.dbo.accounts_gainLoss').insert(chunk)
        } )

SQL:

SELECT COUNT(DISTINCT *) AS "aggregate" FROM [mars_in_tamarac] AS [t]  INNER JOIN [veritiadmin].[dbo].[accounts] AS [a] ON [t].[account_id] =  [a].[portfolioCode] WHERE [closeDate] < {ts '2020-12-14 00:00:00'}

[Daemach]

And fwiw, it would be really cool to be able to say .chunk('auto', ()=>{}) and have the function divide 2100 (for SQLS) by the number of fields in the select statement and use the floor() to figure out the chunk size. SQL server only allows 2100 parameterized fields in a single insert.