sqlc-dev · Mr-Destructive · Aug 7, 2025 · Aug 9, 2025
diff --git a/internal/endtoend/testdata/ddl_alter_table_case_sensitivity/sqlite/go/db.go b/internal/endtoend/testdata/ddl_alter_table_case_sensitivity/sqlite/go/db.go
diff --git a/internal/endtoend/testdata/ddl_alter_table_case_sensitivity/sqlite/go/models.go b/internal/endtoend/testdata/ddl_alter_table_case_sensitivity/sqlite/go/models.go
diff --git a/internal/endtoend/testdata/ddl_alter_table_case_sensitivity/sqlite/go/query.sql.go b/internal/endtoend/testdata/ddl_alter_table_case_sensitivity/sqlite/go/query.sql.go
diff --git a/internal/endtoend/testdata/ddl_alter_table_case_sensitivity/sqlite/query.sql b/internal/endtoend/testdata/ddl_alter_table_case_sensitivity/sqlite/query.sql
@@ -0,0 +1,7 @@
+-- name: InsertUser :exec
+INSERT INTO Users (full_name, "EmailAddress", created_at)
+VALUES (?, ?, ?);
+
+-- name: SelectUsers :many
+SELECT id, full_name, "EmailAddress", created_at
+FROM Users;
diff --git a/internal/endtoend/testdata/ddl_alter_table_case_sensitivity/sqlite/schema.sql b/internal/endtoend/testdata/ddl_alter_table_case_sensitivity/sqlite/schema.sql
@@ -0,0 +1,10 @@
+-- Test ALTER TABLE operations with mixed case table and column names
+-- Verifies consistent handling of case sensitivity in DDL operations
+CREATE TABLE Users (id integer primary key, name text, "Email" text);
+
+-- Test renaming columns with different case formats
+ALTER TABLE Users RENAME COLUMN name TO full_name;
+ALTER TABLE Users RENAME COLUMN "Email" TO "EmailAddress";
+
+-- Test adding a simple column
+ALTER TABLE Users ADD COLUMN created_at text;
diff --git a/internal/endtoend/testdata/ddl_alter_table_case_sensitivity/sqlite/sqlc.json b/internal/endtoend/testdata/ddl_alter_table_case_sensitivity/sqlite/sqlc.json
@@ -0,0 +1,12 @@
+{
+  "version": "1",
+  "packages": [
+    {
+      "path": "go",
+      "engine": "sqlite",
+      "name": "querytest",
+      "schema": "schema.sql",
+      "queries": "query.sql"
+    }
+  ]
+}
diff --git a/internal/endtoend/testdata/ddl_drop_table/sqlite/schema.sql b/internal/endtoend/testdata/ddl_drop_table/sqlite/schema.sql
@@ -1,2 +1,8 @@
 CREATE TABLE venues (hi text);
-DROP TABLE venues;
+DROP TABLE venues;
+
+CREATE TABLE Authors (id integer);
+DROP TABLE Authors;
+
+CREATE TABLE "Books" (id integer);
+DROP TABLE "Books";
diff --git a/internal/endtoend/testdata/quoted_names_complex/sqlite/go/db.go b/internal/endtoend/testdata/quoted_names_complex/sqlite/go/db.go
diff --git a/internal/endtoend/testdata/quoted_names_complex/sqlite/go/models.go b/internal/endtoend/testdata/quoted_names_complex/sqlite/go/models.go
diff --git a/internal/endtoend/testdata/quoted_names_complex/sqlite/go/query.sql.go b/internal/endtoend/testdata/quoted_names_complex/sqlite/go/query.sql.go
diff --git a/internal/endtoend/testdata/quoted_names_complex/sqlite/query.sql b/internal/endtoend/testdata/quoted_names_complex/sqlite/query.sql
@@ -0,0 +1,2 @@
+-- name: Placeholder :exec
+SELECT 1;
diff --git a/internal/endtoend/testdata/quoted_names_complex/sqlite/schema.sql b/internal/endtoend/testdata/quoted_names_complex/sqlite/schema.sql
@@ -0,0 +1,22 @@
+-- Test complex quoted table and column names with special characters
+-- Covers spaces, hyphens, uppercase, and mixed operations
+CREATE TABLE "user profiles" (id integer primary key, data text);
+CREATE TABLE "ORDERS" (id integer primary key, data text);
+CREATE TABLE products (id integer primary key, data text);
+CREATE TABLE "item-categories" (id integer primary key, data text);
+
+-- Test ALTER statements with complex identifiers
+ALTER TABLE "user profiles" RENAME COLUMN data TO "profile data";
+ALTER TABLE "ORDERS" RENAME TO "customer_orders";
+ALTER TABLE products ADD COLUMN "Price Info" text;
+
+-- Test mixed case operations across different statement types
+INSERT INTO "user profiles" ("profile data") VALUES ('test data');
+UPDATE "ORDERS" SET data = 'updated' WHERE id = 1;
+DELETE FROM products WHERE id = 1;
+
+-- Test DROP with various identifier formats
+DROP TABLE "user profiles";
+DROP TABLE "customer_orders";
+DROP TABLE "item-categories";
+DROP TABLE products;
diff --git a/internal/endtoend/testdata/quoted_names_complex/sqlite/sqlc.json b/internal/endtoend/testdata/quoted_names_complex/sqlite/sqlc.json
@@ -0,0 +1,12 @@
+{
+  "version": "1",
+  "packages": [
+    {
+      "path": "go",
+      "engine": "sqlite",
+      "name": "querytest",
+      "schema": "schema.sql",
+      "queries": "query.sql"
+    }
+  ]
+}
diff --git a/internal/endtoend/testdata/table_name_case_sensitivity/sqlite/go/db.go b/internal/endtoend/testdata/table_name_case_sensitivity/sqlite/go/db.go
diff --git a/internal/endtoend/testdata/table_name_case_sensitivity/sqlite/go/models.go b/internal/endtoend/testdata/table_name_case_sensitivity/sqlite/go/models.go