Convert all tests from XCTest to SwiftTesting (#198)

* Update CI and docs theme

* Require Swift 6.1, enable InternalImportsByDefault, choose most performant version of StringProtocol.replacing(_:with:) based on platform

* Convert all tests from XCTest to SwiftTesting

Allow generic upsert conflict resolutions (#197)

* Clean up all the docs warnings, update CI

* Enable specifying an INSERT's conflict resolution strategy as a generic SQLExpression

* Make SQLConflictUpdateBuilder's initializer public so it can be reused.

Update to Swift 6 (#196)

* Update to Swift 6

* Add missing flags

* Update api-docs.yml

* Update test.yml

* Address reviews

* Nits

* Comment out breaking option

* Update Package.swift

---------

Co-authored-by: Gwynne Raskind <[email protected]>

Fix SendableMetatype-related warnings which appear in Swift 6.2 (#193)

Resolve issues breaking Swift Wasm builds for sql-kit (#190)

* fix: Resolve issues breaking wasm build in sql-kit. Needed to require a newer version of swift-nio that supports wasm, and needed to narrow scope from the broad NIO dependency to the true dependency of just NIOCore.

* fix: Don't require a bump in the minimum swift-nio version.

Those compiling for wasm will need to find their own version of nio that compiles to wasm. In the near future, most latest versions of nio will compile to wasm, so this shouldn't be an issue.

* refactor: Only elide the full NIO dependency if WASI is the target platform. Otherwise, leave exports and dependencies unchanged to minimize any disruption to downstream dependencies.

* chore: Update minimum required version of swift-nio to 2.84.0, which is a release containing the latest wasm compilation fixes.

* ci: Adds wasm build to CI.

* chore: Clean out backwards compatibility provisions for NIO implicit dependencies. Latest testing indicates this won't be breaking to scope down to just NIOCore.

Add the missing `SQLDatabase.alter(table: any SQLExpression)` method (#…

…188)

* Bump Swift minimum to 5.10 and update README accordingly.

* Fix a number of minor API docs issues found by the latest DocC

* Add the missing `SQLDatabase.alter(table: any SQLExpression)` method

* Update CI

Adds multirow insert method (#153)

* feat: Adds multirow insert method

Fix behavior of SQLColumn when "*" is specified as a column name (#181)

Fix behavior of SQLColumn when "*" is specified as a column name (this behavior belonged in SQLColumn, not in SQLUnqualifiedColumnListBuilder) and add tests. Fixes #180.

Add support for Common Table Expressions (#179)

* Add support for Common Table Expressions to SELECT, INSERT, UPDATE, DELETE, and UNION queries, including subqueries. Test and docs coverage is 100%.
* Address (silly) warnings coming from the Swift 6 compiler
* Fix grouping level when a union subquery is used with a CTE
* Add a couple of real-world CTE queries to tests

Support the use of unions in subqueries (#178)

* Bump dependency versions, remove irrelevant language feature flags
* Add somewhat hackneyed support for using unions in subqueries. Thanks to bad design choices in the original union support (my bad), this turns out to be mildly annoying to actually use and extremely painful to follow in the actual implementation.