Subquery

[tommasop]

SELECT and SELECT EXPAND queries can have a FROM subquery but it must be initialized before it can be built:

  query = Rorient::Query.select(ODB)
  query.subquery
  query.subquery.from(Event).where{ name('Rorient Conference') }

It would be nice to have a block defining the subquery:

  query = Rorient::Query.select(ODB).subquery{ from(Event).where{ name('Rorient Conference') } }.fields("name","surname").osql
  # => SELECT name,surname FROM (SELECT FROM Entity WHERE name = 'Rorient Conference') /-1