create or replace view hivemq_to_mosquitto_auth_v as select username, 'PBKDF2$' || lower(algorithm) || '$' || password_iterations || '$' || password_salt || '$' || "password" as pw from users;