Using ATTACH. Works a treat. SQLite query planner knows about ATTACH.
Having several areas of concern managed by distinct databases, with some occasions which warrant joins across the domains, this is the more natural use pattern. ATTACH loses foreign key constraints and triggers, among other things.