(02-02-2016, 05:16 AM)Narf Wrote: Should your application be able to run on different databases? Or do you imagine having to migrate your application to another database, any time in the future?
If yes - a query builder will be of great help.
If no - raw SQL is always better, period.
Any other arguments are just people thinking it's "nice".
For now, the answer is no. but may be yes for the future, I'm not sure now.
over all, I developed my app (about 80% of it is completed). Should I come back to first and rewrite all written queries with query builder, and using raw sql? how much the performance is different between these two approach? if I user query builders, is there situation that I encounter to lack of memory or so slow execution?
All of developers here and out of here say opinions that I couldn't be sure to choose a way. If there is a logical answer to these question, why answers are different?!