qb
qb copied to clipboard
coldbox-modules
Fluent Query Builder for CFML
`exists` current implementation is ``` public boolean function exists( struct options = {} ) { return count( options = arguments.options ) > 0; } ``` Which produces sql like ```...
Error: _**Incorrect syntax near 'OUTPUT**_'. This code: ``` ``` returns this: ``` UPDATE [zzz] SET [created] = {ts '2024-08-13 15:56:05'}, [user_id] = 1 FROM [zzz] INNER JOIN [aaa] ON [aaa].[ddd]...
The `deleteUnmatched` argument in the `upsert` function is currently too loose, as the result is a deletion of all rows in the database that don't match the source. Its current...
Imagine you want to save a struct like this to the database: ``` myFruit = { "name": "Banana", "color": "Yellow", "eatenDate": "" }; qb.from( "fruit" ).insert( myFruit ); ``` One...
It would be valuable to have a method in QB to return a random row from the query. Perhaps we could have an `orderByRandom()` method. Examples: ``` // return a...
``` getInstance("QueryBuilder@qb") .from("foo") .returning(["bar","baz"]) .where("key", "=", "someValue") .update(values={freshValue: 42}, toSql=true); ``` produces ``` UPDATE [foo] SET [FRESHVALUE] = ? WHERE [key] = ? ``` but should be something like ```...
hey upsert is great; I ran into the following using it, on the MSSQL grammar: ``` getInstance("queryBuilder@qb").from("rmme_foo").upsert( values = {a: 1, b: {value: "", null: true}, c: "some new string...
Hi, I'm using QuickORM in a private project and some fields on the Oracle Database were created with the type Nvarchar2, is it possible to add support to this? or...
If the attribute `sqltype` is used with a param block, qb seems to ignore it and instead infers a `cfsqltype`, which may be different to what was defined. According to...
