qb
qb copied to clipboard
coldbox-modules
Fluent Query Builder for CFML
A few database grammars now support json column types and filters. Add support into qb for this syntax.
I'm using temp tables quite a bit to improve performance. It's a shame to have to drop back to queryExecute for this. It seems trivial to add an .into() function...
Need to think about the syntax since queries can go on either side, the condition or the expression. Probably accept literals or closures or builder instances or raw expressions. Also...
Hi Eric Peterson, Making this a QB issue since cfmigrations doesn't have a project (and it involves SchemaBuilder). It looks like the way that cfmigrations was designed, it's primarily intended...
Things like `YEAR`, `MONTH`, `DAY`, etc. Need to validate that this is actually a good idea.
The following query will retrieve a list of constraints on a table, including column names, so you can filter if dropping a specific column. When dropping a table you can...
Probably not a good default, but a useful workaround for the 2,100 parameter limit in SQL Server 2016+ from Zac Spitzer: https://dev.lucee.org/t/is-it-possible-to-use-cf-sql-array-with-an-in-clause/4710/3 It'd be nice to be able to ask...
qb should fail when you define duplicate field names, but it is ignoring themsee this code ``` var myArray = _qbMySite4u().from("equipment equ") .join( "racks rck", "rck.id", "=", "equ.rack_FK") .select("equ.id,equ.name,equ.height,equ.rackPosition,rck.id,rck.name") ```...