I’m trying to have my posts published when wp_posts.ID IN (list).
Is it advisable to do it with an event in MySQL/MariaDB?
Would it mess up the cache?
Is it enough to just do

SET
posts_status = 'publish'
WHERE
wp_posts.ID IN (list)

?
I found one answer that could be the solution here https://wordpress.stackexchange.com/a/313060/151436
but I’m not really sure how to implement it.

Also, it would be great if a solution had like a minute gap between publishing, so it doesn’t slow down the server.

Any help would be greatly apriciated!
Thank you