There are scenarios where query layers silently exclude rows from the underlying SQL query:
- IDs aren't unique or have nulls
- Features with null shapes
- Other?
If Pro is going to automatically exclude rows, it should at least tell us about it. Could a message at the bottom of the attribute table tell us how many rows were excluded? Or if not a count, then warning that some rows were excluded?
The message could be similar to the message that's displayed when a join is one-to-many and so there are duplicate rows in the attribute table.