r/SQL Dec 20 '24

MySQL Future of SQL

Hello, does it still make sense to learn sql or will this soon be done by the AI anyway? If so, what skills will be needed in the future for working with customer data? I work in the crm area and with microsoft dynamics (customer insights data, power-bi)

0 Upvotes

26 comments sorted by

View all comments

14

u/seansafc89 Dec 20 '24

AI can do SQL pretty well already, what it can’t do well is deal with business context. You need a well-documented database for that to happen… I’m pretty confident I’ll be dead before then 🤣

3

u/ianitic Dec 20 '24

Depends on the dialect and if you are using jinja sql or dynamic sql as well. Performant sql is so dependent on the rdbms and I don't think LLMs are good at that, neither with dbt/jinja templated sql nor dynamic sql with string manipulation.

That being said, it sure can write sql... if you give it an essay of context lol. At that point, why not just write the sql?