[PR #8556] feat(db): add case insensitive queries support #8061

Open
opened 2026-03-13 13:58:43 -05:00 by GiteaMirror · 0 comments
Owner

📋 Pull Request Information

Original PR: https://github.com/better-auth/better-auth/pull/8556
Author: @jonathansamines
Created: 3/11/2026
Status: 🔄 Open

Base: canaryHead: feat/add-case-insensitive-ops


📝 Commits (10+)

  • 8985eca chore(core): add support for case insensitive queries
  • c8053d5 chore(e2e): add test suite for case insensitive queries
  • b45dcb5 chore: add to spell dictionary
  • d582472 chore(core): fix memory adapter ops over non-string values
  • 8701bb5 chore(drizzle-adapter): handle empty arrays at in operations
  • 2919aee chore(mongo-adapter): add support for empty in operations
  • bd5def4 chore(kysely-adapter): restore single value insensitive in op support
  • 1fe9365 chore(prisma-adapter): only use mode with supported providers
  • b0465f6 chore(mongo-adapter): avoid insensitive queries on id or references
  • 9c8ba3e chore(prisma-adapter): remove cockroach from prisma

📊 Changes

27 files changed (+1176 additions, -95 deletions)

View changed files

📝 .cspell/tech-terms.txt (+1 -0)
📝 e2e/adapter/test/adapter-factory/index.ts (+1 -0)
📝 e2e/adapter/test/drizzle-adapter/adapter.drizzle.mysql.test.ts (+6 -0)
📝 e2e/adapter/test/drizzle-adapter/adapter.drizzle.pg.test.ts (+2 -0)
📝 e2e/adapter/test/drizzle-adapter/adapter.drizzle.sqlite.test.ts (+2 -0)
📝 e2e/adapter/test/kysely-adapter/adapter.kysely.mysql.test.ts (+6 -0)
📝 e2e/adapter/test/kysely-adapter/adapter.kysely.pg.test.ts (+2 -0)
📝 e2e/adapter/test/kysely-adapter/adapter.kysely.sqlite.test.ts (+2 -0)
📝 e2e/adapter/test/memory-adapter/adapter.memory.test.ts (+2 -0)
📝 e2e/adapter/test/mongo-adapter/adapter.mongo-db.test.ts (+2 -0)
📝 e2e/adapter/test/prisma-adapter/prisma.mysql.test.ts (+6 -0)
📝 e2e/adapter/test/prisma-adapter/prisma.pg.test.ts (+2 -0)
📝 e2e/adapter/test/prisma-adapter/prisma.sqlite.test.ts (+13 -0)
📝 packages/core/src/db/adapter/factory.ts (+2 -0)
📝 packages/core/src/db/adapter/index.ts (+8 -0)
📝 packages/drizzle-adapter/src/drizzle-adapter.ts (+164 -4)
packages/drizzle-adapter/src/query-builders.ts (+66 -0)
📝 packages/kysely-adapter/src/kysely-adapter.ts (+42 -1)
packages/kysely-adapter/src/query-builders.ts (+58 -0)
📝 packages/memory-adapter/src/memory-adapter.ts (+37 -4)

...and 7 more files

📄 Description

No description provided


🔄 This issue represents a GitHub Pull Request. It cannot be merged through Gitea due to API limitations.

## 📋 Pull Request Information **Original PR:** https://github.com/better-auth/better-auth/pull/8556 **Author:** [@jonathansamines](https://github.com/jonathansamines) **Created:** 3/11/2026 **Status:** 🔄 Open **Base:** `canary` ← **Head:** `feat/add-case-insensitive-ops` --- ### 📝 Commits (10+) - [`8985eca`](https://github.com/better-auth/better-auth/commit/8985eca1aeb0cfda25402de14d05e8cfe25331d0) chore(core): add support for case insensitive queries - [`c8053d5`](https://github.com/better-auth/better-auth/commit/c8053d55783cd39414c9d92936ed43ca47ae3cc1) chore(e2e): add test suite for case insensitive queries - [`b45dcb5`](https://github.com/better-auth/better-auth/commit/b45dcb57a748197fa845b0e6d76e4228faa5e375) chore: add to spell dictionary - [`d582472`](https://github.com/better-auth/better-auth/commit/d5824724e23231cac4880d1bcb792a8d6ebc554d) chore(core): fix memory adapter ops over non-string values - [`8701bb5`](https://github.com/better-auth/better-auth/commit/8701bb5a7f9c4967aff06ac5a5e6d348408ad7c6) chore(drizzle-adapter): handle empty arrays at in operations - [`2919aee`](https://github.com/better-auth/better-auth/commit/2919aee0adf3b21f822a0d6eec026834c2ed54df) chore(mongo-adapter): add support for empty in operations - [`bd5def4`](https://github.com/better-auth/better-auth/commit/bd5def4111efd8962d6243b796159a0df61d929a) chore(kysely-adapter): restore single value insensitive in op support - [`1fe9365`](https://github.com/better-auth/better-auth/commit/1fe936578f3296c2b8f00e399b095288f0766a11) chore(prisma-adapter): only use mode with supported providers - [`b0465f6`](https://github.com/better-auth/better-auth/commit/b0465f69f6156aecf97e2831d13133e1dcb054b4) chore(mongo-adapter): avoid insensitive queries on id or references - [`9c8ba3e`](https://github.com/better-auth/better-auth/commit/9c8ba3ec006921dc0b93d5aed79f6e43b921d2b7) chore(prisma-adapter): remove cockroach from prisma ### 📊 Changes **27 files changed** (+1176 additions, -95 deletions) <details> <summary>View changed files</summary> 📝 `.cspell/tech-terms.txt` (+1 -0) 📝 `e2e/adapter/test/adapter-factory/index.ts` (+1 -0) 📝 `e2e/adapter/test/drizzle-adapter/adapter.drizzle.mysql.test.ts` (+6 -0) 📝 `e2e/adapter/test/drizzle-adapter/adapter.drizzle.pg.test.ts` (+2 -0) 📝 `e2e/adapter/test/drizzle-adapter/adapter.drizzle.sqlite.test.ts` (+2 -0) 📝 `e2e/adapter/test/kysely-adapter/adapter.kysely.mysql.test.ts` (+6 -0) 📝 `e2e/adapter/test/kysely-adapter/adapter.kysely.pg.test.ts` (+2 -0) 📝 `e2e/adapter/test/kysely-adapter/adapter.kysely.sqlite.test.ts` (+2 -0) 📝 `e2e/adapter/test/memory-adapter/adapter.memory.test.ts` (+2 -0) 📝 `e2e/adapter/test/mongo-adapter/adapter.mongo-db.test.ts` (+2 -0) 📝 `e2e/adapter/test/prisma-adapter/prisma.mysql.test.ts` (+6 -0) 📝 `e2e/adapter/test/prisma-adapter/prisma.pg.test.ts` (+2 -0) 📝 `e2e/adapter/test/prisma-adapter/prisma.sqlite.test.ts` (+13 -0) 📝 `packages/core/src/db/adapter/factory.ts` (+2 -0) 📝 `packages/core/src/db/adapter/index.ts` (+8 -0) 📝 `packages/drizzle-adapter/src/drizzle-adapter.ts` (+164 -4) ➕ `packages/drizzle-adapter/src/query-builders.ts` (+66 -0) 📝 `packages/kysely-adapter/src/kysely-adapter.ts` (+42 -1) ➕ `packages/kysely-adapter/src/query-builders.ts` (+58 -0) 📝 `packages/memory-adapter/src/memory-adapter.ts` (+37 -4) _...and 7 more files_ </details> ### 📄 Description _No description provided_ --- <sub>🔄 This issue represents a GitHub Pull Request. It cannot be merged through Gitea due to API limitations.</sub>
GiteaMirror added the pull-request label 2026-03-13 13:58:43 -05:00
Sign in to join this conversation.
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: github-starred/better-auth#8061