--- title: "New in SQLiteData: Sectioned queries" url: https://daily.dev/posts/new-in-sqlitedata-sectioned-queries-0b5mroclg source_url: https://www.pointfree.co/blog/posts/219-new-in-sqlitedata-sectioned-queries type: article source: "Point-Free Pointers" published: 2026-07-27T17:53:16.322Z updated: 2026-07-27T17:53:39.881Z tags: ["backend", "swift", "swiftui", "sqlite"] reading_time: 8 upvotes: 0 comments: 0 language: en --- > ## Documentation Index > Fetch the complete documentation index at: https://daily.dev/llms.txt > Use this file to discover all available pages before exploring further. # New in SQLiteData: Sectioned queries **[Point-Free Pointers](https://daily.dev/sources/pointfree)** · 8 min read · 0 upvotes · 0 comments ## Summary SQLiteData 1.8.0 introduces sectioned queries via a new `sectionBy:` argument on `@FetchAll`, allowing developers to group query results into named sections using any SQL expression — not just key paths of string properties. Unlike SwiftData's sectioning (restricted to modern Apple OSes and string key paths), SQLiteData's approach works back to iOS 13, supports arbitrary SQL expressions including joins, NULL ordering, and descending clauses, and evaluates grouping directly in SQLite's ORDER BY clause rather than in memory. The release also brings `fetchAll(_:sectionBy:)` to `FetchKeyRequest`, enabling strongly-typed section names using any hashable value such as custom enums, avoiding stringly-typed parsing and impossible default cases. ## Full article daily.dev links to this article rather than hosting it. Read it at the original source: ## Similar posts on daily.dev - [New in SQLiteData: Column groups and inheritance](https://daily.dev/posts/new-in-sqlitedata-column-groups-and-inheritance-lfhlrw9xs) · Point-Free Pointers · 1 upvotes · 0 comments - [SQLiteData 1.0: An alternative to SwiftData with CloudKit sync and sharing](https://daily.dev/posts/sqlitedata-1-0-an-alternative-to-swiftdata-with-cloudkit-sync-and-sharing-0qm5wyzo4) · Point-Free Pointers · 1 upvotes · 0 comments --- Tags: [#backend](https://daily.dev/tags/backend), [#swift](https://daily.dev/tags/swift), [#swiftui](https://daily.dev/tags/swiftui), [#sqlite](https://daily.dev/tags/sqlite) [View this post on daily.dev](https://daily.dev/posts/new-in-sqlitedata-sectioned-queries-0b5mroclg)