I asked it to generate a SQL query with a bit of python, as the database schema is huge and unknown to me, obviously I checked it for glaring errors etc. I went back and clarified a couple of basic points. It then told me what I was doing was completely wrong, generated new code that worked is a different way, with a different edge case missed.

It's literally stack overflow but arguing with itself

That's how you're writing a regex validator that's almost always correct!

def is_regex_valid(p: Pattern | str, purpose_description: str):
    return False