jet
jet copied to clipboard
Type safe SQL builder with code generation and automatic query result data mapping
At the moment, the schema name is baked into the generated code. It would be helpful if the schema name could be globally overridden, so that a compiled program could...
In MySQL it is possible to use `ON DUPLICATE KEY UPDATE` clause in **batch inserts**, like in the below example: ``` INSERT INTO `buoy_stations` (`id`, `coords`, `name`, `owner`, `pgm`, `met`,...
Hey there, very interested in trying out this project. Wondering where MS SQLServer support would be on the roadmap? Thanks.
I was trying to do something similar to https://stackoverflow.com/questions/34708509/how-to-use-returning-with-on-conflict-in-postgresql/42217872#42217872 ```sql WITH input_rows(usr, contact, name) AS ( VALUES (text 'foo1', text 'bar1', text 'bob1') -- type casts in first row ,...
Hello, I've successfully used this library with PostgreSql connected to Oracle through a foreign data wrapper. Only 4 lines were added to generator/internal/metadata/schema_meta_data.go, as follows: ``` const ( baseTable =...
Bumps [github.com/jackc/pgx/v4](https://github.com/jackc/pgx) from 4.16.0 to 4.17.2. Changelog Sourced from github.com/jackc/pgx/v4's changelog. 4.17.2 (September 3, 2022) Fix panic when logging batch error (Tom Möller) 4.17.1 (August 27, 2022) Upgrade puddle to...
**Is your feature request related to a problem? Please describe.** We have few usecases where we need to have column as postgresql array and then filter if some item is...
Bumps [github.com/mattn/go-sqlite3](https://github.com/mattn/go-sqlite3) from 1.14.8 to 1.14.15. Commits d8e192b Update amalgamation code 595e132 Retract +incompatible releases fd616a2 Update supported Go version to Go 1.19 3ccccfb Support returning any from callbacks (#1046)...
Bumps [github.com/jackc/pgtype](https://github.com/jackc/pgtype) from 1.14.0 to 1.14.2. Changelog Sourced from github.com/jackc/pgtype's changelog. 1.14.2 (February 5, 2024) Fix numeric to float64 conversion (Joe Schafer) 1.14.1 (January 12, 2024) Backport fix numeric to...
**Is your feature request related to a problem? Please describe.** I would like to use [Prepare](https://cs.opensource.google/go/go/+/go1.22.0:src/database/sql/sql.go;l=1604) and [PrepareContext](https://cs.opensource.google/go/go/+/go1.22.0:src/database/sql/sql.go;l=1584) with Jet queries to realize the performance benefit. I have benchmarked hand...