test(e2e): add accurate mode test for CTE with VALUES clause

Tests CTE using VALUES clause with column aliasing to verify accurate analyzer handles inline table expressions. 🤖 Generated with [Claude Code](https://claude.com/claude-code) Co-Authored-By: Claude <noreply@anthropic.com>
sqlc-dev · kyleconroy · Dec 22, 2025 · Dec 1, 2025 · Dec 1, 2025 · Dec 1, 2025
commit 7d5caa78ac998e64f316cca6b0cc7b8ce6672411
diff --git a/internal/endtoend/testdata/accurate_cte_values/postgresql/stdlib/exec.json b/internal/endtoend/testdata/accurate_cte_values/postgresql/stdlib/exec.json
@@ -0,0 +1,3 @@
+{
+  "contexts": ["managed-db"]
+}
diff --git a/internal/endtoend/testdata/accurate_cte_values/postgresql/stdlib/go/db.go b/internal/endtoend/testdata/accurate_cte_values/postgresql/stdlib/go/db.go
diff --git a/internal/endtoend/testdata/accurate_cte_values/postgresql/stdlib/go/models.go b/internal/endtoend/testdata/accurate_cte_values/postgresql/stdlib/go/models.go
diff --git a/internal/endtoend/testdata/accurate_cte_values/postgresql/stdlib/go/query.sql.go b/internal/endtoend/testdata/accurate_cte_values/postgresql/stdlib/go/query.sql.go
diff --git a/internal/endtoend/testdata/accurate_cte_values/postgresql/stdlib/query.sql b/internal/endtoend/testdata/accurate_cte_values/postgresql/stdlib/query.sql
@@ -0,0 +1,7 @@
+-- name: GetPendingSaleStatuses :many
+WITH w_pending_sale_status as (
+    select * from
+    (values ('SAVED'), ('IDLE'), ('IN PROGRESS'), ('HELD'))
+    as pending_sale_status(status)
+)
+SELECT status FROM w_pending_sale_status;
diff --git a/internal/endtoend/testdata/accurate_cte_values/postgresql/stdlib/schema.sql b/internal/endtoend/testdata/accurate_cte_values/postgresql/stdlib/schema.sql
@@ -0,0 +1 @@
+-- Empty schema - CTE uses VALUES clause only
diff --git a/internal/endtoend/testdata/accurate_cte_values/postgresql/stdlib/sqlc.yaml b/internal/endtoend/testdata/accurate_cte_values/postgresql/stdlib/sqlc.yaml
@@ -0,0 +1,13 @@
+version: "2"
+sql:
+  - engine: "postgresql"
+    queries: "query.sql"
+    schema: "schema.sql"
+    database:
+      uri: "postgresql://postgres:mysecretpassword@localhost:5432/postgres"
+    gen:
+      go:
+        package: "querytest"
+        out: "go"
+    analyzer:
+      accurate: true