Andrew
Andrew
By default, sending multiple constraints to upper.io `Find()` behaves as a union (OR), which may surprise users expecting an intersection (AND). Can we make this default behavior more clear in...
Hi, I want to `db.And()` a dynamic array of `db.Cond`'s. The documentation appears to support this: > Cond is a map that defines conditions for a query and satisfies the...
Could we get Go methods for `SUM`, so that we don't have to write as many SQL queries? I tried passing `db.Raw("SUM(net_cost)")` to `pool.Collection("charge").Select()`, but this unfortunately returns zero every...
Hello, I want to perform a lexicographic `ORDER BY` in SQL via upper.io. In raw SQL, this is accomplished with `ORDER BY LENGTH(), `. However, upper.io's API does not appear...
Hi, I would like to use `InsertReturning()` through a view. However, upper complains that it doesn't know about the primary keys for the view. (The view is writeable and the...
Hi, I would like to use conditions like `Where()`/`Find()` around my `UpdateReturning()` statements. Can we grow the API to support this?
I think MySQL may have limited support for marshaling between UUID Go objects and VARCHAR(36) SQL columns. However, binary UUID format in SQL is much more performant. Do you think...
Hi, I am having good luck using the upper API. However, the upper.io website appears to have some glitches. I can hover over each of the INSERT, RESULT SETS, RETRIEVING...
For nested structures, it is helpful to assume JSON codecs by default. Currently, users have to add boilerplate for Scan(), Value() methods for each and every nested struct type involved...
upper looks awesome at manipulating tables! Could there be support for manipulating views as well, so that we can use more high level Go methods instead of raw SQL queries?...