qb
qb copied to clipboard
coldbox-modules
Fluent Query Builder for CFML
Creating a table with an `increments` column in Oracle is tricky. Oracle doesn't have any idea of `IDENTITY` or `AUTO_INCREMENT`, so instead we use a `NUMBER` as the column type...
In Oracle, the logged in user defines the default schema. You can override this by prepending table calls with the schema. If a schema is provided, in Oracle we should...
Oracle triggers use the `:new` pseudorecords; CFML expects strings preceded with a colon to be a parameter. Lucee for sure escapes colons by adding a second colon (`::new`). Not sure...
MSSQL Server and Oracle both support `cross apply` and `outer apply` as part of their join grammars, it would be helpful if QB offered a way to access these DB...
I would love to see the file name and line number in comments for every query. A .comment() function to add a custom label would be really handy too.
Postgres has a UUID type: https://www.postgresql.org/docs/14/datatype-uuid.html The `uuid()` method should use this. Worth a PR?
Is it possible to use 2 different versions of QB in a single app to compare functionality? (I've been burned in the past with ColdFusion updates that have returned different...
It doesn't happen a lot, but occasionally I have to do something like the code below. It would be nice to have an alternative/extension to the returning() function that returns...
Along with the `JSON` column type, Postgres has `jsonb` which provides additional functionality in terms of indexing and searching. Currently, SchemaBuilder doesn't have a column type for this - it...
``` Doesn't work: // this.auditTables = qb.from('tables').get( options={ datasource: 'veritiAudit', returntype: 'struct', columnkey: 'name', cachedwithin: createTimespan(0,2,0,0) } ) Works: this.auditTables = queryExecute("select * from tables",{},{ datasource: 'veritiAudit', returntype: 'struct', columnkey:...