1-- Retrieves a user's ID and password hash from their registration 2-- number for authentication purposes. 3select 4 u.id, 5 u.password_hash, 6 u.user_role 7from public.user_account as u 8where u.registration = $1;