mosquitto-with-auth/hivemq-to-mosquitto-auth-view.sql

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