Enhancement: Add API endpoint to query Auth user by email

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 …