Comment by zbentley

That comes across as arrogant and rude. Assuming you actually want to engage, I discussed some of the reasons that this can be hard here: https://www.scattered-thoughts.net/writing/against-sql

Particularly relevant is the part of that link which discusses having to pervasively refactor queries to add even a simple synthetic join or computed column. That’s a pain in the ass even for experienced DBAs, and is fundamentally not time well spent for row-at-a-time cases that are often, as you said, simple CRUD.

Are you sure you aren’t overfitting based on working on only one small, simple subset of the things people commonly use SQL for?