[BUG]: .eq("github_login", githubLogin) can cause problem

[rudrakshtank]

Bug Description

GitHub usernames are generally treated case-insensitively, and you already compare the primary account using .toLowerCase(). But the Supabase delete filter is case-sensitive, so deleting RudrakshTank may fail if the DB stored rudrakshtank.

Also, your params: Promise<{ githubLogin: string }> is fine for Next.js 15+, where dynamic APIs like params are async. For Next.js 14, it would usually be a plain object instead.

Steps to Reproduce

.ilike("github_login", githubLogin)

Affected Area

API Routes

Screenshots

No response

Browser & OS

No response

Environment

None

Additional Context

No response

[rudrakshtank]

I would like to work on this issue under GSSoC'26.

[github-actions]

Assigned to @rudrakshtank! You have 7 days to open a PR. No PR after 7 days = auto-unassigned so others can pick it up. Good luck!