sqlc
sqlc copied to clipboard
Generate type-safe code from SQL
### Version 1.29.0 ### What happened? Just using the basic tutorial. pgx/v5 if it matters. Here is the generated output. Am I missing something? go doesn't allow a const and...
### Version 1.28.0 ### What happened? Expected `sqlc generate` to generate all queries. I tried removing queries one by one and found that generating worked for everything except for `UPDATE`...
### Version 1.29.0 ### What happened? `sqlc generate` will panic when trying to generate the following sql query: ``` -- name: AllThingsTrue :one WITH t AS ( SELECT thing, bool_thing...
`sqlc` currently doesn't handle bound `ORDER BY` clauses in sqlite, nor does it have tests for this behavior. This PR attempts for rectify this. Closes https://github.com/sqlc-dev/sqlc/issues/3788.
### Version 1.29.0 ### What happened? When a PostgreSQL enum column is defined as nullable (i.e., without the NOT NULL constraint), sqlc generates interface{} instead of the configured go_type from...
### Version 1.29.0 ### What happened? The generated code uses an `int64` despite the database column being a `FLOAT`. Changing the `engine` to `sqlite` generates the correct code. I suspected...
Hi I have a following situation: - Repository _"base"_ has some queries and migrations ("schema"), that are processed by sqlc - Repository _"specific"_ has _"base"_ as a submodule (and vendors)...
### What do you want to change? query ```sql DO $$ BEGIN DELETE FROM stage_seat WHERE stage_id = $1; --
### Version 1.27.0 ### What happened? Using the schema and query to update a row on insertion conflict with the following Go test fails: ```go package db import ( "context"...
### Version 1.25.0 ### What happened? Sqlc does not support identifiers with utf8 characters. This are commonly used in non-English languages: Consider the following schema: ```sql CREATE TABLE autores (...