Custom SQL Support
FireStorm 2.0 is progressing well in the labs and now supports DAO code generation from custom SQL statements. This means that you can use ANY possible SQL statement that your database supports and no longer be limited to one-to-one mappings between Tables and Java objects.
For example you can now generate DAO code for statements like:
SELECT D.PRODUCT_CODE, COUNT(*)
FROM DOWNLOAD D, CUSTOMER C
WHERE D.EMAIL = C.EMAIL
AND C.REGION = :region
GROUP BY D.PRODUCT_CODE
The FireStorm roadmap is available at: