[NFR] Query builder for raw sql

[hugoduraes]

It would be nice to have a query builder for raw sql queries, similar to Zend_Db_Select:
http://framework.zend.com/manual/1.12/en/zend.db.select.html

This would be useful when you need to build select queries which rely on specific SQL extensions that aren’t supported by PHQL.

The syntax should be similar to the creation of queries using the Query Builder:
http://docs.phalconphp.com/en/latest/reference/phql.html#creating-queries-using-the-query-builder

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

[bungcip]

Yep. I also want this feature. Using plain string to build raw sql in phalcon is annoying and error prone.

[philippgerard]

+1

[mzf]

+1

[pusoiuandrei]

+1

[seb777]

+1

[mohammed-alsiddeeq]

+10

[londomloto]

+1000

[kbtz]

👍 However with sub selects coming to PHQL in 2.0.0 we would need raw SQL even less.

[ut4]

+1

[konsultaner]

+1

[Samhayn]

Actually standard query builder ALMOST allows to build raw sql, it just wraps table's name with square brackets.

example:
$this->modelsManager->createBuilder()->from('table')->where('a = "a"')->limit(1)->getPhql()

result:

SELECT [table].* FROM [table] WHERE a = "a" LIMIT 1

[mohammadhzp]

+1

[salarmehr]

+100

[tmihalik]

+1

[Surt]

+1

Edited: Actually I voted because I thought it was a new raw_query for the query builder. I know it is error prone but actually it's the unique way to do some complex queries.

It would be great to have a queryBuilder->rawQuery (actually I need it or I'm stuck on complex raw transformations etc on the ORM)

[sergeyklay]

+1

[marianacapelo]

+1

[nejtr0n]

+1

[aleksandrzen]

+1

[mansoorriaaz]

+1

[andrew-demb]

+1

[gunelism]

1+

[dacgray]

1+

[niden]

Closing in favor of #13855. Will revisit if the community votes for it, or in later versions.

[niden]

@hugoduraes and others,

How do you envision this to work i.e. what would the result be? Is it going to be an array just like fetchAll returns when running a pure PDO based query or will this return a Complex/Simple resultset object

Since this issue has the most votes I was thinking of taking a stab at it and tying it with the new ORM that we are building but also offering functionality for the current ORM.

[niden]

Implemented in #14734