What result objects contain

The query builder API supports two types of queries:

  • Entity queries – Result objects contain a list of references to instances of the primary entity type for the query. You set up an entity query with the select method that takes no arguments. For example:
    query.select()
  • Row queries – Result objects contain a set of row-like structures with values fetched from or computed by the relational database. You set up a row query by passing a Gosu array of column selections to the select method. For example:
    query.select({
      QuerySelectColumns.path(Paths.make(Person#Subtype)),
      QuerySelectColumns.pathWithAlias("FName", Paths.make(Person#FirstName)),
      QuerySelectColumns.pathWithAlias("LName", Paths.make(Person#LastName))
    })