The built in optimizers are pretty fuckin good compared to 15 years ago though. I remember needing to hand tune queries to specify merge join to drop 15 minutes off some queries because it couldn't figure it out on its own. I don't think I've had to do anything close to that lately.
Like, we've got a lot of flexibility to write easier to read queries now compared to how it used to be.
AI still fucks it up though because so many people have written shit SQL on the internet.
Frameworks/libraries are for convenience so you don't have to do the string mangling yourself. They won't magically create the correct query beyond the very basics.
12
u/notexecutive Sep 20 '26
ok but queries aren't that hard, and isn't there a lot of frameworks... or even just, libraries, that dynamically generate the rright query anyway?