Making sure everyone's seen this issue: PSA: BUILTIN.DF will drop rows unexpectedly from SuiteQL queries : r/Netsuite

In NetSuite’s flavor of SQL, BUILTIN.DF fails to evaluate NULL values and NetSuite drops the row from the results entirely.

Apparently NetSuite evaluates all BUILTIN.DF function calls eagerly, before any CASE logic

so you can't protect against this by wrapping in a NULL check, like

CASE WHEN {field} IS NOT NULL THEN BUILTIN.DF({field}) END

Slack Conversation