This task simplifies the generated query to use a single, consolidated SQL table. By default, the generated SQL includes translations from the table, but it is now possible to pass a parameter that will always simplify the SQL.
Checklist
[x] I have reviewed the code changes.
[x] I have tested the changes locally.
[ ] I have updated the documentation if needed.
[ ] I have added/modified tests to ensure the changes are valid.
Testing and Evidence
The GraphQL query to be used: Pass includeTableTranslation as false to simplify the generated SQL query.
This PDF represents the two versions of the query generated from the same table.
Query_diff.pdf
Purpose
Improve the SQL queries generated in the backend.
Description
This task simplifies the generated query to use a single, consolidated SQL table. By default, the generated SQL includes translations from the table, but it is now possible to pass a parameter that will always simplify the SQL.
Checklist
Testing and Evidence
The GraphQL query to be used: Pass includeTableTranslation as false to simplify the generated SQL query.
This PDF represents the two versions of the query generated from the same table. Query_diff.pdf
Next Steps
Implement this in the frontend.