really sucks that SuiteQL cuts off the names of long columns. So if you have

SELECT custbody_really_ultra_long_field_id

you actually get something like

custbody_really_ultra_lon#

instead. So when you try to do

results[i].custbody_really_ultra_long_field_id

you get

undefined

Good to know ... but that is a wonky pattern. 🤔

Can it do custbody_really_ultra_long_field_id as myField so that you can reference results[i].myField instead?

yes

Annoyingly SuiteQL will change the field name in results to lower case