I’m not sure if I have the query right yet, but I think it might be this:
INSERT INTO moderator_post_views (post_id, user_id, last_viewed)
SELECT id, 1, make_date(2019, 4, 25) FROM posts;
If no one who might know sees this, I’m going to backup before running it and hope for the best. 