## What's Changed See the [migration guide](https://github.com/pointfreeco/swift-structured-queries/blob/main/Sources/StructuredQueriesCore/Documentation.docc/Articles/MigrationGuides/MigratingTo0.31.md) for more details. * Fixed: Xcode 26.4 support (https://github.com/pointfreeco/swift-structured-queries/pull/271). * Fixed: Constrained an `order(by:)` overload had an incorrect signature (https://github.com/pointfreeco/swift-structured-queries/pull/267). * Deprecated: `==` and `!=` are now unavailable (https://github.com/pointfreeco/swift-structured-queries/pull/270). **Full Changelog**: https://github.com/pointfreeco/swift-structured-queries/compare/0.30.0...0.31.0

## What's Changed * Added: `notIn` operator for idiomatic `NOT IN` (https://github.com/pointfreeco/swift-structured-queries/pull/248). * Added: `@DatabaseFunction` can now be applied to computed properties (https://github.com/pointfreeco/swift-structured-queries/pull/249). **Full Changelog**: https://github.com/pointfreeco/swift-structured-queries/compare/0.26.0...0.27.0

## What's Changed * Added: Explicit `conformances` to member macros (https://github.com/pointfreeco/swift-structured-queries/pull/225). * Added: Conditional conformances for `Codable.JSONRepresentation` (https://github.com/pointfreeco/swift-structured-queries/pull/239). * Added: `jsonGroupArray` support for non-primary keyed tables (https://github.com/pointfreeco/swift-structured-queries/pull/243). * Fixed: Address a couple `@Selection`-based update bugs (thanks @rcarver, https://github.com/pointfreeco/swift-structured-queries/pull/233). * Infrastructure: Fix triggers documentation typo (thanks @tgrapperon, https://github.com/pointfreeco/swift-structured-queries/pull/236). * Infrastructure: Update Package.swift to use GitHub Action env var (https://github.com/pointfreeco/swift-structured-queries/pull/237; thanks @rcarver, https://github.com/pointfreeco/swift-structured-queries/pull/238) * Infrastructure: CI Updates (https://github.com/pointfreeco/swift-structured-queries/pull/242). * Infrastructure: Add `TableAlias` docs for selection decoding (https://github.com/pointfreeco/swift-structured-queries/pull/241). ## New Contributors * @tgrapperon made their first contribution in https://github.com/pointfreeco/swift-structured-queries/pull/236 **Full Changelog**: https://github.com/pointfreeco/swift-structured-queries/compare/0.25.2...0.26.0

## What's Changed * Added: You can now define you own aggregate functions (https://github.com/pointfreeco/swift-structured-queries/pull/207). **Full Changelog**: https://github.com/pointfreeco/swift-structured-queries/compare/0.23.2...0.24.0

## What's Changed * Fixed: Improve performance of macro-expanded code to avoid complex expression compilation sluggishness in larger tables (https://github.com/pointfreeco/swift-structured-queries/pull/196). **Full Changelog**: https://github.com/pointfreeco/swift-structured-queries/compare/0.22.0...0.22.1

## What's Changed * Added:: `createTemporaryView` now supports common table expressions (https://github.com/pointfreeco/swift-structured-queries/pull/176). * Added: Support `INSTEAD OF` triggers (https://github.com/pointfreeco/swift-structured-queries/pull/179). * Added: Support defaults in `@Selection.Columns.init` (https://github.com/pointfreeco/swift-structured-queries/pull/180). * Added: `PrimaryKeyedTable.find([id])` for finding multiple rows by primary keys (https://github.com/pointfreeco/swift-structured-queries/pull/181). * Fixed: Silence warning on Swift 6.0 (https://github.com/pointfreeco/swift-structured-queries/pull/183). * Fixed: Properly handle SQL comments in `#sql` macro diagnostics (https://github.com/pointfreeco/swift-structured-queries/pull/187). * Infrastructure: Update docs on temporary views (https://github.com/pointfreeco/swift-structured-queries/pull/182). **Full Changelog**: https://github.com/pointfreeco/swift-structured-queries/compare/0.20.0...0.21.0

## What's Changed * Added: A new, type-safe API for creating temporary views (https://github.com/pointfreeco/swift-structured-queries/pull/172). * Fixed: Make `join` overload consistent with other `join`s and omit `INNER` (https://github.com/pointfreeco/swift-structured-queries/pull/170). * Fixed: FTS5: Support outer joins and aliased tables by (https://github.com/pointfreeco/swift-structured-queries/pull/171). * Fixed: Swift Syntax 602 Support (https://github.com/pointfreeco/swift-structured-queries/pull/174). **Full Changelog**: https://github.com/pointfreeco/swift-structured-queries/compare/0.19.1...0.20.0

## What's Changed > [!IMPORTANT] > See [the migration guide](https://github.com/pointfreeco/swift-structured-queries/blob/main/Sources/StructuredQueriesCore/Documentation.docc/Articles/MigrationGuides/MigratingTo0.18.md) for more information. * Added: `Table.tableFragment` to enable basic virtual table syntax (https://github.com/pointfreeco/swift-structured-queries/pull/160, https://github.com/pointfreeco/swift-structured-queries/pull/161). * Fixed: Move SQLite functionality into the SQLite module (https://github.com/pointfreeco/swift-structured-queries/pull/157). * Fixed: Prefer explicit initialization in `selectStar` over bit-cast (https://github.com/pointfreeco/swift-structured-queries/pull/159). * Infrastructure: Fix sample snippet for ``Select/map(_:)`` (thanks @johankool, https://github.com/pointfreeco/swift-structured-queries/pull/158). ## New Contributors * @johankool made their first contribution in https://github.com/pointfreeco/swift-structured-queries/pull/158 **Full Changelog**: https://github.com/pointfreeco/swift-structured-queries/compare/0.17.1...0.18.0