This is likely a result of your underlying Atlas DB version being less than version 5.0. The nature of the error is that in the translation the $unsetField aggregation is being called, but this aggregation isn’t present in versions less than 5.0. So you may have been able to query using Atlas SQL on this same database in the past, but this particular query requires the $unsetField aggregate within the translation.
Hope this helps!
