What I would really like to see is a new tool in the toolbox for Norma. It would be like a ? or a Query icon. Basically what it would do is generate a query from the rmap of all the valuetypes, and if you select them. If you select an entity it will basically place those priamry keys into the query. I think that would be at least a first step approach. This might be done easiest if a check box poped up when you used the query on entities that appear closest to the mouse cursor? Or something like that.
The second step would be to select an entity or value type that was selected with the query and determine if it should be left outer join or right outer join union etc.. I don't know if CQL can do that by default?
The third step would then be the add to the where clause for inner queries, and then add where clause to outer queries.
Then maybe focus on aggregates, calcuations and derivation and cases as a last step.
After all thats done, then for any query you selected... it would then allow you to generate a "Process Map" i.e. a map that says you need to first fill out this table. You need to make sure these fields are filled out b/c it has a not null constraint, or uniqueness constraint, or specifc value constraint. After filling out this table, then you need to insert into these three tables.
Or maybe a delete process table from a query it would generate the process for deleting sections in a particular query and if anything else outside the query would be affected.
This is really getting complicated. I read section 16.3 and it just gave me a bad head ache but I did like the part about nai’ve users. We can avoid that part by hopefully relying on the Norma model.