Doctrine DTO with native SQL queries
<p>I currently have a fairly complex native SQL query which is used for reporting purposes. Given the amount of data it processes this is the only efficient way to handle it is with native SQL.</p>

<p>This works fine and returns an array of arrays from the scalar results.</p>

<p>What I'd like to do, to keep the results consistent with every other result set in the project is use a Data Transfer Object (DTO). Returning an array of simple DTO objects. </p>

<p>These work really well with DQL but I can't see anyway of using them with native SQL. Is this at all possible?</p>