I do use ChatGPT very often for Python and SQL right now, but you really have to know what you are doing. The errors are sublte but such that the code more often than not would not run.
But know that in the future, ChatGPT will be hooked up to a runtime system and compiler with which it can know how to fix errors itself. In fact, plugins already allow some of this.