Select in other select

[OldMen]

Please tell me how to execute the following query:

select * 
from (
    select *
    from table 
    group by name having max(age)) 
where name = 'Bob';

[fnc12]

hi. Select inside FROM isn't implemented right now. We are thinking about API. If you have any idea you're welcome

[OldMen]

storage.select( asterisk(), from( select( ... ) ) );
?

[fnc12]

@OldMen ok how to specify where name = 'Bob' where name is a column defined inside sub-select?

[OldMen]

storage.select( asterisk(), from( select( ... ) ), where( ... ) );

[fnc12]

please expand ...

[OldMen]

storage.select( 
  asterisk<Table>(),
  from( select( asterisk<Table>(), group_by( &Table::name ).having( max( &Table::age ) ) ) ),
  where( is_equal( &Table::name, "Bob ) )
);

[fnc12]

ok it looks nice thanks. What if we need to use aliases inside sub-select and reference to it in the outer WHERE?

[OldMen]

Я не часто использую алиасы, поэтому не могу сразу рассмотреть проблему. :)

[fnc12]

I can add a support for query provided by you no problem but what to do with queries like this

SELECT departments.department_name, subquery1.latest_hire
FROM departments,
 (SELECT department_id, MAX(hire_date) AS latest_hire
  FROM employees
  GROUP BY department_id) subquery1
WHERE subquery1.department_id = departments.department_id;

?

[OldMen]

А если попробовать такой интерфейс?

auto subquery1 = storage.subquery( select( asterisk<Table>(), group_by( &Table::name ).having( max( &Table::age ) ) ) );
auto result = storage.select( subquery1.field, from( subquery1 ) );

[fnc12]

@OldMen how to specify WHERE subquery1.department_id = departments.department_id; in your case?

[fnc12]

@OldMen I like Russian language, I speak it mostly and it is my mother language but please write public issues in English cause open source has to be written in English. If you want to speak Russian let's use email [email protected] instead. Thanks

[fnc12]

@OldMen are you there?