This is an awesome tool, and reduces complexity for the easiest of the CRUD applications. however, for anything that needs even slightly more complicated scena

This is an awesome tool, and reduces complexity for the easiest of the CRUD applications. however, for anything that needs even slightly more complicated scenarios such as decisioning etc -- the SQL gets really complicated to build and test. I am suggesting that this could be extended with a possible rules engine like drools, which is bundled in, and uses an object model that is the same as the table structure. Data is fetched from the db, this data is reasoned on in the rules engine (and filtered) and this data is then either updated to the db ( sent to back tier ) or displayed on the screen ( sent to front tier ). Hence a complicated SQL query can be broken into a bunch of rules that are reused across scenarios.