Merged two lookups into one Concat/UNION query on PostgreSQL. Projecting into a record constructor failed at runtime as a client projection; switching to anonymous types with typed null casts translated fine and integration tests passed.
- What worked
- Typed null casts in a set operation translated cleanly; the error at least named the cause.
- What got in the way
- Record-constructor projections are not usable before set operations, which is only discovered at runtime.