[NFR] Subqueries in PHQL

[hugoduraes]

Subqueries aren't still supported in PHQL. It would be nice to be able to do it instead of using raw sql.

Want to back this issue? Post a bounty on it! We accept bounties via Bountysource.

[arturgspb]

+1 vote

[igorgolovanov]

+1 vote.

[posthy]

+1

[iforp]

+1
but it's not the most urgent issue

[touhonoob]

+1

[jeffreycahyono]

+1

[hesalx]

👍

[doit76]

+1

[isimonov]

+1 vote

[jentix]

+1

[Slyvampy]

+1

[chebureque]

+1

[ivanblue]

+1

[ovr]

+1

[gianks]

+1

[relishable]

+1

[Bal1]

+1

[serafimovich]

+1

[kuzmichus]

+1

[Slyvampy]

Is there any update on this?

[gianks]

Any news?
Phalcon Rocks!

[algebreico]

+1

[alu]

+1

[cornfeedhobo]

+1

[cdekok]

👍

[Jeckerson]

+1

[lantian]

+1

[xblabs]

+1

[hugoduraes]

This is becoming popular. @phalcon is this going to be available on Phalcon 1.3.0?

[jimjam88]

+1

[cq-z]

+1

[derekjkeller]

+1

[slechtic]

+1

[boedy]

+1

[Michal-St]

• 1

[kse300489]

+1

[jesusfreak3]

+1

[fireburnheart2005]

I hope this issues will be fixed ,+1

[mzf]

+1

[wedancedalot]

+1

[nazwa]

+1

[andrefigueira]

+1

[evandropoa]

+1

[angay9]

+1

[evandropoa]

+1

[loopsframework]

+1 can't use subqueries with Phalcon\Paginator\Adapter\QueryBuilder

[Wexsel]

+1

[tmihalik]

+1

[sukobuto]

+1

[andrewi-wd]

+1

[sergeyklay]

+1

[marcosluizss]

+1

[sergeyklay]

@andresgutierrez It seems solved :)

[andresgutierrez]

Implemented in 2.0.2

[kse300489]

Ty

[someson]

Subqueries in JOINs too?

[Jurigag]

How to solve it in Active Record exactly? I think it's hard or close to not possible to implement this in Active Record pattern, if we will switch to Data Mapper we could think about it.

Keep in mind that most of queries in PHQL if you works on full models are translated to ORM to keep events working. like for example update/insert/select.*