ChatGPT has been spot on for my DDLs. I was working on a personal project and was feeling really lazy about setting up a postgres schema. I said I wanted a postgres DDL and just described the application in detail and it responded with pretty much what I would have done (maybe better) with perfect relationships between tables and solid naming conventions with very little work for me to do on it. I love it for more boilerplate stuff or sorta like you said just getting me going. Super complicated code usually doesn’t work perfectly but I always use it for my DDLs now and similar now.
The real problem is when people don’t realize something is wrong and then get frustrated by the bugs. Though I guess that’s a great learning opportunity on its own.
Imagine how bad it’ll get with generative AI only getting better. Think about someone like Linus Tech Tips getting hacked and an AI video getting uploaded of him telling his users to go sign up for a chance to win some $5000 PC “we’re giving 500 away!” and that site which won’t even have to look like anything other than “someMadeUpBrand.com/giveaway/linus”. It’s crazy to even think about how many people would fall for that shit. If the AI is good enough I might fall for it and I’m pretty damn good at catching it (for now).