Clean Up Route Handlers

Refactor route handlers in app/api/* to simplify logic. Remove duplicated error handling, streamline GET/POST methods, and inline simple database queries. Use TypeScript`, ensure Supabase integration remains functional, and delete unused routes.