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)) })
