Provide one-way or cryptographic hash functions

Provide one-way or cryptographic hash functions, such as any of the MD5, SHA-1, SHA-2, or SHA-3 functions, so that views can define columns that are hashes of other columns.

The goal is to allow views to hide some columns (e.g., personally identifying information), but to expose a new "primary key" that is a hash of other existing columns. So, given this source table:

CREATE TABLE person (
  id INT PRIMARY KEY,
  name VARCHAR(256) NOT NULL,
  age INT,
  height INT,
  weight DOUBLE
);

a view could be created to hide the personally identifying information:

CREATE VIEW anonymousPerson ()
  id VARCHAR(64) PRIMARY KEY,
  age INT,
  height INT,
  weight DOUBLE
) AS
   SELECT sha256(p.id, p.name) AS id, 
          p.age AS age, 
          p.height AS height, 
          p.weight AS weight 
          FROM person AS p;