feat: where clauses recognize nested properties

[pauldelucia]

Issue being fixed or feature implemented

When building queries with WHERE clauses, we weren't checking for nested properties

What was done?

Check for nested properties and handle them

How Has This Been Tested?

Platform TUI

Breaking Changes

Checklist:

• [x] I have performed a self-review of my own code
• [x] I have commented my code, particularly in hard-to-understand areas
• [x] I have added or updated relevant unit/integration/functional/e2e tests
• [x] I have added "!" to the title and described breaking changes in the corresponding section if my code contains any
• [x] I have made corresponding changes to the documentation if needed

For repository code-owners and collaborators only

• [ ] I have assigned this pull request to a milestone