From my experience generating db models/SQL schema at my last job, it did a fine job based on existing patterns and the outlined requirements. Point to note, we did optimise our AI prompts and LLM rules a lot, to the point we were able to get end to end unit tested, functional PRs out rather quickly