Copilot may well be able to write the code but it can't decide what code needs to be written. Using your SQL statement as an example, writing a query might be

Copilot may well be able to write the code but it can't decide what code needs to be written. Using your SQL statement as an example, writing a query might be easy for a computer, but designing the table to hold the information in a way that's queryable is not. That's where the creativity lies. That's going to be very hard for a computer, or even a non-technical person using a computer, to replace.