SQL
- All SQL should be written to return the minimum number of records back to BIRT.
- If possible, all calculations and aggregations should be performed at the database level.
- SQL should be portable, i.e. it should be able to run against both Oracle and DB2.
- Do not user vendor specific functions.