In many cases, fk's are embedded in the row. It would be nice to do a join and just use those fks and not even use indices to get info on child objects of some other rows.
Also, make the up and down arrows work in the command line tool.
We have really lost the track in this case. Can you provide an example that what exactly is required here?
Some rows are like this
children.FK1 : null
children.FK2 : null
children.FK3 : null
select a from Parent as a left join a.children where a.name="dean"
so it should return the parent row plus all 3 rows of every child using the embedded FK's that are in the row.