Views and aliasing in jOOQ

[Henning Blohm]

Hi,

I am trying to achieve the construction of a (logical) view using jOOQ. As 
a simple case, assume there is a table students with name and age and I 
want to turn this into

minors = select s.name as minor_name from students s where s.age<21;

Some other piece of code can then filter those further as in 

select m.minor_name from minors where m.minor_name='smith';

In Java terms, "minors" would be a typed "queryable" with a custom POJO 
type (with field "minorName"). 

Real world examples would be more complex of course

I spent some time looking for a suitable construct in jOOQ but was not 
succesful. 

Any helpful directions would be great!

Thanks,
  Henning