Is it possible to use views for login and also enable register end-point? I've successfully used views to login active users but the register endpoint is now throwing error.

<b>Fatal error</b>: Uncaught PDOException: SQLSTATE[HY000]: General error: 1471 The target table active_users of the INSERT is not insertable-into in ...

My view contains a join between the users table and roles table

select id, username, password,is_active, role_id from users left join roles on roles.id = users.role_id where is_active = 1and role_id <> 0

Originally posted by@dswdcares in#892 (comment)