We’ve got a pattern that has worked in the past for insert statements, but I’m attempting to reuse it for a select statement and seeing what I’d consider to be unexpected behavior. Assume everything that isn’t delineated here is correctly defined; I’m trying to keep this brief, not cover the nitty-gritty details.