Querying with joins

[boardfish]

I'd like for something like this to work: Document.joins(:user).where(users: { admin: true }).

This is probably quite difficult to achieve, since it's converted back to an SQL query by Arel under the hood. It's also worth noting that Arel isn't a stable interface, so it'll probably have some maintenance overhead. Not surprised if this doesn't get addressed, but is there a recommended way to phrase queries like this?

[boardfish]

Settled on this:

Document.joins(:user).where(User.bitfield_sql(admin: true))

Makes sense for Bitfields to be responsible for its SQL output, so I'll stick with this. Hope it helps anyone that's trying to achieve the same thing.