[toomanydoubts]

>So changing a column name or type, for example, is pretty easy to refactor, which may not be true for SQL queries and may take significant testing.

You can also get that with raw sql on the right ecosystem. I once developed a simple application using hasql and hasql-th(on Haskell). Very close to raw sql strings but with type checking at compile time. Feels like you're driving a lambo.

[roflyear]

I'll have to check that out. Languages I use don't have that type of tooling that I'm aware of :)

Have used Haskell before, but... far from extensively!