sqlc

sqlc copied to clipboard

SELECT foo.id AS foo_id loses Go type information

7

I'm trying to use custom Go types for some SQL columns, mapping a sql `int64` to Go `type FooID uint64`. It seems I can have `SELECT foo.id FROM ...` and...

tv42

JSONB not working? Or did I set it up incorrectly?

1

### Version 1.13.0 ### What happened? This is my schema (simplified for brevity): ``` CREATE TABLE IF NOT EXISTS cleric_druid_queries ( id text PRIMARY KEY, context jsonb, updated_time timestamp without...

didip

Using the docker container as a build step?

1

### What do you want to change? This seems related to #753 , without building my own sqlc container I'm trying to figure out if I can include sqlc as...

polds

Add Clickhouse support

15

### What do you want to change? I've enjoyed using sqlc with postgres. However, I'm starting to do more work with [Clickhouse](https://github.com/ClickHouse/ClickHouse) and it would be great to also use...

bojdell

Crash in compiler.(*Compiler).resolveCatalogRefs using jsonb_build_object()

1

### Version 1.14.0 ### What happened? sqlc consistently crashes when using `jsonb_build_object()` with sqlc.arg(). As a workaround, adding `::varchar` to the inputs to give sqlc a hint about the types...

danielbprice

### Version 1.14.0 ### What happened? As part of a project, we are exposing a configuration parameter to allow users to configure their timezone. This allows us to send notifications...

skabbes

### Version 1.14.0 ### What happened? sqlc currently errors out with `column "…" does not exist` when referencing a PostgreSQL [system column](https://www.postgresql.org/docs/current/ddl-system-columns.html) (`tableoid`, `xmin`, `cmin`, `xmax`, `cmax` or `ctid`) in...

ndrpnt

`SELECT COALESCE()` results are always assumed non-null

2

### Version 1.13.0 ### What happened? Possibly related to: - #937 - #1096 `SELECT COALESCE(x, y)` results are always assumed non-null. If all fields are nullable, result typing should not...

mpyw

### What do you want to change? Free unicorns! And... Currently, when I use a bunch of query methods (like `q.SelectUnicorns()`) and then just do the usual `if err!=nil {...

Hades32

Can't use name parameters for less than/greater than conditions

3

### Version 1.12.0 ### What happened? I tried to use named params for greater than check, but I get a syntax error. Works with `$1` in place of `@offset`. Also...

danthegoodman1