sqlc

sqlc copied to clipboard

NOT EXISTS in correlated subquery doesn't generate required parameter

3

### Version 1.30.0 ### What happened? When using a NOT EXISTS clause in a correlated subquery, SQLC fails to recognize and generate the required parameter binding. Expected behavior: The generated...

anthonyg876

## Summary Adds an optional `analyzer.accurate: true` mode for PostgreSQL that bypasses the internal catalog and uses only database-backed analysis for more accurate type information. ### Key Features - **Database-only...

kyleconroy

Inferring columns from some CTE's is invalid

1

### Version 1.28.0 ### What happened? I have the following CTE in my queries.sql ```sql WITH w_pending_sale_status as ( select * from (values ('SAVED'), ('IDLE'), ('IN PROGRESS'), ('HELD')) as pending_sale_status(status)...

blanchardglen

kyleconroy

## Summary - Adds a MySQL database analyzer that validates queries against a real MySQL database during code generation - Creates managed databases (`sqlc_managed_{hash}`) based on migration content hash for...

kyleconroy

Column reference is ambiguous

1

### Version 1.25.0 ### What happened? When I generate the code, it returns an "ambiguous column" error, I tested this in MySQL directly and it works. The culprit is `(SELECT...

vunhatchuong

Fixes https://github.com/sqlc-dev/sqlc/issues/4182 PostgreSQL LATERAL subqueries now correctly resolve column references to outer query tables.

WillAbides

Exclude columns from `sqlc.embed`

2

Is there a way to exclude columns from `sqlc.embed(my_table)`? It would be useful to avoid reading from specific columns (e.g. columns you need to drop, and you want to stop...

Couper4

Seg fault when running in Docker

1

### Version 1.30.0 ### What happened? We use SQLC through Docker and had no issues running `generate` and `vet` commands under 1.29.0. Upgrading to the `sqlc/sqlc:1.30.0` image. This fails when...

denialanderror

Unable to generate queries using "SET" and "SET LOCAL"

1

### Version 1.30.0 ### What happened? I'm trying to generate a query using one of the following variations: ```sql SET LOCAL app.current_user_id = @user_id::text; -- syntax error at or near...

Pitasi