sqlc

sqlc copied to clipboard

I have a Supabase Postgres instance. I have used some ORMs (like SeaORM in Rust), which gives a link and login, can automatically generate the equivalent structs. The quickest option...

assembly-winston

Ability to return an iterator on a "many" query

17

Hi, when a query return a myriad of objects, the slice based solution is not very efficient, it would be great if it was possible to have a way to...

encendre

JSONB query support with pgx/v4 and prefer_simple_protocol results in ERROR: invalid input syntax for type json (SQLSTATE 22P02)

6

### Version 1.16.0 ### What happened? Attempting a query with an input parameter of type `jsonb not null`, using driver `pgx/v4`, and with `prefer_simple_protocol=true` results in the query failing with:...

samavos

varchar2 support

1

### What do you want to change? Oracle has a `varchar2` datatype, and it's the same as `varchar` (at least for now), but it can change in the future. Because...

yitsushi

I'm using mysql with the following configuration: ``` version: "2" sql: - engine: "mysql" schema: "some-path/schemas" queries: "some-path/queries" gen: go: out: "some-path/tables" package: "internal" ``` I'd like to be able...

victor-mitcov

Sqlc could not support table alias (error: table alias "t1" does not exist)

2

### Version 1.18.0 ### What happened? Sqlc could not support table alias, the sql example is in below. The error message is "table alias "t1" does not exist" ### Relevant...

ankisme

fix(resolve): fix resolving reference to CTEs

7

Fixed resolving refs to CTEs by adding CTEs to the aliasMap and indexing its columns when resolving catalog references. Fix #3219 --- This is may not be the fix you...

simonklee

PostgreSQL and not using `lib/pq` for arrays

1

### What do you want to change? ### Current state In current state of the library, using queries with arrays generates code with a dependency to `github.com/lib/pq`, which is in...

papisz

Use type name 'any' for ALTER TABLE t1 ADD COLUMN c1 where no type name for c1 is provided. This is the same logic as for CREATE TABLE. Fixes #3375

dvob

sqlite ALTER TABLE ADD COLUMN without type name panics

2

### Version 1.26.0 ### What happened? sqlc panics after i've added a migration which adds a [generated column](https://www.sqlite.org/gencol.html) which uses a [json function](https://www.sqlite.org/json1.html#jptr) ### Relevant log output ```shell panic: runtime...

dvob