Dan Bluestein

Thanks, yes, you're right. When generalizing the code to this example I oversimplified and I didn't catch that the subquery in the generated SQL was selecting from `thing_types, things`. The...

Thanks for taking a look into it. Fortunately for me, it looks like we're only referencing this relationship a few times, and I can make my stuff work by replacing...

Yes, this SQL looks like what I want. The way our application is putting together these queries, it might be more effort to use an alias, like your "t1" example,...