sqlc

sqlc copied to clipboard

Cannot pass empty values for sqlc.slice

1

### Version 1.25.0 ### What happened? For the query: ``` -- name: List :many SELECT * FROM table WHERE (id IN (sqlc.slice('ids')) OR sqlc.slice('ids') == NULL) ORDER BY id; ````...

pengux

### Version 1.25.0 ### What happened? Here's an example: https://play.sqlc.dev/p/f32a811caf892026c11495a0059cc4eb041ba647e746f47316873f7bc85bd3bd The CreateTitle query `INSERT INTO titles (id, name, author_id) VALUES ($1, $2, (SELECT author_id FROM authors WHERE name = $3));`...

ncabatoff

Can't generate only schema without queries

3

### What do you want to change? ### Context: - Techstack I'm used: - go version go1.21.6 linux/amd64 - kjconroy/sqlc:latest image - config yaml file: v2 - I want to...

qanghaa

RECURSIVE cte failed with `star expansion failed for query`

1

### Version 1.25.0 ### What happened? Failed to generate go model when using recursive CTE ### Relevant log output ```shell -- With database-backed analysis # package db/queries/tickers.sql:1:1: star expansion failed...

anthonycj04

Vetting doesn't seem to pick up column names being altered

1

### Version 1.25.0 ### What happened? If you rename a column using alter table, but have existing queries against the previous column, I would've expected `sqlc vet` to pick that...

dbhoot

Automatically infer the types and use better Column names like offset and limit

2

### What do you want to change? https://docs.sqlc.dev/en/stable/howto/named_parameters.html Not working for postgresql. original: ``` ... when 'all' = $1::varchar then true ... ``` `OFFSET $2::int LIMIT $3::int;` tried both ways...

eprokhor

### What do you want to change? Currently, when a field is nullable and an enum, sqlc always generates a new type with a prefix `Null`. This `Null___` type is...

nderscore

### What do you want to change? In queries like: ``` SELECT [...] array_agg(authors.name)::TEXT[] AS author_names, [...] GROUP BY [...] ``` It would be nice to have not only `TEXT`...

mono424

go: expose DBTX inside Queries (via flag)

4

### What do you want to change? Currently the autogenerated `db.go` file contains this two types: ```go type DBTX interface { Exec(context.Context, string, ...interface{}) (pgconn.CommandTag, error) Query(context.Context, string, ...interface{}) (pgx.Rows,...

toqueteos

Left joining same table as FROM statement results in unexpected string type rather than a nullable string type

3

### Version 1.25.0 ### What happened? Using the schema and query below, I would expect the `manager_name` column to be nullable because the `manager_id` field is nullable. However, when sqlc...

bradenrayhorn