sqlc
sqlc copied to clipboard
Generate type-safe code from SQL
### 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...
### 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...
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...
### 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_...
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...
### 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...
### 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...
### 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...