I have yet to see a Stenocereus queretaroensis cactus produce fruit in the U.S.
Maybe there are people out there who have fruit producing S. queretaroensis but just don't know what species they have. I'm thinking about mexican immigrants that may have planted some seeds from some pitayos, or who brought some cuttings from Mexico. They probably don't care about the scientific name all that much. They care more about the yummy fruit. So, somewhere in California, Arizona, or Texas there's probably a fruiting specimen.