sqlc

sqlc copied to clipboard

Querying Postgres Materialized Views Catalog: relation "pg_matviews" does not exist

1

### Version 1.26.0 ### What happened? A bug happened! Running: ``` go install github.com/sqlc-dev/sqlc/cmd/sqlc@latest sqlc generate ``` errors with: > relation "pg_matviews" does not exist. tried `:exec`, `:many` as well...

mikeblum

Go struct generation for WITH coalesced JSONb not working as expected for pgx/v5 - interface{} instead of []byte

1

### Version 1.26.0 ### What happened? Been playing with this since yesterday - I have a sample query that is modified to remove columns and change table names. Starting to...

dennisharrison

docker run 1.26.0 but generating v1.25.0

1

### Version 1.26.0 ### What happened? when i run `docker run --rm -v "$(PWD):/src" -w /src sqlc/sqlc:1.26.0 generate`, but the generated files have `v1.25.0`. ### Relevant log output _No response_...

notjaywu

### What does this PR fixed? - This PR addresses issues with SQL formatting tools [pgFormatter](https://www.postgresql.org/about/news/pgformatter-v55-released-2589/) and [sql-formatter](https://github.com/sql-formatter-org/sql-formatter). These tools are used to format SQL, similar to how `go fmt`...

Dragon-Huang0403

Allow for passing comments through the table schema to the generated Go Struct

1

### What do you want to change? Currently, generating a table from the basic SQL will strip the field comments completely: ``` CREATE TABLE test ( id text PRIMARY KEY,...

PaulSonOfLars

Duplicated Query Name even when there is no duplicate.

1

### Version 1.26.0 ### What happened? I'm just strarting to explore this tool and added a couple tables and some more queries straight from tutorial and... it's broken. Not sure...

piti118

Redundant import of lib/pq when using sqlc.slice() with sqlc.narg() with MySQL

4

### Version 1.26.0 ### What happened? When I run `sqlc generate` with `engine: "mysql` and I use `sqlc.slice(myslice)` inside queries, in the generated file with Go code it inserts an...

dskarataev

Support dynamic queries

8

### Discussed in https://github.com/sqlc-dev/sqlc/discussions/364 Originally posted by **mehdijoafshani** February 27, 2020 Does it make sense to support dynamic queries ? *(Dynamic `where` and `orderBy` clauses)*. Due to some requirements we...

kyleconroy

copyfrom not respecting `query_parameter_limit`

1

### Version 1.26.0 ### What happened? When using `:copyfrom` query with `query_parameter_limit` set, generated code will still try to use parameter struct: ```go func (q *Queries) CreateAuthors(ctx context.Context, arg []CreateAuthorsParams)...

KlemenPl

### What do you want to change? Hello, my use case is the following: I've a request with many WHERE clauses, invoked from a webservice with paging parameters (offset and...

benoitdupont