We are moving our forum in GitHub Discussions. For questions about Phalcon v3/v4 you can visit here and for Phalcon v5 here.

Query Builder without Model references

Is possible to get a RAW sql from query builder. It always returns a SQL like "select id from [Api\Models]". I want to set a table name in this place. Other problem is that all ":var:" used inside the SQL code isn't processed and parsed.

Phalcon is a limit blocked framework. It must to be more flexible when it concerns Models and database.

In first - why you need raw sql query ? You gonna edit it then ? if yes you shouldnt, you should build new. You can use just raw query. PHQL which query builder is using is high-level abastraction language created especially for handling models, not tables itself.