[Neos] How to do an old, plain SQL-query

[Olle Haerstedt]

Hi!

So, the old extbase way of doing a raw SQL-query seems to have been removed
in TYPO3 Neos: no $query->statement. Instead I tried using the Doctrine
DQL, but it seems like every table mentioned in the query has to be a model? What
if I would like to join with a table that is not a model yet? Any solution?

My use-case in hand is a custom user model which should join with accounts to get all
users with a certain role.

Regards
Olle