Active Records Performance vs Raw Queries

If someone's work contains more than 5% raw SQL I will not accept it (and pay). The query builder adds value to security, this is important. This is my period on the subject.

I'm worked on some projects that required some pretty intricate SQL to be written. To try and do all of that was a pain in query builder. However, skipping the Query Builder and using the parameter binding property of $this->db->query() still handles auto-escaping the data for you. I would argue that might be something you should consider when drawing that line in the sand about Query Builder. And, yes, I do use QB a lot, also, just not for the overly complex queries with sub-queries, etc.

Support Development •  CodeIgniter 4 Foundations • Practical CodeIgniter 3  • CodeIgniter Tutorials