We have had compile-time checks on SQL in Scala for years, I believe slick 3 (https://scala-slick.org/ https://scala-slick.org/) was the pioneer in the language

We have had compile-time checks on SQL in Scala for years, I believe slick 3 (https://scala-slick.org/ https://scala-slick.org/) was the pioneer in the language. One detail that I really liked from Slick is that the compilation fails if your queries can't be performed against your database schema (think about missing columns, or wrong names or types). While compile-time checks can be very useful, in my experience, there is nothing like having small integration tests that run against a real database which can easily be mounted by docker.