Press "Enter" to skip to content

Don’t Retire Your SQL Skills Yet

If you are a SQL analyst/coder, you are probably thinking of raising the white surrender flag to AI. After all, AI can now create databases, tables, indexes, queries, and anything else in SQL you can think of. There’s just one problem: AI often doesn’t get things right when it produces code.

It fails often enough that people don’t trust the output. It fails often enough that companies hold employees or personnel responsible for the AI’s output.

Site owner may receive a commission from purchases made through links on this page, at no extra cost to you.

Based on that last sentence, since you are responsible and since AI can be unreliable, do you really want to trust letting AI do the work?

AI Creates Content Based on Its Training History

Much of AI’s training data comes from the Internet. Websites and web pages aren’t reliable, and AI will likely only realize that when pressed. AI often chooses the highest-probability option. Since much code isn’t written optimally or even correctly, AI will favor that code in many cases.

Related: Why Do Models Hallucinate?

There is more to how AI selects its output, but you don’t need to know that for this discussion. The main takeaway should be that you can’t trust AI’s output.

But that presents an interesting situation, doesn’t it? If you aren’t familiar with the output that AI produces, or you don’t understand how to code in SQL, where does that leave you? You’ll be taking a big chance in allowing AI to get it right, and you won’t know when to tell AI that it got it wrong.

A Delicate Balance

You needn’t become a SQL expert, but you will need enough chops to make sense of the AI-produced code. Obviously, the stronger your skill in this, the better. At the same time, the whole point of allowing AI to produce this code is so that you don’t have to know it at an expert level.

Why They Keep Telling Us That AI Will Replace Our Jobs

Right now, we’re still in the hype cycle of the AI boom. The cycle is shifting away from the inflated expectations stage, and we seem to be entering the disillusionment stage (companies are considering smaller models to save on inference costs, etc.) I would even say we may be at the Slope of Enlightenment stage, where we start to see productivity gains.

This said, our traditional jobs (including coding jobs) are going to change. We’ll likely wear the architect hat more than the coding hat, and we’ll also wear the QA hat. New hats will be defined, like Analytics Engineers, AI Specialists, and a host of others yet to be defined. Most will require some SQL and database knowledge.

When to Raise the White Flag

I believe we will know it is game over when all the training companies stop offering SQL training. They’ll shift to skills more aligned with orchestrating workflows and pipelines, monitoring performance, and aligning business rules with the AI.

Until then, though, it pays for you to understand how SQL works and determine how far down the rabbit hole of learning you want to go. As long as training vendors offer training on those skills, you can decide what works best for your needs.

Be First to Comment

Leave a Reply

Your email address will not be published. Required fields are marked *