|
Implement the proof of concept to dynamically join queries.
- Use complex queries built dynamically based on the query and entity type definitions
- Predefining relationships so we can join data and tables in a way that makes sense
- Once those relationships are defined, we can use dynamic queries to get the views – or to retrieve the data that we’d need
Why? Our derived tables are hard-coded and difficult to maintain (especially long-term). Performance becomes a concern because these views contain a huge collection of fields/tables (even when all of the fields/tables aren't all used for a given list).
This proposed PoC is primarily backend, and contains minimal user facing changes.
|