qb

qb copied to clipboard

I would like to use max() to find a max taskID, but I need some kind of value to increment, even if there is no return. I would start with...

Daemach

First-class grammar support for native JSON marshaling

1

MSSQL and MySQL both support returning queries natively in JSON (as opposed to JSON column types and filters here: https://github.com/coldbox-modules/qb/issues/95): MSSQL: https://docs.microsoft.com/en-us/sql/relational-databases/json/format-query-results-as-json-with-for-json-sql-server?view=sql-server-ver15 (`FOR JSON (PATH|AUTO)`) MySQL: https://dev.mysql.com/doc/refman/5.7/en/json-creation-functions.html (`SELECT`-based) PostgreSQL: https://dba.stackexchange.com/questions/90482/export-postgres-table-as-json/90495#90495...

MordantWastrel

Remove this setting in the next major version of qb.

elpete

elpete

Pagination fails with distinct (Grammer: MS SQL SERVER)

8

When drafting a QB query with distinct() it constructs an invalid query select list: ` Message | stringIncorrect syntax near '*'. | string | Incorrect syntax near '*'. -- |...

srconklin

Dropping Indexes in SQL Server uses a different syntax than DROP CONSTRAINT

4

``` DROP INDEX table_name.index_name; ```

elpete

Because of my heavy use of parallel processing, I occasionally run into deadlocks. It's very random but happens enough that I would love to find an elegant solution. Because of...

Daemach

updateOrInsert should return "generatedKey" somehow, even on updates...

5

I love the update or insert, but really need a key back, either the inserted key or actual key from the updated record (my where clause checks a fk). The...

Daemach

Return `date` as the sqltype for date objects (as opposed to datetime objects)

1

elpete

There may be a problem with a validation check in BaseGrammar.cfc when using MSSQL server. If you want to compose a query that utilizes a UNION and nested ORDER BY...

homestar9