I tried using an LLM to generate SQL across a messy legacy schema.

It worked surprisingly well — until it didn’t.
The biggest issue I hit wasn’t syntax. It was structurally incorrect JOIN paths that looked plausible.

Curious if others have seen similar issues in real systems.