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.10.0 ### What happened? ``` -- name: ShouldHaveNull :many select (select other_table.name from other_table where this_table.name = other_table.name) as "name" from this_table; ``` sqlc will generate an output...

bug
:books: postgresql
:wrench: golang

### Version 1.14.0 ### What happened? I have a very similar setup as an example from a closed issue: #1650 In this issue's SQL query section, it casts the $5...

bug
triage

in https://github.com/kyleconroy/sqlc/issues/457 support for ARM was verified and indeed this package compiles for me on Apple silicon without a problem. however, this project's releases do not include builds for darwin_arm64...

enhancement

### What do you want to change? Use [caseInsensitive](https://github.com/antlr/antlr4/blob/master/doc/options.md#caseinsensitive) option for [SQLiteLexer.g4](https://github.com/kyleconroy/sqlc/blob/8618c39830996cfde6d32096563eb8310beb9046/internal/engine/sqlite/parser/SQLiteLexer.g4) instead of fragments. It's available since ANTLR 4.10. ### What database engines need to be changed? _No response_...

enhancement
triage

We use sqlc to generate some code, and on top of that, we write others. But unfortunately, generated code and structs are available by other packages. Also, different packages can...

Fixes: https://github.com/kyleconroy/sqlc/issues/1747 Problem - I was unable to write a query against pg_timezone_names. **Actual failing query** ```sql select name, abbrev, utc_offset, to_char((current_timestamp at time zone name), 'HH:MI am') as current_time...

### Version 1.14.0 ### What happened? I have a column name `uuid` in my tables with `UUID` type. By default `sqlc` generates the struct field name as `Uuid`. I have...

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

### Version 1.14.0 ### What happened? The proper generated row should be ```go type GetAuthorRow struct { ID int64 Name string } // instead of type GetAuthorRow struct { ID...

bug
:books: postgresql
:wrench: golang
:computer: linux

### Version 1.14.0 ### What happened? This bug has been reported before in #606, but I wanted to bump the issue and provide a work around! The issue is that...

bug
:books: postgresql
:wrench: golang
:computer: linux

### Version 1.14.0 ### What happened? Wanted to create a new enum only `IF NOT EXISTS`. This might not be supported in postgres (dunno), but is supported in cockroachdb https://www.cockroachlabs.com/docs/v22.1/create-type...

bug
triage