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

Closed
opened 2026-04-15 22:39:23 -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: Merged
Merged: 3/23/2026
Merged by: @Bekacru

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


📝 Commits (10+)

  • aad897b chore(core): add support for case insensitive queries
  • 3dd1afa chore(e2e): add test suite for case insensitive queries
  • cde802c chore: add to spell dictionary
  • 66b8738 chore(core): fix memory adapter ops over non-string values
  • dc65030 chore(drizzle-adapter): handle empty arrays at in operations
  • d4c2305 chore(mongo-adapter): add support for empty in operations
  • ae6ac41 chore(kysely-adapter): restore single value insensitive in op support
  • 0152028 chore(prisma-adapter): only use mode with supported providers
  • b7f4121 chore(mongo-adapter): avoid insensitive queries on id or references
  • 9661441 chore(prisma-adapter): remove cockroach from prisma

📊 Changes

27 files changed (+1209 additions, -121 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 (+189 -26)
packages/drizzle-adapter/src/query-builders.ts (+66 -0)
📝 packages/kysely-adapter/src/kysely-adapter.ts (+50 -5)
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:** ✅ Merged **Merged:** 3/23/2026 **Merged by:** [@Bekacru](https://github.com/Bekacru) **Base:** `canary` ← **Head:** `feat/add-case-insensitive-ops` --- ### 📝 Commits (10+) - [`aad897b`](https://github.com/better-auth/better-auth/commit/aad897b025c466ead937c73ff063fab2d4daa476) chore(core): add support for case insensitive queries - [`3dd1afa`](https://github.com/better-auth/better-auth/commit/3dd1afa3dabf5a16dbcbf2e2d61908f9dc53fa88) chore(e2e): add test suite for case insensitive queries - [`cde802c`](https://github.com/better-auth/better-auth/commit/cde802c36738c193b63d78023b68e7d4ac5bbfa8) chore: add to spell dictionary - [`66b8738`](https://github.com/better-auth/better-auth/commit/66b87380a23ada16e265a5bc34afe2b2557f2c9d) chore(core): fix memory adapter ops over non-string values - [`dc65030`](https://github.com/better-auth/better-auth/commit/dc650309db325ea51769bdb311463df9b57721bc) chore(drizzle-adapter): handle empty arrays at in operations - [`d4c2305`](https://github.com/better-auth/better-auth/commit/d4c2305b4fc2d5556413c86a7fea77c2dff34aa6) chore(mongo-adapter): add support for empty in operations - [`ae6ac41`](https://github.com/better-auth/better-auth/commit/ae6ac41e23d112886634daaf3431fa9c23b225d0) chore(kysely-adapter): restore single value insensitive in op support - [`0152028`](https://github.com/better-auth/better-auth/commit/0152028f285cb06d04a9a172cbed9d3d077a51a7) chore(prisma-adapter): only use mode with supported providers - [`b7f4121`](https://github.com/better-auth/better-auth/commit/b7f4121cac0471d77263ca2e1cdf5b90d1886414) chore(mongo-adapter): avoid insensitive queries on id or references - [`9661441`](https://github.com/better-auth/better-auth/commit/9661441b2794a00e943e7b8937c565a0b38985e8) chore(prisma-adapter): remove cockroach from prisma ### 📊 Changes **27 files changed** (+1209 additions, -121 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` (+189 -26) ➕ `packages/drizzle-adapter/src/query-builders.ts` (+66 -0) 📝 `packages/kysely-adapter/src/kysely-adapter.ts` (+50 -5) ➕ `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-04-15 22:39:23 -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#24961