I really like the DB Class in FuelPhp. I know mySql and can write queries myself, but I love avoiding all the string concatenation and getting the benefit of making sure my queries are at least syntactically correct without the added effort. I see that this class is being sidelined for Fuel 2 but I still like it.
My question is, was this based off another library? I haven't really seen anything like it in other languages.
I want to port the concepts to Node.js but wanted to make sure I'm not stepping on any toes or that there hasn't developed a strong reason not to be building a query builder.
Thoughts?
The original DB classes ( in FuelPHP 0.x ) were a port from Kohana, and have evolved a lot since then. However, there are quite a lot of shortcomings in the current classes, which are very hard to fix due to the way it's setup.
So for 2.0 we're going to swap to Cabinet ( http://github.com/frenkynet/cabinet ), which uses a lot of the same philosophies of the current environment, but with a better structure, more features, and better RDBMS support ( as DB mainly has support for MySQL only ).