IHP - sorting on field in joined tables?

Question

Is it possible to sort on a field in a joined table? For instance, if I want something like:

(modules, pagination) <- query @Module
    |> innerJoin @User (#userId, #id)
    |> orderByJoinedTable #email
    |> paginate

Is this currently possible?

Answer 1

This is currently not possible. You would need to use a handwritten sql query for this using sqlQuery