Bulletin

with_component filters entities by what they're made of, and scopes to the entity type for free.

A user *is* a moderator exactly when the row exists. Presence is the whole meaning.

A component has no stored row until a value differs from its default. Reading may query; preloading keeps lists efficient.

Entities are identity; components carry the state and behaviour. It reads like plain Rails.