Ask HN: How do you test SQL?

Post by indymike » Fri, Feb 03, 2023, 8:47 PM UTC

spamtarget wrote: post #309

indymike wrote: post #298

Earlier quoted context omitted.

Further, another way to look at it is, declarative languages specify output, imperative languages focus on the steps to generate outputs. In imperative code, I'm worrying about how instead of what. In declarative code, I'm worried about what instead of how. As in all things, neither of these statements will be absolutes - there are situations and times where a declarative language user will worry about how the query…

>neither of these statements will be absolutes - there are situations and times where a declarative language user will worry about how the query planner will execute, and there are times where an imperative language user will write very much declarative code. That's right, in practice everything is more like a mishmash of everything. Your function library could be seen as a declarative language over the top of a gene…