sqlc

sqlc copied to clipboard

Option to Segregate Read and Write queries to have separate db users with each type of query.

5

### What do you want to change? Usecase is to have seperate set of queries generated for read access and write access. For example if I have read user of...

K-odesome

### Version 1.25.0 ### What happened? If the number of parameters for a `batchexec` is ≤ `query_parameter_limit`, the struct for the parameters does not get generated. The generated function still...

SoMuchForSubtlety

Rename struct property name when using sqlc.embed in multiple joins from same table

2

### Version 1.25.0 ### What happened? I just need to perform a query that joins multiple rows from same table and i expect sqlc to take alias from query when...

lcnlvrz

Enums do not work with `ANY` queries

1

### Version 1.25.0 ### What happened? I have a table with an enum, and I want to write a query where I can pass a list of possible enum values...

happenslol

Support table-valued functions in the same way that OUT parameters are currently supported. The columns of the output table are returned by pg_analyze in the list of arguments, so we...

mariusavos

### What do you want to change? I do want free unicorns! But also, it just occurred to me that SQLC has one of the most robust SQL parsing systems...

alecthomas

Bug When Using Table Aliases: `table alias "all_users" does not exist`

10

### Version 1.25.0 ### What happened? Sqlc encounters issues when attempting to recognize table aliases specified within the WHERE clause, particularly when filtering selections using the syntax alias_table.field = 'something'....

AvicennaJr

`sqlc.slice()` breaks SQLite queries that contain other parameters.

7

### Version 1.18.0 ### What happened? sqlc generates queries using numbered parameters, but if a `sqlc.slice` comes before other parameters, the numbers will no longer match. ### Relevant log output...

SoMuchForSubtlety

Explicitly defining data type, but get: "could not determine data type of parameter $1"

2

### Version 1.25.0 ### What happened? Hi, thanks for contributing to such an awsome library. I'm trying to define explicit data types in my query, but I keep getting "could...

AmirSolt

Support dynamic order by clause

7

the order by clause in the :many definition query should be set dynamically ``` -- name: ListOrders :many select * from order where status = $1 order by @orderBy::text; ```...

go-aegian