Not aimed at the author but aimed at the whole concept... Let's look at the first example prompt in the article...
You are an SQL Server database developer. Assume you are working with the AdventureWorks2022 sample database. Write the SQL code to create a view named vwPersonDetails with columns Title FirstName, MiddleName, LastName, and JobTitle from the Person and Employee tables of HumanResources schema.
Including the single spaces, that took 294 characters of typing and esoteric memory of column and table names because there was no use of "intellesense" etc. "Look how easy that was"??? NOT easy compared to something like SQL Prompt or even (ugh!) Intellisense or even click'n'drag from the object explorer. It's easier to type a part of something and have SQL Prompt or Intellisense fill in the rest.
And, even if you didn't have any of that, the you still had to know all the names of the columns and tables and the prompt ended up being a total of 294 characters of typing instead of just the 247 in the code. And, guess what? You don't need to copy and paste the code to run it and you don't need to read an explanation because... you were smart enough to write it in the first place and it didn't take any more knowledge than to build that prompt. In fact, SQL Prompt or Intellisense probably wrote half the code for you.
AI just made extra work here. I'll put a good developer up against even themself and the one that doesn't us AI, is going to get it done first.