I'm hugely disappointed (but not shocked) that SuiteQL mutates the alias given the SQL statement. firstname AS

strFirstName

.. the alias becomes

strfirstname

. Thanks NetSuite!

So true

And that fact is a footnote in their documentation. Honestly, it'd be nice to see them get it right for once

everything gets lowercaseified. Long names get truncated.

Exactly. Absolutely brutal. Why even support aliases then? So Janky

OMG. Someone else who uses “janky”. You just made my day.

I'm also Canadian ... BOOM!