I remember doing a presentation about how SQL would remove the need for programmers to be involved in the process at all.

I’m a developer whose experience with SQL is limited to writing basic queries, window functions and combining those with CTEs.

All my business logic is written in a highly expressive language. It’s conveniently easy to read, change, and test.

And still, I’d like to learn how to implement complex business logic within the realm of my database so I can use it when appropriate.

What resources would you recommend for learning and practicing to write business logic in SQL, including good practices and testing?

The problem with SQL is not SQL itself, but how it integrates with modern programming languages. It’s the gap that it’s painful. My SELECT query is very elegant, but if it takes tons of custom code or even a library to transform the resulting rows in objects in the PL of choice, well then the elegance is worthless.

If the world could do normalisation...

I don't want to normalise the world. A new generation born, a new generation figuring out how to throw a ball, tie shoe laces, but not store data in a flat table.

since you like it so much, you should check other 4GL languages...SQL is not the only one

https://en.wikipedia.org/wiki/Fourth-generation_programming_...