I was wondering if subqueries were supported for the FROM clause in Phalcon 2.0.5. I saw that they are supported in at least the WHERE clause.
I'm trying to do something similar to :
SELECT columnA, columnB, columnC`
FROM (SELECT Column A, ColumnB, TableB.ColumnC`
FROM TableA
JOIN TableB ON TableA.TableBId = TableB.id) AS temp
WHERE ColumnB != 1;
Is that supported, or will I have to figure something else out ?