sqlc
sqlc copied to clipboard
sqlc-dev
Generate type-safe code from SQL
### Version 1.25.0 ### What happened? I tried to use a SQLite [UPDATE FROM](https://www.sqlite.org/lang_update.html#update_from) statement, but sqlc failed to parse it. ### Relevant log output ```shell line 4:0 extraneous input...
### Version 1.24.0 ### What happened? Multiple fields with the same name are generated _It will work correctly if you use enumerations ($1, $2, etc.) or sqlc.arg(number)_ ### Relevant log...
**NOTE: This PR is in a draft state, because it still requires (at the very least) documentation updates.** This PR adds support for commenting out parts of the schema. This...
### Version 1.25.0 ### What happened? A migrations file using the MySQL `JSON_TABLE` function cannot be parsed by sqlc. ([Documentation for MySQL](https://dev.mysql.com/doc/refman/8.0/en/json-table-functions.html), [MariaDB](https://mariadb.com/kb/en/json_table/)) ### Relevant log output ```shell # package...
### What do you want to change? `sqlc.embed` does not recognize type from CTE (see [repo link](https://play.sqlc.dev/p/7c9e36e812b6f29ac404facbad355adc13a3e7406d2e106d2cf3f4a09355055d)) I have 2 examples: - one that works correctly : ```-- name: ListCustomers...
### Version 1.25.0 ### What happened? When left joining two (or more) tables, where the selected values are embedded into structs using `sqlc.embed`, an error occurs when the joined table...
### Version 1.25.0 ### What happened? CAST and CONVERT don't produce correct go types for mysql ```sql -- name: GetAuthors :many SELECT id, CAST(name AS CHAR(50)) AS castedName FROM authors;...
### Version 1.25.0 ### What happened? When a sqlite integer primary key is declared in a separate line, the generated type is nullable even though sqlite constrains the type to...
### Version 1.25.0 ### What happened? SUM of INTEGER field has inferred type `NullFloat64` when it can be inferred as `NullInt64` ### Relevant log output _No response_ ### Database schema...
