Ideal way to store user passwords in Supabase

[rdong8]

What would be the best way to store password-like data in Supabase? Specifically I have a user data table indexed by integer user IDs, I'd like to associate some password-like data to each of these users. Would the encryption at rest be enough to just store the password in a string column of this table? Or should I use Vault? Important to note that the "password" itself is custodied by the application in my case, it is not sufficient to store a hash.