v0.23.0

What's Changed

• Modularised and added Oracle and SQL Server backends by @milessabin in #675

  • Split sql module into sql-core and sql-pg, the latter containing Postgres specfics shared by doobie-pg and skunk.
  • Split off doobie-core from doobie-pg removing all Postgres specfics from the former.
  • Factored out all Postgres specifics from SqlMapping.
  • Added Oracle backend.
  • Added SQL Server backend.
  • Reduced the use of lateral subqueries to a minimum.
  • Simplified SqlSelect nesting logic.
  • Avoid nested conditions being captured by predicate subqueries.
  • Replaced whale-tail with call outs to docker-compose allowing container to be shared by all suites across multiple test runs.

  Running tests (eg. rootJVM/test) will automatically spin up the relevant containers, which will stay up and can be reused across multiple tests runs, significantly speeding up the test cycle. I recommend running allUp initially, to pull images and initialise databases, before running tests the first time. Note that Oracle in particular takes quite a long time to initialise, so expect allUp to take several minutes to complete the first time around.

  There have been some changes in compilation of queries for Postgres, primarily a reduction in the usage of lateral subqueries (partly to simplify the implementation for SQL Server, which has a subtly different mechanism for achieving similar effects). These changes should preserve expected results, and reports of any changes in behaviour, including performance regressions, would be very much appreciated.

Updates

• Added checks for exit code 0 by @phdoerfler in #679
• Update sbt-typelevel, sbt-typelevel-site to 0.7.4 by @typelevel-steward in #664
• Update sbt-scoverage to 2.2.2 by @typelevel-steward in #668
• Update http4s-circe, http4s-dsl, ... to 0.23.29 by @typelevel-steward in #670
• Update logback-classic to 1.5.12 by @typelevel-steward in #671
• Update sbt-buildinfo to 0.13.1 by @typelevel-steward in #677
• Update cats-effect to 3.5.7 by @typelevel-steward in #682
• Update sbt, scripted-plugin to 1.10.6 by @typelevel-steward in #683

Full Changelog: v0.22.0...v0.23.0