sqlc

sqlc copied to clipboard

### Version 1.28.0 ### What happened? This query cannot be parsed by sqlc using the sqlite engine: ```sql with params (foo) as (select ?) select * from params; ``` I...

Mehgugs

override for json not working in golang

1

### Version 1.29.0 ### What happened? set overrides for a field type json is not working  `sqlc generate`  `GetOrderProductsRow.Additionals` should be `json` cutom type not `[]byte` ### Relevant...

julian-reactive

Pq Bind message errors

1

Hello I am getting pq bind message errors like the following below ``` 2025/04/06 09:52:07 Error fetching jobs: pq: bind message supplies 6 parameters, but prepared statement "" requires 1...

hackertron

### Version 1.29.0 ### What happened? Using a CTE (`WITH`) before a SELECT statement with a ? argument in it (or sqlc.arg() call) - the argument is not detected by...

cjtheham

invalid memory address or nil pointer dereference when trying to generate go code from sqlite query

5

### Version 1.29.0 ### What happened? I have these 2 queries When i try to run `sqlc generate` it returns an error saying invalid memory address Not quite sure what...

WWology

pq being used when "slice" is set to true in a column override with sqlite

1

### Version 1.29.0 ### What happened? Hi there, I was trying out sqlc with sqlite in a small experiment and I was trying to find the right away to get...

Rick-Phoenix

Relation does not exists when name is surrounded by ` character

2

### Version 1.28.0 ### What happened? I'm using this `sqlite3` command to export schema from the database: `sqlite3 db/data.db '.schema authors' > ./db/schema.sql` and it generates an sql schema where...

Codebreaker101

### Version 1.29.0 ### What happened? Using `string_agg` results in a `[]byte` instead of `*string`, or `pgtype.Text`, like I'd expect. The order by in the examples don't make a difference,...

angaz

Go panics when sub query is missing an alias with sqlite

2

### Version 1.26.0 ### What happened? I accidentally left an alias off my subquery and I got a panic instead of a useful error message. Failing playground without alias (included...

leetrout

UNNEST can't handle multiple arrays

1

### Version 1.26.0 ### What happened? See linked playground. If you make it a single array it works fine. Supported since postgres 9.4 ### Relevant log output ```shell function unnest(unknown,...

danthegoodman1