Remove SQL parsing from report generator
There is some builtin SQL parsing in the report subsystem. The purpose of this is to manipulate a report's configure SQL query before it is sent to PostgreSQL server, mainly adding parameters to the WHERE clause. The SQL parsing is complex and not very flexible (i.e. the parser is incomplete, resulting in a lack of many SQL features).
The query configured in a report can be issued unaltered as a subquery, while the outer query adds the needed where clause. PostgreSQL will usually optimize this very well:
SELECT * FROM (SELECT [long_report_
Blueprint information
- Status:
- Complete
- Approver:
- Morten Brekkevold
- Priority:
- Medium
- Drafter:
- Jørgen Abrahamsen
- Direction:
- Approved
- Assignee:
- Jørgen Abrahamsen
- Definition:
- Approved
- Series goal:
- Accepted for 3.6
- Implementation:
-
Implemented
- Milestone target:
-
3.6.0b1
- Started by
- Jørgen Abrahamsen
- Completed by
- Morten Brekkevold
Related branches
Related bugs
Sprints
Whiteboard
The blueprint has been implemented and merged with the default branch. Reports have been updated to not reference table aliases from join reports, since these are no longer present. Any obvious links to the report system from other subsystems have also been fixed to reference the reports properly.
