This would replace the skill of SQL with the skill of being able to ask specific questions which is a valuable skill, also when collaborating with humans.

At the same time it is a completely different mode to operate. Writing and editing SQL while you are trying to solve a problem will lead you to a different way of thinking, iterating, maybe even induce fewer context switches.

Using ChatGPT can be similar to delegating those type of tasks to a colleague. There are upsides and downsides to this but never underestimate the benefits of strengthening your own abilities.