Update single field for list of _ids in Wix collection

I wanted to avoid loading complete records from a collection (in some cases with many fields and extensive data) for a list of _ids in order to update a single field using Wix data query.

I'd hoped Wix SQL would make this easy, but the "in" operator does not appear to be supported--so I'm doubting that would be an efficient way to update a list of records (i.e. , without "in" operator, perhaps looping over the _id list and perform SQL update one-by-one.)

With Wixdata.query, I would retrieve all the records needing to be updated (using "hasSome" operator with the _id list), then in a loop update the single field in each of those records, and then use bulk update of those records to the collection.

This latter is what I was seeking to avoid, but is it the best option? Would it be more efficient to use a loop with Wix SQL? In my current case, I just need to assign the same value in a single field for every _id in the list, so perhaps use a single-field "temp" collection to store the list of _ids and then perform the update using a join on the _ids between the collection and the "temp" collection?

I'm not clear how much overhead there is in querying and manipulating entire records (with many fields) with Wix query vs. alternatives using only a list of _ids with Wix SQL. If Wix SQL is just an overlay interface on the Wix data API, perhaps no efficiency gain in using Wix SQL in my case?

Thanks.