@manton "I need a query that can delete a set of blogposts based on conditions as i will now explain. we're concerned with all the posts on the most recent day of posts in the database. i will provide a list of datetime values of whenCreated values for posts on that day that should not be deleted. all posts on that day who are not on the list should be deleted."
that's a prompt i wrote yesterday. it understood and the code it wrote didn't run because it used an SQL feature that wasn't in MySQL. i pointed that out and it wrote a more complex query using joins that did work. i never would have been able to write that code, not even come close to it.