jet
jet copied to clipboard
go-jet
Type safe SQL builder with code generation and automatic query result data mapping
**Describe the bug** There are no descriptions about using multiple WHERE clauses in the [SELECT](https://github.com/go-jet/jet/wiki/SELECT) section. It’s common to use multiple conditions in queries, but this documentation lacks examples or...
### Problem Both standard SQL and many dialects have function signatures that look something like `SOME_FUNC(arg1, arg2 KEYWORD arg3)`. To name a few specific examples, we have things like: *...
### Problem SQL:2003 introduced filtered aggregations, e.g. `SELECT COUNT(*) FILTER(WHERE foo > 0)`. They're currently supported in Postgres and SQLite. If I want to use this syntax in Jet, I...
**Describe the bug** This issue is for improving the docs (if someone starts me on the right path, I'll also gladly make a PR once I understand), not the technical...
The current column metadata query fails to identify array data types correctly.
I am using **pgx** together with jet, and currently to be able to scan rows into structs I have to use AS method and write all the columns instead of...
**Describe the bug** The code generator should fail if datamodel contains reserved fields. There is a collision with the way the code is constructed, because postgres.Table exposes TalbeName() and the...
**Describe the bug** The query builder replaces rather than adds components and clauses. This goes against the behavior of every single query builder I've ever worked with, and is rather...
**Is your feature request related to a problem? Please describe.** Right now the default for Jet is to let postgres arrays get generated into golang strings. You can override the...
