The markdown parsing is broken/disabled for release notes. Sorry about that, I'm chasing the source of a crash that's been bringing this website down for the last couple of days.
Add support for MySQL's DROP INDEX syntax
3 weeks ago
###### _This patch was authored and released by @gwynne._
MySQL's version of `DROP INDEX` differs from PostgreSQL's in that it requires an `ON <table name>` clause in order to identify the index to drop, since MySQL treats indexes as table-level objects rather than schema-level. This PR adds support for optionally specifying the table name.
Also deprecates `SQLDataType.type(_:)`, which should never have been public - it is a utility method used in one place by a single test case; its behavior is only valid in PostgreSQL, and even then only for custom-typed enums, but its name and placement give no hint of this to callers. Since it is public API, it can not be summarily removed without a `semver-major` break, but we can at least remove the single call site and discourage any further use.
Also updates the CI workflows as per the usual in my PRs 🙂.
_Note: `semver-minor` not only due to the new public API on `SQLDropIndexBuilder` but also because the deprecation of a public API is, while not source-breaking, annoying for anyone who actually used it._
Adds `ALTER _ RENAME TO _` support
5 weeks ago
###### _This patch was authored by @NeedleInAJayStack and released by @0xTim._
<!-- 🚀 Thank you for contributing! -->
<!-- Describe your changes clearly and use examples if possible. -->
Adds table-renaming support to `SQLAlterTableBuilder`. This produces SQL queries of the form:
```sql
ALTER `table_name` RENAME TO `new_table_name`
```
<!-- When this PR is merged, the title and body will be -->
<!-- used to generate a release automatically. -->
Fix several issues with UNION query support
22 weeks ago
###### _This patch was authored and released by @gwynne._
- Fixes `SQLUnionBuilder` lacking `SQLQueryFetcher` conformance.
- Fixes support for SQLite.
- Adds support for `INTERSECT [DISTINCT|ALL]` and `EXCEPT [DISTINCT|ALL]` unions.
- Adds documentation for `SQLDialect` and its subtypes.
- Improves test infrastructure.
Add support for UNION queries
23 weeks ago
###### _This patch was authored by @finestructure and released by @gwynne._
Adds support for `UNION SELECT` queries:
```swift
try db.select()
.column("id")
.from("t1")
.where("f1", .equal, "foo")
.limit(1)
.union({
$0.column("id")
.from("t2")
.where("f2", .equal, "bar")
.limit(2)
}).union(all: {
$0.column("id")
.from("t3")
.where("f3", .equal, "baz")
.limit(3)
})
.run().wait()
```
Add support for `CREATE TABLE ... SELECT ...`
24 weeks ago
###### _This patch was authored and released by @gwynne._
Adds SQLKit support for creating tables populated by `SELECT` queries:
```swift
try await sqlDatabase.create(table: "populated")
.column("id", type: .bigint, .primaryKey, .notNull)
.column("data", type: .text)
.select { $0
.column(SQLLiteral.default, as: "id")
.column(SQLFunction("UPPER", args:
SQLFunction("LTRIM", args: SQLColumn("data"))
), as: "data")
.from("original_table")
.where("id", .in, Array(1 ... 10))
}
.run()
```
```sql
CREATE TABLE "populated" (
"id" BIGINT PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY NOT NULL,
"data" TEXT
) AS SELECT
DEFAULT AS "id",
UPPER(LTRIM("data")) AS "data"
FROM
"original_table"
WHERE
"id" IN ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10)
```
Additional changes:
- Significant internal reorganization of SQLKit, specifically in `SQLSelectBuilder`.
- The `.where()`, `.orWhere()`, `.having()`, and `.orHaving()` families of methods on `SQLSelectBuilder` (and other `SQLPredicateBuilders`) have been normalized so that all four sets of methods offer the same series of overloads as all the others.
- More `async` tests.
- Support for MySQL's `DROP TEMPORARY TABLE` syntax, as `sqlDatabase.drop(table: "table").temporary()`.
Note: Despite what may seem appearances to the contrary, the public API of `SQLSelectBuilder` has not lost any methods, though it has gained a small number of overloads. A concerted effort was made to avoid changing any existing API in any source-incompatible way.
Fix Swift compiler choosing wrong overload for SQLInsertBuilder.values(Encodable)
24 weeks ago
###### _This patch was authored and released by @gwynne._
Under certain specific circumstances, the Swift compiler will choose the wrong overload of `SQLInsertBuilder.values(_:)` for the variants that take `Encodable` (specifically when an explicit Array is used in a generic context). Since it's too late to fix the API (it's public now), adding @_disfavoredOverload works around the issue in what should be a backwards-compatible fashion.
Add Concurrency extensions for SQLKit
25 weeks ago
###### _This patch was authored and released by @gwynne._
Shockingly little effort required here! SQLKit doesn't do very much asynchronous work, in and of itself.
MySQL chokes on supplemental plane Unicode
30 weeks ago
###### _This patch was authored and released by @gwynne._
So don't use it in the benchmarks. Sigh.
Support for UPSERT/conflict resolution clauses
30 weeks ago
###### _This patch was authored and released by @gwynne._
Currently, the emitted syntax is compatible with SQLite and PostgreSQL, but not MySQL. Because MySQL diverges radically from the standard, considerable additional work would be needed to support it. Some design flaws still exist in this implementation, but it is possible to specify all of the common clauses needed for `UPSERT`. There is no support for SQLite's `ON CONFLICT ROLLBACK/ABORT/FAIL/IGNORE/REPLACE` syntax, nor for any of the more esoteric clauses supported by PostgreSQL. It doesn't seem useful to add that support; it's unlikely that a query requiring such specialized facilities would be portable across databases in any event.
Add convenience extensions to simplify some common use cases
31 weeks ago
###### _This patch was authored and released by @gwynne._
I mean, I could go on adding methods like these to SQLKit for a week and not cover the entire API surface...