sqlc icon indicating copy to clipboard operation
sqlc copied to clipboard

Generate type-safe code from SQL

Results 584 sqlc issues
Sort by recently updated
recently updated
newest added

Edit: I have renamed the issue, as this is not really a bug, after all, but a compatibility problem. See the comments for more context. ### Version 1.27.0 ### What...

bug
:wrench: golang
:books: sqlite

### Version 1.24.0 ### What happened? I created an inherited table in Postgres and everything worked as expected. Then I decided I needed to add a column to the parent...

bug
triage

### Version 1.27.0 ### What happened? The generated output lacks any query parameters which yields it completely useless. All the `sqlc.arg()` are ignored with no errors raised. When switched annotation...

bug
:books: postgresql
:wrench: golang
:computer: windows

### Version 1.29.0 ### What happened? https://docs.sqlc.dev/en/latest/guides/development.html#for-postgresql says db is "dinotest" for postgresql https://github.com/sqlc-dev/sqlc/blob/main/docker-compose.yml has the database set to "postgres" ### Relevant log output ```shell ``` ### Database schema ```sql...

bug
:books: postgresql

### Version 1.13.0 ### What happened? I have a query ``` -- name: Test :exec INSERT INTO test (id, body) VALUES ( UNNEST($1::uuid[]), UNNEST($2::varchar[])); ``` there is a generated struct...

enhancement
:books: postgresql
:wrench: golang
:computer: darwin

### Version 1.29.0 ### What happened? Code generation with SQLite errors out when the output package name has '/' in it. ### Relevant log output ```shell // Code generated by...

bug
:wrench: golang
:computer: darwin
:books: sqlite

### What do you want to change? Let's say we have the following generated code to store a new user ```go const createUser = `-- name: CreateUser :one INSERT INTO...

enhancement
:books: postgresql
:wrench: golang

### What do you want to change? When generating code for queries that return slices, the generated code initializes the slice as `nil` instead of an empty slice. When this...

enhancement
:books: postgresql
:wrench: golang

Given this SQL: ```sql CREATE TYPE fruit AS ENUM ('apple', 'banana', 'kiwi'); CREATE TABLE choices ( id int PRIMARY KEY, fruits fruit[] NOT NULL ); -- name: GetChoice :one SELECT...

invalid
:books: postgresql
:wrench: golang
pgx/v4

### Version 1.28.0 ### What happened? Referening the "value" column from json_each function results in the error message 'column "value" does not exist'. Aliasing the result from json_each function call...

bug
:wrench: golang
:computer: darwin
:books: sqlite