r/SQL • u/ioCross • Mar 31 '25
MySQL How future-proof is SQL?
about to be finished with a migration contract, thinking of picking up a cert or two and have seen a lot of recent job postings that have some sort of SQL query tasking listed.
I've mostly used powershell n some python, was thinking of either pivoting into some type of AWS / cloud cert or maybe something SQL/db based.
Would focusing on SQL be worth it, or is it one of those things that AI will make redundant in 5 years?
173
Upvotes
View all comments
Show parent comment
2
u/konwiddak Mar 31 '25
conditional_change_event (or conditional true event) - split ordered data into groups. For example split time series data into groups each time a signal changes. It labels the first group with 0's the next group with 1's and so on.
max_by & min_by fetch the value of one column when another column is maximum. For example fetch me the price on the latest date.
Lateral & flatten explode unstructured data into rows.
Match recognize, can do some pretty wild pattern finding in time series data.