sqlc icon indicating copy to clipboard operation
sqlc copied to clipboard

Generate type-safe code from SQL

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

### 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...

bug
:wrench: golang

### 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`...

bug
:books: sqlite

### 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...

bug
:books: postgresql
:wrench: golang

`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.

:wrench: golang
size:L

### 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...

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

### 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...

bug
:books: postgresql
:wrench: golang
:computer: darwin

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; --

enhancement
:books: postgresql
:wrench: golang

### 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"...

bug
:wrench: golang
:books: sqlite

### 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 (...

bug
:books: sqlite
:computer: linux