MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE projects (
  stars integer, 
  title varchar(255)
);

CREATE VIEW projects_view AS 
SELECT *, title AS name FROM projects;


INSERT INTO projects_view (name) VALUES (Name);

The target table projects_view of the INSERT is not insertable-into


CREATE VIEW projects_view2 AS 
SELECT stars, title as name FROM projects;
INSERT INTO projects_view2 (name) VALUES ('Name');
select * from projects


stars
title


null
Name