From the maintainer Li Haoyi: I'm putting a 1000USD bounty on this issue, payable by bank transfer on a merged PR implementing this.

This should be relatively straightforward to add as a new dialect next to Postgres, MySQL, H2, and Sqlite. It should cover as much of the ScalaSQL API as possible, with exceptions or unsupported functionality marked with explanation comments in https://github.com/com-lihaoyi/scalasql/blob/main/scalasql/test/src/ConcreteTestSuites.scala. Tests should follow the existing pattern, and I believe TestContainers which we use for postgres and mysql should already have SQL server containers ready to go