I really disagree, a major function of education is to teach concepts before introducing tools. I took a physics class in undergrad that required a graphing calculator, does that mean I wasted years learning all of the mathematical concepts that could be performed by a graphing calculator?
Having an understanding of what's going on is so important, especially when something is broken. If we encourage students to start with AI and not learn the fundamentals themselves, they won't wind up learning how to identify root cause when the tool causes an issue (and ChatGPT is by no means perfect).
If they successfully use ChatGTP to do this, they likely have engaged with the text.
Using ChatGPT to generate something that you can't independently verify is a terrible idea. Most of the time it'll be fine, but when it's not you need to be able to recognize the flaws. Hopefully you at least test it before pushing, but if you don't know how to write the query you also don't know its failure modes, so your tests will likely miss important edge cases.
AI tools are great for speeding up processes you can do by hand, but because they're all statistics you can't count on them to do it alone: some percentage of the time they will inevitably be wrong.
EDIT: Note that this stands in contrast to a wholly deterministic tool like a calculator, which in most circumstances doesn't need to be second guessed.
It depends. A calculator can calculate things I'd struggle to independently verify with a pen and paper.
I think I wasn't clear enough and you might be taking what I said to it's extreme. I'm not suggesting there is zero value in knowing SQL, I'm saying the value of learning it is now much lower than when I learnt it. While it might be helpful to have a good understanding of SQL to verify a query yourself (especially where performance is a concern), in most cases this likely isn't necessary. For your average select query with a couple of joins and a where clause ChatGPT can generate that and you can verify it at least works by running it.
But maybe SQL isn't the best example. It just came to my mind because I was writing a spatial query for MariaDb recently and I couldn't get the results I wanted after a few Google searches, but ChatGPT got it right first time. It seems to me that query languages have a lot of properties which make ChatGPT very good at writing them, but there are probably other skills which ChatGPT more clearly erodes the value of.
I would imagine writing is similar - the endless essays full of bullshit I pumped out in high school were obviously pointless. But being forced to write much earlier in school was super foundational for having the skill in the first place.
As to the SQL example, I also think it’s flipped - learning the basic sql queries is probably the most valuable as it’s a foundation.
Assuming the teacher is doing their job, it should be really easy to make sure nobody is cheating using machine learning.
True in university, but memorizing multiplication tables and learning the mechanics of long division and multiplication are important parts or math education for kids. Most of school is not strictly for "real world" skills anyway (even if doing basic math unaided is almost as close as we come in school to teaching a real world skill).
Same goes for say, basic reading comprehension and summarization.
I don't buy your argument
Learning multiplication tables in school is important. Yes a calculator can tell you what 6 x 8 is, but any competent adult ought to be able to figure that out on their own as well, or 20 x 5,000. Numerical literacy is important.
Similarly, basic writing skills are incredibly important. Just because they can be faked with ChatGPT in response to a standardized prompt doesn't mean they're not useful. We train with standardized prompts in school so that in the real world we can write in new situations.
And in my experience, I wish most developers learned more SQL is school. SQL is mainly about avoiding a lot of pitfalls, especially with regards to your specific table and index structure and sharding strategy, and ChatGPT is utterly useless with regards to that.
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.
In most cases the courses are fine, but the examination probably isn't testing anything useful if it can be cheated with tools like ChatGPT. For example any maths test which only tests students on problems which are easily solvable by a calculator isn't testing any skill of real world use. But this doesn't mean maths itself isn't valuable, just that the test isn't.
In some cases like programmers and writers, ChatGPT might actually be eroding the value the current curriculum. For example, I'm not sure if there's much value in learning things like basic SQL queries anymore which was something I had to learn when studying computer science. ChatGPT is great at writing SQL queries if you're able to tell it exactly what you need.