Password expiry is broken in mysql.user view

mysql.user view is set to always return 'N' in password_expired column

'N' AS `password_expired

As a result any tool that query mysql.user.password_expired column for expired passwords will be broken contrary to what https://mariadb.com/kb/en/authentication-from-mariadb-104/ says:
"Tools that analyze the mysql.user table should continue to work as before."

mysql.user should instead extract information from mysql.global_priv.Prv with JSON_VALUE(Priv, '$.password_lifetime')