Enhancement: Add API endpoint to query Auth user by email

[jczstudios]

Currently there's a gap in functionality when handling user registration flows where a user exists in Auth but fails to get registered in public tables.

Current Challenge:

• When signUp fails after creating Auth user but before creating public table entries
• No direct way to query Auth user by email to recover the user ID
• Makes it difficult to retry/recover the public table creation

Suggested Solution:

1. Add a secure API endpoint or RPC function to query Auth users by email
2. Return minimal user info (just ID) to maintain security
3. Require appropriate service role authentication

This would enable proper error recovery in registration flows while maintaining security.

Alternative approaches currently suggested:

• Using Postgres functions with security definer
• Using database triggers for user management
• Pre-checking email existence before signUp

A standardized API solution would provide better developer experience for this common use case.

[Hallidayo]

Hi @jczstudios - Thanks for opening this one, I'm going to move it over to a enhancement discussion so that is does not get missed.