I cannot address the why behind not being able to query a *-* in a native profile.
Though your worry regarding performance and having multiple tables I can confirm that in most cases a *-* has less performance than a joining entity.
Take a look at this lecture, up to 4.5.1 https://learn.mendix.com/link/module/371/lecture/3010/4.1-Impact-of-Ownership-