We have moved our forum to GitHub Discussions. For questions about Phalcon v3/v4/v5 you can visit here and for Phalcon v6 here.
  1. Home
  2. Database

is UNION clause supported on PHQL?

Like the title says, is UNION clause supported on PHQL? Or may I should use raw SQL? Thanks!



145.0k
Accepted
answer

No and yes, you can use raw sql.



13.8k
in reply to Wojciech Ślawski

Thanks for answering.

Which are the NON-supported clauses in PHQL?

No and yes, you can use raw sql.



13.8k
in reply to Wojciech Ślawski

Thanks for answering.

Which are the NON-supported clauses in PHQL?

No and yes, you can use raw sql.



145.0k

There is no obvious answer to this. Pretty much anything which is standard of SQL, not a certain engine like postgresql or mysql or mssql.