This is my experience. As a data engineer with years in my current role I can get AI to write good SQL that correctly answers questions or defines metrics. At worst it may take a few back and forths to really nail it.

However, if a PM tries it they will more often than not get a wrong answer because they do not know what to look for or how to ask the right questions.

Prompts still matter a lot especially when you are working in an established enterprise.